DBA Data[Home] [Help]

APPS.PQH_WKS_BUDGET dependencies on PER_JOBS

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

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