APPS.JG_ZZ_TURNOVER_AR_PKG dependencies on HZ_PARTIES

Line 261: FROM hz_parties hp,

257: SELECT hp.primary_phone_number PHONE_NUMBER
258: ,hp.email_address EMAIL_ADDRESS
259: INTO l_phone_number
260: ,l_email_address
261: FROM hz_parties hp,
262: (SELECT subject_id
263: FROM hz_relationships
264: WHERE object_id = (
265: SELECT party_id