DBA Data[Home] [Help]

APPS.PA_OTC_API dependencies on PA_CROSS_BUSINESS_GRP

Line 6547: and ((PA_CROSS_BUSINESS_GRP.IsCrossBGProfile = 'N' AND

6543: name
6544: from per_jobs_v w
6545: where w.job_Id = P_job_Id
6546: and p_Exp_Item_Date between date_from and nvl(date_to, p_exp_item_date)
6547: and ((PA_CROSS_BUSINESS_GRP.IsCrossBGProfile = 'N' AND
6548: fnd_profile.value('PER_BUSINESS_GROUP_ID') = W.BUSINESS_GROUP_ID)
6549: OR
6550: PA_CROSS_BUSINESS_GRP.IsCrossBGProfile = 'Y');
6551:

Line 6550: PA_CROSS_BUSINESS_GRP.IsCrossBGProfile = 'Y');

6546: and p_Exp_Item_Date between date_from and nvl(date_to, p_exp_item_date)
6547: and ((PA_CROSS_BUSINESS_GRP.IsCrossBGProfile = 'N' AND
6548: fnd_profile.value('PER_BUSINESS_GROUP_ID') = W.BUSINESS_GROUP_ID)
6549: OR
6550: PA_CROSS_BUSINESS_GRP.IsCrossBGProfile = 'Y');
6551:
6552: /* end bug 4766396 */
6553:
6554: l_job_name per_jobs_tl.name%TYPE := Null;