DBA Data[Home] [Help]

APPS.AR_AUTOREC_API dependencies on HZ_PARTIES

Line 1197: p_customer_name_l IN hz_parties.party_name%TYPE, --Bug6734688

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
1201: p_receipt_method_id IN ar_receipt_methods.receipt_method_id%TYPE,

Line 1198: p_customer_name_h IN hz_parties.party_name%TYPE, --Bug6734688

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
1201: p_receipt_method_id IN ar_receipt_methods.receipt_method_id%TYPE,
1202: p_payment_schedule_id OUT NOCOPY ar_payment_schedules.payment_schedule_id%TYPE,

Line 1313: l_sel_stmt := l_sel_stmt|| ', hz_parties party ';

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;
1315: END IF;
1316:
1317: l_sel_stmt := l_sel_stmt || --Bug6734688