APPS.PA_PLANNING_RESOURCE_UTILS dependencies on PER_JOBS

Line 851: FROM per_jobs

847: l_num_ids NUMBER := 0;
848:
849: Cursor c_ids IS
850: SELECT job_id
851: FROM per_jobs
852: WHERE name = p_job_name
853: AND job_group_id = p_job_group_id;
854: BEGIN
855: x_return_status:= FND_API.G_RET_STS_SUCCESS;

Line 872: FROM per_jobs

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

Line 926: FROM per_jobs

922: IF (p_job_name IS NOT NULL) THEN
923: BEGIN
924: SELECT job_id
925: INTO x_job_id
926: FROM per_jobs
927: WHERE name = p_job_name
928: AND job_group_id = p_job_group_id;
929: EXCEPTION
930: WHEN OTHERS THEN

Line 2941: Per_Jobs

2937: Cursor c_Job (P_Job_Id In Number) Is
2938: Select
2939: Name
2940: From
2941: Per_Jobs
2942: Where
2943: Job_Id = P_Job_Id
2944: And ( (Pa_Cross_Business_Grp.IsCrossBGProfile = 'N' AND
2945: Fnd_Profile.Value('PER_BUSINESS_GROUP_ID') = Per_Jobs.Business_Group_Id )

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

2941: Per_Jobs
2942: Where
2943: Job_Id = P_Job_Id
2944: And ( (Pa_Cross_Business_Grp.IsCrossBGProfile = 'N' AND
2945: Fnd_Profile.Value('PER_BUSINESS_GROUP_ID') = Per_Jobs.Business_Group_Id )
2946: OR Pa_Cross_Business_Grp.IsCrossBGProfile = 'Y');
2947:
2948: Cursor c_PersonType (P_Person_Type IN Varchar2) Is
2949: Select

Line 4239: Per_Jobs

4235: Cursor c_Job (P_Job_Id In Number) Is
4236: Select
4237: Name
4238: From
4239: Per_Jobs
4240: Where
4241: Job_Id = P_Job_Id
4242: And ( (Pa_Cross_Business_Grp.IsCrossBGProfile = 'N' AND
4243: Fnd_Profile.Value('PER_BUSINESS_GROUP_ID') = Business_Group_Id )

Line 5626: from per_jobs

5622:
5623: CURSOR chk_job_in_job_group(p_job_group_id IN NUMBER,
5624: p_Job_ID in NUMBER) IS
5625: select 'Y'
5626: from per_jobs
5627: where job_group_id = p_job_group_id
5628: and Job_ID = p_Job_ID;
5629:
5630: CURSOR get_res_list_id(p_res_member_id in NUMBER) is

Line 6951: FROM per_jobs

6947: WHERE resource_list_id = l_resource_list_id;
6948:
6949: SELECT 'Y'
6950: INTO l_valid_job
6951: FROM per_jobs
6952: WHERE job_id = l_job_id
6953: AND job_group_id = l_job_group_id;
6954:
6955: EXCEPTION WHEN NO_DATA_FOUND THEN