DBA Data[Home] [Help]

APPS.PA_RBS_ELEMENTS_PVT dependencies on PA_CROSS_BUSINESS_GRP

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

1631: From
1632: Per_People_X
1633: Where
1634: Person_Id = P_Id
1635: And ( (Pa_Cross_Business_Grp.IsCrossBGProfile = 'N' AND
1636: Fnd_Profile.Value('PER_BUSINESS_GROUP_ID') = Per_People_X.Business_Group_Id)
1637: OR Pa_Cross_Business_Grp.IsCrossBGProfile = 'Y');
1638:
1639: Cursor c_Job (P_Id In Number) Is

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

1633: Where
1634: Person_Id = P_Id
1635: And ( (Pa_Cross_Business_Grp.IsCrossBGProfile = 'N' AND
1636: Fnd_Profile.Value('PER_BUSINESS_GROUP_ID') = Per_People_X.Business_Group_Id)
1637: OR Pa_Cross_Business_Grp.IsCrossBGProfile = 'Y');
1638:
1639: Cursor c_Job (P_Id In Number) Is
1640: Select
1641: 'Y'

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

1642: From
1643: Per_Jobs
1644: Where
1645: Job_Id = P_Id
1646: And ( (Pa_Cross_Business_Grp.IsCrossBGProfile = 'N' AND
1647: Fnd_Profile.Value('PER_BUSINESS_GROUP_ID') = Per_Jobs.Business_Group_Id )
1648: OR Pa_Cross_Business_Grp.IsCrossBGProfile = 'Y');
1649:
1650: Cursor c_BOM (P_BOM_Res_Id IN Number) Is

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

1644: Where
1645: Job_Id = P_Id
1646: And ( (Pa_Cross_Business_Grp.IsCrossBGProfile = 'N' AND
1647: Fnd_Profile.Value('PER_BUSINESS_GROUP_ID') = Per_Jobs.Business_Group_Id )
1648: OR Pa_Cross_Business_Grp.IsCrossBGProfile = 'Y');
1649:
1650: Cursor c_BOM (P_BOM_Res_Id IN Number) Is
1651: Select
1652: 'Y'