DBA Data[Home] [Help]

APPS.PA_OTC_API dependencies on PER_JOBS_V

Line 6544: from per_jobs_v w

6540:
6541: Cursor GetJobInfo(P_Job_Id IN Pa_Expenditure_items_All.Job_Id%TYPE) IS
6542: select
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)