DBA Data[Home] [Help]

APPS.AR_AUTOREC_API dependencies on HZ_CUST_ACCOUNTS

Line 1195: p_customer_number_l IN hz_cust_accounts.account_number%TYPE, --Bug6734688

1191: p_trx_num_l IN ar_payment_schedules.trx_number%TYPE,
1192: p_trx_num_h IN ar_payment_schedules.trx_number%TYPE,
1193: p_doc_num_l IN ra_customer_trx.doc_sequence_value%TYPE,
1194: p_doc_num_h IN ra_customer_trx.doc_sequence_value%TYPE,
1195: p_customer_number_l IN hz_cust_accounts.account_number%TYPE, --Bug6734688
1196: p_customer_number_h IN hz_cust_accounts.account_number%TYPE, --Bug6734688
1197: p_customer_name_l IN hz_parties.party_name%TYPE, --Bug6734688
1198: p_customer_name_h IN hz_parties.party_name%TYPE, --Bug6734688
1199: p_batch_id IN ar_batches.batch_id%TYPE,

Line 1196: p_customer_number_h IN hz_cust_accounts.account_number%TYPE, --Bug6734688

1192: p_trx_num_h IN ar_payment_schedules.trx_number%TYPE,
1193: p_doc_num_l IN ra_customer_trx.doc_sequence_value%TYPE,
1194: p_doc_num_h IN ra_customer_trx.doc_sequence_value%TYPE,
1195: p_customer_number_l IN hz_cust_accounts.account_number%TYPE, --Bug6734688
1196: p_customer_number_h IN hz_cust_accounts.account_number%TYPE, --Bug6734688
1197: p_customer_name_l IN hz_parties.party_name%TYPE, --Bug6734688
1198: p_customer_name_h IN hz_parties.party_name%TYPE, --Bug6734688
1199: p_batch_id IN ar_batches.batch_id%TYPE,
1200: p_approve_only_flag IN VARCHAR2 ,--Bug5344405

Line 1310: l_sel_stmt := l_sel_stmt|| ', hz_cust_accounts cust_acct ';

1306: ar_payment_schedules_all ps1 ';
1307: --Bug6734688
1308: IF p_customer_number_l IS NOT NULL OR p_customer_number_h IS NOT NULL
1309: OR p_customer_name_l IS NOT NULL OR p_customer_name_h IS NOT NULL THEN
1310: l_sel_stmt := l_sel_stmt|| ', hz_cust_accounts cust_acct ';
1311:
1312: IF p_customer_name_l IS NOT NULL OR p_customer_name_h IS NOT NULL THEN
1313: l_sel_stmt := l_sel_stmt|| ', hz_parties party ';
1314: END IF;