APPS.OKE_UTILS dependencies on OKE_K_HEADERS

Line 830: AND Object_type = 'OKE_K_HEADERS' -- header assignments only

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
833: AND Trunc(SYSDATE) >= Trunc(Start_Date_Active)
834: AND (End_Date_Active IS NULL OR Trunc(SYSDATE) <= Trunc(End_Date_Active));

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 850: AND Object_type = 'OKE_K_HEADERS'

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
853: AND Trunc(SYSDATE) >= Trunc(Start_Date_Active)
854: AND (End_Date_Active IS NULL OR Trunc(SYSDATE) <= Trunc(End_Date_Active)))

Line 871: AND Object_type = 'OKE_K_HEADERS'

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
874: AND Trunc(SYSDATE) >= Trunc(Start_Date_Active)
875: AND (End_Date_Active IS NULL OR Trunc(SYSDATE) <= Trunc(End_Date_Active)))

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