DBA Data[Home] [Help]

APPS.PA_UTILS dependencies on PER_JOBS_V

Line 1036: from per_jobs_v V

1032: BEGIN
1033: If X_job_Id is not null then
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

Line 1048: from per_jobs_v V

1044: and ((date_to is null) or (date_to >= X_date));
1045: else
1046: select job_id
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)