APPS.PA_PLANNING_RESOURCE_UTILS dependencies on PA_CROSS_BUSINESS_GRP

Line 787: AND ((PA_CROSS_BUSINESS_GRP.IsCrossBGProfile = 'Y') OR

783: FROM per_all_people_f per
784: WHERE
785: --sysdate BETWEEN effective_start_date AND effective_end_date
786: (current_employee_flag = 'Y' or CURRENT_NPW_FLAG = 'Y')
787: AND ((PA_CROSS_BUSINESS_GRP.IsCrossBGProfile = 'Y') OR
788: ((PA_CROSS_BUSINESS_GRP.IsCrossBGProfile = 'N') AND
789: fnd_profile.value('PER_BUSINESS_GROUP_ID') =
790: BUSINESS_GROUP_ID))
791: AND person_id = l_person_id

Line 788: ((PA_CROSS_BUSINESS_GRP.IsCrossBGProfile = 'N') AND

784: WHERE
785: --sysdate BETWEEN effective_start_date AND effective_end_date
786: (current_employee_flag = 'Y' or CURRENT_NPW_FLAG = 'Y')
787: AND ((PA_CROSS_BUSINESS_GRP.IsCrossBGProfile = 'Y') OR
788: ((PA_CROSS_BUSINESS_GRP.IsCrossBGProfile = 'N') AND
789: fnd_profile.value('PER_BUSINESS_GROUP_ID') =
790: BUSINESS_GROUP_ID))
791: AND person_id = l_person_id
792: and rownum = 1;

Line 2933: And ( (Pa_Cross_Business_Grp.IsCrossBGProfile = 'N' AND

2929: From
2930: Per_People_X
2931: Where
2932: Person_Id = P_Person_Id
2933: And ( (Pa_Cross_Business_Grp.IsCrossBGProfile = 'N' AND
2934: Fnd_Profile.Value('PER_BUSINESS_GROUP_ID') = Business_Group_Id)
2935: OR Pa_Cross_Business_Grp.IsCrossBGProfile = 'Y');
2936:
2937: Cursor c_Job (P_Job_Id In Number) Is

Line 2935: OR Pa_Cross_Business_Grp.IsCrossBGProfile = 'Y');

2931: Where
2932: Person_Id = P_Person_Id
2933: And ( (Pa_Cross_Business_Grp.IsCrossBGProfile = 'N' AND
2934: Fnd_Profile.Value('PER_BUSINESS_GROUP_ID') = Business_Group_Id)
2935: OR Pa_Cross_Business_Grp.IsCrossBGProfile = 'Y');
2936:
2937: Cursor c_Job (P_Job_Id In Number) Is
2938: Select
2939: Name

Line 2944: And ( (Pa_Cross_Business_Grp.IsCrossBGProfile = 'N' AND

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 )
2946: OR Pa_Cross_Business_Grp.IsCrossBGProfile = 'Y');
2947:
2948: Cursor c_PersonType (P_Person_Type IN Varchar2) Is

Line 2946: OR Pa_Cross_Business_Grp.IsCrossBGProfile = 'Y');

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
2950: Meaning

Line 4231: And ( (Pa_Cross_Business_Grp.IsCrossBGProfile = 'N' AND

4227: From
4228: Per_People_X
4229: Where
4230: Person_Id = P_Person_Id
4231: And ( (Pa_Cross_Business_Grp.IsCrossBGProfile = 'N' AND
4232: Fnd_Profile.Value('PER_BUSINESS_GROUP_ID') = Business_Group_Id)
4233: OR Pa_Cross_Business_Grp.IsCrossBGProfile = 'Y');
4234:
4235: Cursor c_Job (P_Job_Id In Number) Is

Line 4233: OR Pa_Cross_Business_Grp.IsCrossBGProfile = 'Y');

4229: Where
4230: Person_Id = P_Person_Id
4231: And ( (Pa_Cross_Business_Grp.IsCrossBGProfile = 'N' AND
4232: Fnd_Profile.Value('PER_BUSINESS_GROUP_ID') = Business_Group_Id)
4233: OR Pa_Cross_Business_Grp.IsCrossBGProfile = 'Y');
4234:
4235: Cursor c_Job (P_Job_Id In Number) Is
4236: Select
4237: Name

Line 4242: And ( (Pa_Cross_Business_Grp.IsCrossBGProfile = 'N' AND

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 )
4244: OR Pa_Cross_Business_Grp.IsCrossBGProfile = 'Y');
4245:
4246: Cursor c_PersonType (P_Person_Type IN Varchar2) Is

Line 4244: OR Pa_Cross_Business_Grp.IsCrossBGProfile = 'Y');

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 )
4244: OR Pa_Cross_Business_Grp.IsCrossBGProfile = 'Y');
4245:
4246: Cursor c_PersonType (P_Person_Type IN Varchar2) Is
4247: Select
4248: Meaning