DBA Data[Home] [Help]

APPS.IBY_PAYINSTR_PUB dependencies on HZ_CODE_ASSIGNMENTS

Line 230: prev_rfc_identifier hz_code_assignments.class_code%TYPE;

226: prev_pmt_function iby_payments_all.payment_function%TYPE;
227: prev_pmt_reason_code iby_payments_all.payment_reason_code%TYPE;
228: prev_pmt_reason_commt iby_payments_all.payment_reason_comments%TYPE;
229: prev_prom_note_flag iby_payments_all.bill_payable_flag%TYPE;
230: prev_rfc_identifier hz_code_assignments.class_code%TYPE;
231: prev_pmt_method_code iby_payments_all.payment_method_code%TYPE;
232: prev_ppr_id iby_payments_all.payment_service_request_id%TYPE;
233:
234: /* current payment attributes */

Line 250: curr_rfc_identifier hz_code_assignments.class_code%TYPE;

246: curr_pmt_function iby_payments_all.payment_function%TYPE;
247: curr_pmt_reason_code iby_payments_all.payment_reason_code%TYPE;
248: curr_pmt_reason_commt iby_payments_all.payment_reason_comments%TYPE;
249: curr_prom_note_flag iby_payments_all.bill_payable_flag%TYPE;
250: curr_rfc_identifier hz_code_assignments.class_code%TYPE;
251: curr_pmt_method_code iby_payments_all.payment_method_code%TYPE;
252: curr_ppr_id iby_payments_all.payment_service_request_id%TYPE;
253:
254: l_sql_chunk VARCHAR2(3000);

Line 718: || 'HZ_CODE_ASSIGNMENTS rfc_ca, '

714: || 'IBY_PAY_SERVICE_REQUESTS prq, '
715: || 'IBY_SYS_PMT_PROFILES_B sppf, '
716: || 'IBY_ACCT_PMT_PROFILES_B appf, '
717: || 'HZ_PARTIES branch_party, '
718: || 'HZ_CODE_ASSIGNMENTS rfc_ca, '
719: || 'CE_BANK_ACCOUNTS bank_accts '
720: || 'WHERE '
721: || 'pmts.payment_status = :pmt_status AND '
722: || 'sppf.processing_type = :processing_type AND '