DBA Data[Home] [Help]

APPS.IBY_PAYINSTR_PUB dependencies on HZ_CODE_ASSIGNMENTS

Line 232: prev_rfc_identifier hz_code_assignments.class_code%TYPE;

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

Line 252: curr_rfc_identifier hz_code_assignments.class_code%TYPE;

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

Line 833: || 'HZ_CODE_ASSIGNMENTS rfc_ca, '

829: || 'IBY_PAY_SERVICE_REQUESTS prq, '
830: || 'IBY_SYS_PMT_PROFILES_B sppf, '
831: || 'IBY_ACCT_PMT_PROFILES_B appf, '
832: || 'HZ_PARTIES branch_party, '
833: || 'HZ_CODE_ASSIGNMENTS rfc_ca, '
834: || 'CE_BANK_ACCOUNTS bank_accts '
835: || 'WHERE '
836: || 'pmts.payment_status = :pmt_status AND '
837: || 'sppf.processing_type = :processing_type AND '