APPS.SR_UWQ_INTEG dependencies on HZ_CUST_ACCOUNTS

Line 1200: from hz_cust_accounts acc, hz_parties party

1196: --Validate the Account Number.
1197: cursor account_cursor is
1198: select acc.cust_account_id,acc.party_id,
1199: party.party_type
1200: from hz_cust_accounts acc, hz_parties party
1201: where acc.account_number = p_parameter_value
1202: and acc.status = 'A'
1203: and party.party_id = acc.party_id;
1204:

Line 1423: from hz_cust_accounts acc

1419:
1420: --Retrieve the Account Number.
1421: cursor account_cursor is
1422: select acc.account_number
1423: from hz_cust_accounts acc
1424: where acc.cust_account_id = p_cust_account_id
1425: and acc.status = 'A';
1426:
1427: --Retrieve the Party Number.