oracle付款问题,付款处理配置文件问题

--内部银行

SELECT *

FROM

(SELECT ApplicablePmtProfEO.APPLICABLE_TYPE_CODE,

ApplicablePmtProfEO.APPLICABLE_VALUE_TO,

ApplicablePmtProfEO.APPLICABLE_PMT_PROF_ID,

ApplicablePmtProfEO.SYSTEM_PROFILE_CODE,

ba.bank_account_name,

DECODE(NVL(

(SELECT 'Y'

FROM dual

WHERE EXISTS

(SELECT 'x'

FROM CE_BANK_ACCOUNTS

WHERE bank_account_id = applicable_value_to

)

), 'N'), 'N', 'IntBADeleteDisabled', 'IntBADeleteEnabled') AS DELETE_SWITCHER

/* decode(IBY_FD_PPP_UI_UTILS.is_int_ba_accessible(APPLICABLE_VALUE_TO), 'N', 'IntBADeleteDisabled', 'IntBADeleteEnabled') AS DELETE_SWITCHER */

FROM IBY_APPLICABLE_PMT_PROFS ApplicablePmtProfEO,

APPS.CE_BANK_ACCOUNTS ba

WHERE ba.bank_account_id = APPLICABLE_VALUE_TO

AND APPLICABLE_TYPE_CODE = 'INTERNAL_BANK_ACCOUNT'

) QRSLT

WHERE SYSTEM_PROFILE_CODE = 'IBY_PAY_CHK_AR_9954' ;

--币种

SELECT *

FROM

(SELECT ApplicablePmtProfEO.APPLICABLE_TYPE_CODE,

ApplicablePmtProfEO.APPLICABLE_PMT_PROF_ID,

ApplicablePmtProfEO.APPLICABLE_VALUE_TO,

ApplicablePmtProfEO.SYSTEM_PROFILE_CODE,

c.currency_code,

c.name currency_name

FROM IBY_APPLICABLE_PMT_PROFS ApplicablePmtProfEO,

fnd_currencies_vl c

WHERE c.currency_code    = APPLICABLE_VALUE_TO

AND APPLICABLE_TYPE_CODE = 'CURRENCY_CODE'

) QRSLT

WHERE SYSTEM_PROFILE_CODE = 'IBY_PAY_CHK_AR_9954';