DBA Data[Home] [Help]

APPS.PA_PROJECT_PARTIES_PVT dependencies on HZ_RELATIONSHIPS

Line 917: -- changed hz_party_relationships usage to hz_relationships

913: l_grant_id RAW(16); ------NUMBER;
914: API_ERROR EXCEPTION;
915:
916: -- 4616302 TCA UPTAKE: HZ_PARTY_RELATIONS IMPACTS
917: -- changed hz_party_relationships usage to hz_relationships
918: -- changed column party_relationship_type usage to relationship_type
919:
920: /*
921: CURSOR c_ext_people IS

Line 942: hz_relationships hzr

938: SELECT pp.project_party_id project_party_id,
939: pp.record_version_number record_version_number
940: FROM pa_project_parties po,
941: pa_project_parties pp,
942: hz_relationships hzr
943: WHERE po.resource_type_id = 112
944: AND po.project_party_id = p_project_party_id
945: AND pp.resource_type_id = 112
946: AND pp.object_type = po.object_type