APPS.PA_PLANNING_RESOURCE_UTILS dependencies on PA_CROSS_BUSINESS_GRP

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

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

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

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

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

2970: From
2971: Per_People_X
2972: Where
2973: Person_Id = P_Person_Id
2974: And ( (Pa_Cross_Business_Grp.IsCrossBGProfile = 'N' AND
2975: Fnd_Profile.Value('PER_BUSINESS_GROUP_ID') = Business_Group_Id)
2976: OR Pa_Cross_Business_Grp.IsCrossBGProfile = 'Y');
2977:
2978: Cursor c_Job (P_Job_Id In Number) Is

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

2972: Where
2973: Person_Id = P_Person_Id
2974: And ( (Pa_Cross_Business_Grp.IsCrossBGProfile = 'N' AND
2975: Fnd_Profile.Value('PER_BUSINESS_GROUP_ID') = Business_Group_Id)
2976: OR Pa_Cross_Business_Grp.IsCrossBGProfile = 'Y');
2977:
2978: Cursor c_Job (P_Job_Id In Number) Is
2979: Select
2980: Name

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

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

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

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

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

4268: From
4269: Per_People_X
4270: Where
4271: Person_Id = P_Person_Id
4272: And ( (Pa_Cross_Business_Grp.IsCrossBGProfile = 'N' AND
4273: Fnd_Profile.Value('PER_BUSINESS_GROUP_ID') = Business_Group_Id)
4274: OR Pa_Cross_Business_Grp.IsCrossBGProfile = 'Y');
4275:
4276: Cursor c_Job (P_Job_Id In Number) Is

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

4270: Where
4271: Person_Id = P_Person_Id
4272: And ( (Pa_Cross_Business_Grp.IsCrossBGProfile = 'N' AND
4273: Fnd_Profile.Value('PER_BUSINESS_GROUP_ID') = Business_Group_Id)
4274: OR Pa_Cross_Business_Grp.IsCrossBGProfile = 'Y');
4275:
4276: Cursor c_Job (P_Job_Id In Number) Is
4277: Select
4278: Name

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

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

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

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 )
4285: OR Pa_Cross_Business_Grp.IsCrossBGProfile = 'Y');
4286:
4287: Cursor c_PersonType (P_Person_Type IN Varchar2) Is
4288: Select
4289: Meaning