DBA Data[Home] [Help]

APPS.PER_DPF_BUS dependencies on PER_JOBS_V

Line 299: from per_jobs_v per

295: l_dummy varchar2(1);
296: --
297: cursor c1 is
298: select null
299: from per_jobs_v per
300: where per.job_id = p_job_id
301: and p_effective_date
302: between per.date_from
303: and nvl(per.date_to,hr_api.g_eot);

Line 1719: from per_jobs_v per

1715: l_dummy varchar2(1);
1716: --
1717: cursor c_jobs is
1718: select null
1719: from per_jobs_v per
1720: where per.business_group_id = p_business_group_id
1721: and per.job_id = p_job_id;
1722: --
1723: --