APPS.OZF_AUTOPAY_PVT dependencies on HZ_CUST_ACCOUNTS

Line 107: FROM hz_cust_accounts ca

103: )
104: IS
105: CURSOR csr_cust_name(cv_cust_account_id IN NUMBER) IS
106: SELECT CONCAT(CONCAT(party.party_name, ' ('), CONCAT(ca.account_number, ') '))
107: FROM hz_cust_accounts ca
108: , hz_parties party
109: WHERE ca.party_id = party.party_id
110: AND ca.cust_account_id = cv_cust_account_id;
111:

Line 299: FROM hz_cust_accounts ca

295: l_plan_type VARCHAR2(30);
296:
297: CURSOR csr_cust_name(cv_cust_account_id IN NUMBER) IS
298: SELECT CONCAT(CONCAT(party.party_name, ' ('), CONCAT(ca.account_number, ') '))
299: FROM hz_cust_accounts ca
300: , hz_parties party
301: WHERE ca.party_id = party.party_id
302: AND ca.cust_account_id = cv_cust_account_id;
303:

Line 864: FROM hz_cust_accounts ca

860: AND organization_id = FND_PROFILE.VALUE('AMS_ITEM_ORGANIZATION_ID');
861:
862: CURSOR csr_cust_name(cv_cust_account_id IN NUMBER) IS
863: SELECT CONCAT(CONCAT(party.party_name, ' ('), CONCAT(ca.account_number, ') '))
864: FROM hz_cust_accounts ca
865: , hz_parties party
866: WHERE ca.party_id = party.party_id
867: AND ca.cust_account_id = cv_cust_account_id;
868:

Line 871: FROM hz_cust_accounts

867: AND ca.cust_account_id = cv_cust_account_id;
868:
869: CURSOR csr_get_party_id(cv_cust_account_id IN NUMBER) IS
870: SELECT party_id
871: FROM hz_cust_accounts
872: WHERE cust_account_id = cv_cust_account_id;
873:
874: CURSOR csr_party_name(cv_party_id IN NUMBER) IS
875: SELECT party_name