APPS.PA_PLANNING_RESOURCE_UTILS dependencies on PER_JOBS

Line 855: FROM per_jobs

851: l_num_ids NUMBER := 0;
852:
853: Cursor c_ids IS
854: SELECT job_id
855: FROM per_jobs
856: WHERE name = p_job_name
857: AND job_group_id = p_job_group_id;
858: BEGIN
859: x_return_status:= FND_API.G_RET_STS_SUCCESS;

Line 876: FROM per_jobs

872: IF (p_check_id_flag = 'Y' OR p_check_id_flag='N') THEN
873: BEGIN
874: SELECT job_id
875: INTO x_job_id
876: FROM per_jobs
877: WHERE job_id = p_job_id
878: AND job_group_id = p_job_group_id;
879: EXCEPTION
880: WHEN OTHERS THEN

Line 930: FROM per_jobs

926: IF (p_job_name IS NOT NULL) THEN
927: BEGIN
928: SELECT job_id
929: INTO x_job_id
930: FROM per_jobs
931: WHERE name = p_job_name
932: AND job_group_id = p_job_group_id;
933: EXCEPTION
934: WHEN OTHERS THEN

Line 2982: Per_Jobs

2978: Cursor c_Job (P_Job_Id In Number) Is
2979: Select
2980: Name
2981: From
2982: Per_Jobs
2983: Where
2984: Job_Id = P_Job_Id
2985: And ( (Pa_Cross_Business_Grp.IsCrossBGProfile = 'N' AND
2986: Fnd_Profile.Value('PER_BUSINESS_GROUP_ID') = Per_Jobs.Business_Group_Id )

Line 2986: Fnd_Profile.Value('PER_BUSINESS_GROUP_ID') = Per_Jobs.Business_Group_Id )

2982: Per_Jobs
2983: Where
2984: Job_Id = P_Job_Id
2985: And ( (Pa_Cross_Business_Grp.IsCrossBGProfile = 'N' AND
2986: Fnd_Profile.Value('PER_BUSINESS_GROUP_ID') = Per_Jobs.Business_Group_Id )
2987: OR Pa_Cross_Business_Grp.IsCrossBGProfile = 'Y');
2988:
2989: Cursor c_PersonType (P_Person_Type IN Varchar2) Is
2990: Select

Line 4280: Per_Jobs

4276: Cursor c_Job (P_Job_Id In Number) Is
4277: Select
4278: Name
4279: From
4280: Per_Jobs
4281: Where
4282: Job_Id = P_Job_Id
4283: And ( (Pa_Cross_Business_Grp.IsCrossBGProfile = 'N' AND
4284: Fnd_Profile.Value('PER_BUSINESS_GROUP_ID') = Business_Group_Id )

Line 5711: from per_jobs

5707:
5708: CURSOR chk_job_in_job_group(p_job_group_id IN NUMBER,
5709: p_Job_ID in NUMBER) IS
5710: select 'Y'
5711: from per_jobs
5712: where job_group_id = p_job_group_id
5713: and Job_ID = p_Job_ID;
5714:
5715: CURSOR get_res_list_id(p_res_member_id in NUMBER) is

Line 7109: FROM per_jobs

7105: WHERE resource_list_id = l_resource_list_id;
7106:
7107: SELECT 'Y'
7108: INTO l_valid_job
7109: FROM per_jobs
7110: WHERE job_id = l_job_id
7111: AND job_group_id = l_job_group_id;
7112:
7113: EXCEPTION WHEN NO_DATA_FOUND THEN