DBA Data[Home] [Help]

APPS.AR_AME_CM_ATTRIBUTES_API dependencies on HZ_PARTIES

Line 16: hz_parties party,

12:
13: CURSOR cust_id (p_txn_id NUMBER) IS
14: SELECT rct.bill_to_customer_id
15: FROM hz_cust_accounts bill_to_cust,
16: hz_parties party,
17: ra_customer_trx rct
18: WHERE rct.bill_to_customer_id = bill_to_cust.cust_account_id
19: AND bill_to_cust.party_id = party.party_id
20: AND rct.customer_trx_id =

Line 89: hz_parties party,

85:
86: CURSOR bill_id (p_txn_id NUMBER) IS
87: SELECT rct.bill_to_site_use_id
88: FROM hz_cust_accounts bill_to_cust,
89: hz_parties party,
90: ra_customer_trx rct
91: WHERE rct.bill_to_customer_id = bill_to_cust.cust_account_id
92: AND bill_to_cust.party_id = party.party_id
93: AND rct.customer_trx_id =