DBA Data[Home] [Help]

APPS.AR_AME_CM_ATTRIBUTES_API dependencies on HZ_CUST_ACCOUNTS

Line 15: FROM hz_cust_accounts bill_to_cust,

11: RETURN NUMBER IS
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

Line 88: FROM hz_cust_accounts bill_to_cust,

84: RETURN NUMBER IS
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