DBA Data[Home] [Help]

APPS.AP_PMT_VALIDATIONS_PKG dependencies on IBY_PAYMENTS_ALL

Line 31: l_process_type IBY_PAYMENTS_ALL.PROCESS_TYPE%TYPE;

27: l_bank_acct_use_id NUMBER;
28: l_seq_num_profile VARCHAR2(80);
29: l_doc_category_code VARCHAR2(30);
30: l_sse_cc_payment_notify VARCHAR2(1);
31: l_process_type IBY_PAYMENTS_ALL.PROCESS_TYPE%TYPE;
32:
33: CURSOR check_sequences
34: IS
35: SELECT pmt.payment_id,

Line 59: FROM iby_payments_all

55:
56: /* The processing type of the documents will determine the validations to be performed */
57: SELECT process_type
58: INTO l_process_type
59: FROM iby_payments_all
60: WHERE completed_pmts_group_id = p_completed_pmts_group_id
61: AND rownum =1;
62:
63: /* Process_type IMMEDIATE is used for quick checks.

Line 252: FROM iby_payments_all

248: INTO l_iby_doc_count
249: FROM iby_fd_docs_payable_v
250: WHERE payment_id IN
251: (SELECT payment_id
252: FROM iby_payments_all
253: WHERE completed_pmts_group_id = p_completed_pmts_group_id
254: );
255:
256: --PAYMENT_SCHEDULE and SELECTED INVOICE COUNT