eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_PLANNING_RESOURCE_UTILS dependencies on FND_PROFILE

Line 789: fnd_profile.value('PER_BUSINESS_GROUP_ID') =

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;
793: EXCEPTION

Line 2934: Fnd_Profile.Value('PER_BUSINESS_GROUP_ID') = Business_Group_Id)

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
2938: Select

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 4232: Fnd_Profile.Value('PER_BUSINESS_GROUP_ID') = Business_Group_Id)

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
4236: Select

Line 4243: Fnd_Profile.Value('PER_BUSINESS_GROUP_ID') = Business_Group_Id )

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
4247: Select