eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_CUSTOMERS_CONTACTS_PVT dependencies on HZ_RELATIONSHIPS

Line 712: -- changed hz_party_relationships usage to hz_relationships

708: WHERE project_id = p_project_id AND
709: customer_id = p_customer_id;
710:
711: -- 4616302 TCA UPTAKE: HZ_PARTY_RELATIONS IMPACTS
712: -- changed hz_party_relationships usage to hz_relationships
713: -- changed column party_relationship_type usage to relationship_type
714:
715: /*
716: CURSOR c_ext_people_exists(c_project_party_id NUMBER) IS

Line 735: hz_relationships hzr

731: CURSOR c_ext_people_exists(c_project_party_id NUMBER) IS
732: SELECT pp.project_party_id project_party_id
733: FROM pa_project_parties po,
734: pa_project_parties pp,
735: hz_relationships hzr
736: WHERE po.resource_type_id = 112
737: AND po.project_party_id = c_project_party_id
738: AND pp.resource_type_id = 112
739: AND pp.object_type = po.object_type