APPS.CE_BANK_AND_ACCOUNT_VALIDATION dependencies on CE_AP_PM_DOC_CATEGORIES

Line 1515: from ce_ap_pm_doc_categories

1511:
1512: IF (P_PAYMENT_DOC_CATEGORY_CODE = '-1') THEN
1513: IF (P_PAYMENT_METHOD_CODE is not null and P_BANK_ACCT_USE_ID is not null) THEN
1514: select count(*) into p_ap_doc_cat_count
1515: from ce_ap_pm_doc_categories
1516: where BANK_ACCT_USE_ID = P_BANK_ACCT_USE_ID
1517: and PAYMENT_METHOD_CODE = P_PAYMENT_METHOD_CODE;
1518:
1519: if (p_ap_doc_cat_count = 1) then

Line 1522: from ce_ap_pm_doc_categories

1518:
1519: if (p_ap_doc_cat_count = 1) then
1520: select nvl(PAYMENT_DOC_CATEGORY, '-1')
1521: into P_PAYMENT_DOC_CATEGORY_CODE
1522: from ce_ap_pm_doc_categories
1523: where BANK_ACCT_USE_ID = P_BANK_ACCT_USE_ID
1524: and PAYMENT_METHOD_CODE = P_PAYMENT_METHOD_CODE;
1525: else
1526: P_PAYMENT_DOC_CATEGORY_CODE := '-1';

Line 1529: cep_standard.debug('ce_ap_pm_doc_categories P_PAYMENT_DOC_CATEGORY_CODE='||P_PAYMENT_DOC_CATEGORY_CODE );

1525: else
1526: P_PAYMENT_DOC_CATEGORY_CODE := '-1';
1527: end if;
1528:
1529: cep_standard.debug('ce_ap_pm_doc_categories P_PAYMENT_DOC_CATEGORY_CODE='||P_PAYMENT_DOC_CATEGORY_CODE );
1530:
1531: END IF;
1532: END IF;
1533: