APPS.CE_BANK_AND_ACCOUNT_VALIDATION dependencies on CE_PAYMENT_DOCUMENTS

Line 1510: from ce_payment_documents

1506: P_PAYMENT_DOC_CATEGORY_CODE := '-1';
1507:
1508: IF (P_PAYMENT_DOCUMENT_ID is not null) THEN
1509: select count(*) into p_pay_doc_count
1510: from ce_payment_documents
1511: where PAYMENT_DOCUMENT_ID = P_PAYMENT_DOCUMENT_ID;
1512:
1513: cep_standard.debug('p_pay_doc_count='||p_pay_doc_count );
1514:

Line 1518: from ce_payment_documents

1514:
1515: if (p_pay_doc_count = 1) then
1516: select nvl(PAYMENT_DOC_CATEGORY, '-1')
1517: into P_PAYMENT_DOC_CATEGORY_CODE
1518: from ce_payment_documents
1519: where PAYMENT_DOCUMENT_ID = P_PAYMENT_DOCUMENT_ID;
1520: else
1521: P_PAYMENT_DOC_CATEGORY_CODE := '-1';
1522: end if;

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

1521: P_PAYMENT_DOC_CATEGORY_CODE := '-1';
1522: end if;
1523: END IF;
1524:
1525: cep_standard.debug('ce_payment_documents P_PAYMENT_DOC_CATEGORY_CODE='||P_PAYMENT_DOC_CATEGORY_CODE );
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