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: --Added cursor for Bug 16301629, to check if both vendor and vendor site is active

Line 328: , hz_parties party

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

Line 910: , hz_parties party

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

Line 921: FROM hz_parties

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
921: FROM hz_parties
922: WHERE party_id = cv_party_id;
923:
924: CURSOR csr_offer_pay_name(cv_payment_method IN VARCHAR2) IS
925: SELECT meaning