DBA Data[Home] [Help]

APPS.PV_PRGM_APPROVAL_PVT dependencies on HZ_PARTIES

Line 2180: ,hz_parties PARTNER

2176: FROM pv_partner_program_vl ppvl
2177: ,fnd_lookups fl
2178: ,pv_pg_enrl_requests pper
2179: ,pv_partner_profiles ppp
2180: ,hz_parties PARTNER
2181: WHERE pper.partner_id = ppp.partner_id
2182: AND ppp.partner_id=PARTNER.party_id
2183: AND fl.lookup_type='PV_ENROLLMENT_REQUEST_TYPE'
2184: AND fl.lookup_code = pper.enrollment_type_code

Line 2195: ,hz_parties PARTNER

2191: FROM pv_partner_program_vl ppvl
2192: ,fnd_lookups fl
2193: ,pv_pg_enrl_requests pper
2194: ,pv_partner_profiles ppp
2195: ,hz_parties PARTNER
2196:
2197: WHERE pper.partner_id = ppp.partner_id
2198: AND ppp.partner_party_id=PARTNER.party_id
2199: AND fl.lookup_type='PV_ENROLLMENT_REQUEST_TYPE'