APPS.OZF_SD_REQUEST_PUB dependencies on HZ_PARTIES

Line 2239: FROM hz_parties

2235: AND request_header_id = p_request_header_id ;
2236:
2237: CURSOR c_party_id(p_party_id IN NUMBER)IS
2238: SELECT party_id
2239: FROM hz_parties
2240: WHERE party_id = p_party_id;
2241:
2242: CURSOR c_cust_account_id(p_cust_account_id IN NUMBER)IS
2243: SELECT cust_acct.cust_account_id

Line 2244: FROM hz_parties party,

2240: WHERE party_id = p_party_id;
2241:
2242: CURSOR c_cust_account_id(p_cust_account_id IN NUMBER)IS
2243: SELECT cust_acct.cust_account_id
2244: FROM hz_parties party,
2245: hz_cust_accounts cust_acct
2246: WHERE cust_acct.party_id = party.party_id
2247: AND cust_acct.status = 'A'
2248: AND cust_acct.cust_account_id = p_cust_account_id;