DBA Data[Home] [Help]

APPS.PA_RBS_ELEMENTS_PVT dependencies on PA_CROSS_BUSINESS_GRP

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

1588: From
1589: Per_People_X
1590: Where
1591: Person_Id = P_Id
1592: And ( (Pa_Cross_Business_Grp.IsCrossBGProfile = 'N' AND
1593: Fnd_Profile.Value('PER_BUSINESS_GROUP_ID') = Per_People_X.Business_Group_Id)
1594: OR Pa_Cross_Business_Grp.IsCrossBGProfile = 'Y');
1595:
1596: Cursor c_Job (P_Id In Number) Is

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

1590: Where
1591: Person_Id = P_Id
1592: And ( (Pa_Cross_Business_Grp.IsCrossBGProfile = 'N' AND
1593: Fnd_Profile.Value('PER_BUSINESS_GROUP_ID') = Per_People_X.Business_Group_Id)
1594: OR Pa_Cross_Business_Grp.IsCrossBGProfile = 'Y');
1595:
1596: Cursor c_Job (P_Id In Number) Is
1597: Select
1598: 'Y'

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

1599: From
1600: Per_Jobs
1601: Where
1602: Job_Id = P_Id
1603: And ( (Pa_Cross_Business_Grp.IsCrossBGProfile = 'N' AND
1604: Fnd_Profile.Value('PER_BUSINESS_GROUP_ID') = Per_Jobs.Business_Group_Id )
1605: OR Pa_Cross_Business_Grp.IsCrossBGProfile = 'Y');
1606:
1607: Cursor c_BOM (P_BOM_Res_Id IN Number) Is

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

1601: Where
1602: Job_Id = P_Id
1603: And ( (Pa_Cross_Business_Grp.IsCrossBGProfile = 'N' AND
1604: Fnd_Profile.Value('PER_BUSINESS_GROUP_ID') = Per_Jobs.Business_Group_Id )
1605: OR Pa_Cross_Business_Grp.IsCrossBGProfile = 'Y');
1606:
1607: Cursor c_BOM (P_BOM_Res_Id IN Number) Is
1608: Select
1609: 'Y'