DBA Data[Home] [Help]

APPS.PA_PROJECT_PARTIES_PVT dependencies on HZ_RELATIONSHIPS

Line 954: -- changed hz_party_relationships usage to hz_relationships

950: l_grant_id RAW(16); ------NUMBER;
951: API_ERROR EXCEPTION;
952:
953: -- 4616302 TCA UPTAKE: HZ_PARTY_RELATIONS IMPACTS
954: -- changed hz_party_relationships usage to hz_relationships
955: -- changed column party_relationship_type usage to relationship_type
956:
957: /*
958: CURSOR c_ext_people IS

Line 979: hz_relationships hzr

975: SELECT pp.project_party_id project_party_id,
976: pp.record_version_number record_version_number
977: FROM pa_project_parties po,
978: pa_project_parties pp,
979: hz_relationships hzr
980: WHERE po.resource_type_id = 112
981: AND po.project_party_id = p_project_party_id
982: AND pp.resource_type_id = 112
983: AND pp.object_type = po.object_type