APPS.CE_BANK_AND_ACCOUNT_VALIDATION dependencies on CE_PAYMENT_DOCUMENTS

Line 1495: from ce_payment_documents

1491: P_PAYMENT_DOC_CATEGORY_CODE := '-1';
1492:
1493: IF (P_PAYMENT_DOCUMENT_ID is not null) THEN
1494: select count(*) into p_pay_doc_count
1495: from ce_payment_documents
1496: where PAYMENT_DOCUMENT_ID = P_PAYMENT_DOCUMENT_ID;
1497:
1498: cep_standard.debug('p_pay_doc_count='||p_pay_doc_count );
1499:

Line 1503: from ce_payment_documents

1499:
1500: if (p_pay_doc_count = 1) then
1501: select nvl(PAYMENT_DOC_CATEGORY, '-1')
1502: into P_PAYMENT_DOC_CATEGORY_CODE
1503: from ce_payment_documents
1504: where PAYMENT_DOCUMENT_ID = P_PAYMENT_DOCUMENT_ID;
1505: else
1506: P_PAYMENT_DOC_CATEGORY_CODE := '-1';
1507: end if;

Line 1510: cep_standard.debug('ce_payment_documents P_PAYMENT_DOC_CATEGORY_CODE='||P_PAYMENT_DOC_CATEGORY_CODE );

1506: P_PAYMENT_DOC_CATEGORY_CODE := '-1';
1507: end if;
1508: END IF;
1509:
1510: cep_standard.debug('ce_payment_documents P_PAYMENT_DOC_CATEGORY_CODE='||P_PAYMENT_DOC_CATEGORY_CODE );
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