APPS.CE_BANK_AND_ACCOUNT_VALIDATION dependencies on CE_AP_PM_DOC_CATEGORIES

Line 1530: from ce_ap_pm_doc_categories

1526:
1527: IF (P_PAYMENT_DOC_CATEGORY_CODE = '-1') THEN
1528: IF (P_PAYMENT_METHOD_CODE is not null and P_BANK_ACCT_USE_ID is not null) THEN
1529: select count(*) into p_ap_doc_cat_count
1530: from ce_ap_pm_doc_categories
1531: where BANK_ACCT_USE_ID = P_BANK_ACCT_USE_ID
1532: and PAYMENT_METHOD_CODE = P_PAYMENT_METHOD_CODE;
1533:
1534: if (p_ap_doc_cat_count = 1) then

Line 1537: from ce_ap_pm_doc_categories

1533:
1534: if (p_ap_doc_cat_count = 1) then
1535: select nvl(PAYMENT_DOC_CATEGORY, '-1')
1536: into P_PAYMENT_DOC_CATEGORY_CODE
1537: from ce_ap_pm_doc_categories
1538: where BANK_ACCT_USE_ID = P_BANK_ACCT_USE_ID
1539: and PAYMENT_METHOD_CODE = P_PAYMENT_METHOD_CODE;
1540: else
1541: P_PAYMENT_DOC_CATEGORY_CODE := '-1';

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

1540: else
1541: P_PAYMENT_DOC_CATEGORY_CODE := '-1';
1542: end if;
1543:
1544: cep_standard.debug('ce_ap_pm_doc_categories P_PAYMENT_DOC_CATEGORY_CODE='||P_PAYMENT_DOC_CATEGORY_CODE );
1545:
1546: END IF;
1547: END IF;
1548: