DBA Data[Home] [Help]

APPS.PQH_WKS_BUDGET dependencies on PER_JOBS

Line 932: cursor c1 is select job_id from per_jobs job, per_job_groups jgr

928: cursor c0 is select budget_start_date,budget_end_date
929: from pqh_budgets bgt, pqh_budget_versions bgv
930: where bgv.budget_id = bgt.budget_id
931: and bgv.budget_version_id = p_budget_version_id;
932: cursor c1 is select job_id from per_jobs job, per_job_groups jgr
933: where job.job_group_id = jgr.job_group_id and jgr.internal_name = 'HR_' || job.business_group_id
934: and job.business_group_id = p_business_group_id
935: and date_from < l_budget_end_date
936: and (date_to > l_budget_start_date or date_to is null)