DBA Data[Home] [Help]

APPS.PER_MM_POSITIONS_PKG dependencies on PER_JOBS

Line 156: per_jobs job

152: 'N',
153: 'N'
154: from hr_positions pos,
155: per_organization_units org,
156: per_jobs job
157: where pos.job_id = job.job_id
158: and pos.organization_id = org.organization_id
159: and p_session_date between
160: pos.date_effective and

Line 532: per_jobs job

528: job.name,
529: job.job_id,
530: job.job_definition_id
531: from hr_positions pos,
532: per_jobs job
533: where p_new_position_definition_id = pos.position_definition_id
534: and pos.job_id = job.job_id;
535:
536: l_organization_id number(15);

Line 578: from per_jobs job

574:
575: cursor csr_job is
576: select job.name,
577: job.job_definition_id
578: from per_jobs job
579: where p_new_job_id = job.job_id
580: and p_effective_date between job.date_from
581: and nvl(job.date_to, p_effective_date);
582: