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 327: FROM hz_cust_accounts ca

323: l_plan_type VARCHAR2(30);
324:
325: CURSOR csr_cust_name(cv_cust_account_id IN NUMBER) IS
326: SELECT CONCAT(CONCAT(party.party_name, ' ('), CONCAT(ca.account_number, ') '))
327: FROM hz_cust_accounts ca
328: , hz_parties party
329: WHERE ca.party_id = party.party_id
330: AND ca.cust_account_id = cv_cust_account_id;
331:

Line 909: FROM hz_cust_accounts ca

905: AND organization_id = FND_PROFILE.VALUE('AMS_ITEM_ORGANIZATION_ID');
906:
907: CURSOR csr_cust_name(cv_cust_account_id IN NUMBER) IS
908: SELECT CONCAT(CONCAT(party.party_name, ' ('), CONCAT(ca.account_number, ') '))
909: FROM hz_cust_accounts ca
910: , hz_parties party
911: WHERE ca.party_id = party.party_id
912: AND ca.cust_account_id = cv_cust_account_id;
913:

Line 916: FROM hz_cust_accounts

912: AND ca.cust_account_id = cv_cust_account_id;
913:
914: CURSOR csr_get_party_id(cv_cust_account_id IN NUMBER) IS
915: SELECT party_id
916: FROM hz_cust_accounts
917: WHERE cust_account_id = cv_cust_account_id;
918:
919: CURSOR csr_party_name(cv_party_id IN NUMBER) IS
920: SELECT party_name