APPS.OKE_UTILS dependencies on PA_PROJECT_PARTIES

Line 828: FROM PA_Project_Parties

824:
825: Cursor Get_Header_Assignments
826: IS
827: SELECT Resource_source_id
828: FROM PA_Project_Parties
829: WHERE Resource_type_id = 101 -- employees only
830: AND Object_type = 'OKE_K_HEADERS' -- header assignments only
831: AND Object_id = P_header_id -- for the requested header id only
832: AND Project_role_id = P_role_id -- for the requested role

Line 838: FROM PA_Project_Parties pr, OKE_K_Headers

834: AND (End_Date_Active IS NULL OR Trunc(SYSDATE) <= Trunc(End_Date_Active));
835: Cursor Get_Program_Assignments
836: IS
837: SELECT Resource_source_id
838: FROM PA_Project_Parties pr, OKE_K_Headers
839: WHERE Resource_type_id = 101 -- employees only
840: AND Object_type = 'OKE_PROGRAMS' -- program assignments only
841: AND Object_id = program_id -- for the program id
842: AND K_Header_id = P_header_id -- related to the requested header id

Line 848: FROM PA_Project_Parties pr1

844: AND Trunc(SYSDATE) >= Trunc(Start_Date_Active)
845: AND (End_Date_Active IS NULL OR Trunc(SYSDATE) <= Trunc(End_Date_Active))
846: and not exists ( -- Same Person shouldnot exist at contract level in any other role
847: SELECT 'x'
848: FROM PA_Project_Parties pr1
849: WHERE Resource_type_id = 101
850: AND Object_type = 'OKE_K_HEADERS'
851: AND Object_id = P_header_id
852: AnD pr.resource_id = pr1.resource_id

Line 860: FROM PA_Project_Parties pr

856:
857: Cursor Get_Site_Assignments
858: IS
859: SELECT Resource_source_id
860: FROM PA_Project_Parties pr
861: WHERE Resource_type_id = 101 -- employees only
862: AND Object_type = 'OKE_PROGRAMS' -- site assignments only
863: AND Object_id = 0 -- for the program id is 0 for site
864: AND Project_role_id = P_role_id -- for the requested role

Line 869: FROM PA_Project_Parties pr1

865: AND Trunc(SYSDATE) >= Trunc(Start_Date_Active)
866: AND (End_Date_Active IS NULL OR Trunc(SYSDATE) <= Trunc(End_Date_Active))
867: and not exists ( -- Same Person shouldnot exist at contract level in any other role
868: SELECT 'x'
869: FROM PA_Project_Parties pr1
870: WHERE Resource_type_id = 101
871: AND Object_type = 'OKE_K_HEADERS'
872: AND Object_id = P_header_id
873: AnD pr.resource_id = pr1.resource_id

Line 878: FROM PA_Project_Parties pr2, OKE_K_Headers

874: AND Trunc(SYSDATE) >= Trunc(Start_Date_Active)
875: AND (End_Date_Active IS NULL OR Trunc(SYSDATE) <= Trunc(End_Date_Active)))
876: and not exists ( -- Same Person shouldnot exist at program level in any other role
877: SELECT 'x'
878: FROM PA_Project_Parties pr2, OKE_K_Headers
879: WHERE Resource_type_id = 101
880: AND Object_type = 'OKE_PROGRAMS'
881: AND Object_id = program_id
882: AND K_Header_id = P_header_id