APPS.OZF_SD_REQUEST_PUB dependencies on HZ_PARTIES

Line 1839: FROM hz_parties

1835: AND request_header_id = p_request_header_id ;
1836:
1837: CURSOR c_party_id(p_party_id IN NUMBER)IS
1838: SELECT party_id
1839: FROM hz_parties
1840: WHERE party_id = p_party_id;
1841:
1842: CURSOR c_cust_account_id(p_cust_account_id IN NUMBER)IS
1843: SELECT cust_acct.cust_account_id

Line 1844: FROM hz_parties party,

1840: WHERE party_id = p_party_id;
1841:
1842: CURSOR c_cust_account_id(p_cust_account_id IN NUMBER)IS
1843: SELECT cust_acct.cust_account_id
1844: FROM hz_parties party,
1845: hz_cust_accounts cust_acct
1846: WHERE cust_acct.party_id = party.party_id
1847: AND cust_acct.status = 'A'
1848: AND cust_acct.cust_account_id = p_cust_account_id;