APPS.OZF_AUTOPAY_PVT dependencies on HZ_PARTIES

Line 108: , hz_parties party

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:
112: l_cust_account_id number := p_customer_info.cust_account_id;

Line 300: , hz_parties party

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:
304: l_cust_name_num VARCHAR2(70);

Line 865: , hz_parties party

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:
869: CURSOR csr_get_party_id(cv_cust_account_id IN NUMBER) IS

Line 876: FROM hz_parties

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
876: FROM hz_parties
877: WHERE party_id = cv_party_id;
878:
879: CURSOR csr_offer_pay_name(cv_payment_method IN VARCHAR2) IS
880: SELECT meaning