DBA Data[Home] [Help]

APPS.AR_AUTOREC_API dependencies on HZ_PARTIES

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

1568: p_doc_num_l IN ra_customer_trx.doc_sequence_value%TYPE,
1569: p_doc_num_h IN ra_customer_trx.doc_sequence_value%TYPE,
1570: p_customer_number_l IN hz_cust_accounts.account_number%TYPE, --Bug6734688
1571: p_customer_number_h IN hz_cust_accounts.account_number%TYPE, --Bug6734688
1572: p_customer_name_l IN hz_parties.party_name%TYPE, --Bug6734688
1573: p_customer_name_h IN hz_parties.party_name%TYPE, --Bug6734688
1574: p_batch_id IN ar_batches.batch_id%TYPE,
1575: p_approve_only_flag IN VARCHAR2 ,--Bug5344405
1576: p_receipt_method_id IN ar_receipt_methods.receipt_method_id%TYPE,

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

1569: p_doc_num_h IN ra_customer_trx.doc_sequence_value%TYPE,
1570: p_customer_number_l IN hz_cust_accounts.account_number%TYPE, --Bug6734688
1571: p_customer_number_h IN hz_cust_accounts.account_number%TYPE, --Bug6734688
1572: p_customer_name_l IN hz_parties.party_name%TYPE, --Bug6734688
1573: p_customer_name_h IN hz_parties.party_name%TYPE, --Bug6734688
1574: p_batch_id IN ar_batches.batch_id%TYPE,
1575: p_approve_only_flag IN VARCHAR2 ,--Bug5344405
1576: p_receipt_method_id IN ar_receipt_methods.receipt_method_id%TYPE,
1577: p_total_workers IN NUMBER DEFAULT 1

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

1698: OR p_customer_name_l IS NOT NULL OR p_customer_name_h IS NOT NULL THEN
1699: l_sel_stmt := l_sel_stmt|| ', hz_cust_accounts cust_acct ';
1700:
1701: IF p_customer_name_l IS NOT NULL OR p_customer_name_h IS NOT NULL THEN
1702: l_sel_stmt := l_sel_stmt|| ', hz_parties party ';
1703: END IF;
1704: END IF;
1705:
1706: l_sel_stmt := l_sel_stmt || --Bug6734688