DBA Data[Home] [Help]

APPS.ARP_PROCESS_CHARGEBACK dependencies on HZ_PARTIES

Line 2659: l_party_id hz_parties.party_id%type;

2655:
2656: l_customer_id ra_customer_trx.paying_customer_id%type;
2657: l_customer_site_use_id ra_customer_trx.paying_site_use_id%type;
2658: l_org_id ra_customer_trx.org_id%type;
2659: l_party_id hz_parties.party_id%type;
2660: l_trx_number ra_customer_trx.trx_number%type;
2661: l_payment_channel_code ar_receipt_methods.payment_channel_code%type;
2662: l_customer_trx_id ra_customer_trx.customer_trx_id%type;
2663:

Line 2683: FROM hz_cust_accounts hca, hz_parties party

2679: l_customer_id := p_customer_id;
2680:
2681: SELECT party.party_id
2682: INTO l_party_id
2683: FROM hz_cust_accounts hca, hz_parties party
2684: WHERE hca.party_id = party.party_id
2685: AND hca.cust_account_id = l_customer_id;
2686:
2687: arp_standard.debug('l_party_id: '|| l_party_id);