APPS.PA_UTILS dependencies on PA_CROSS_BUSINESS_GRP

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

1034: select job_id
1035: into l_job_id
1036: from per_jobs_v V
1037: where job_id = X_job_id
1038: and ((PA_CROSS_BUSINESS_GRP.IsCrossBGProfile = 'N' AND
1039: fnd_profile.value('PER_BUSINESS_GROUP_ID') = V.BUSINESS_GROUP_ID)
1040: OR
1041: PA_CROSS_BUSINESS_GRP.IsCrossBGProfile = 'Y'
1042: )

Line 1041: PA_CROSS_BUSINESS_GRP.IsCrossBGProfile = 'Y'

1037: where job_id = X_job_id
1038: and ((PA_CROSS_BUSINESS_GRP.IsCrossBGProfile = 'N' AND
1039: fnd_profile.value('PER_BUSINESS_GROUP_ID') = V.BUSINESS_GROUP_ID)
1040: OR
1041: PA_CROSS_BUSINESS_GRP.IsCrossBGProfile = 'Y'
1042: )
1043: and date_from <= X_date
1044: and ((date_to is null) or (date_to >= X_date));
1045: else

Line 1051: /* and ((PA_CROSS_BUSINESS_GRP.IsCrossBGProfile = 'N' AND

1047: into l_job_id
1048: from per_jobs_v V
1049: where name = X_job_name
1050: AND V.BUSINESS_GROUP_ID = NVL(X_Business_Group_Id,V.BUSINESS_GROUP_ID)
1051: /* and ((PA_CROSS_BUSINESS_GRP.IsCrossBGProfile = 'N' AND
1052: fnd_profile.value('PER_BUSINESS_GROUP_ID') = V.BUSINESS_GROUP_ID)
1053: OR
1054: PA_CROSS_BUSINESS_GRP.IsCrossBGProfile = 'Y'
1055: )*/

Line 1054: PA_CROSS_BUSINESS_GRP.IsCrossBGProfile = 'Y'

1050: AND V.BUSINESS_GROUP_ID = NVL(X_Business_Group_Id,V.BUSINESS_GROUP_ID)
1051: /* and ((PA_CROSS_BUSINESS_GRP.IsCrossBGProfile = 'N' AND
1052: fnd_profile.value('PER_BUSINESS_GROUP_ID') = V.BUSINESS_GROUP_ID)
1053: OR
1054: PA_CROSS_BUSINESS_GRP.IsCrossBGProfile = 'Y'
1055: )*/
1056: and date_from <= X_date
1057: and ((date_to is null) or (date_to >= X_date));
1058: end if;