APPS.PAY_PEL_BUS dependencies on PER_JOBS

Line 1011: from per_positions pos, per_jobs job, hr_organization_units org

1007: l_dummy varchar2(1);
1008:
1009: cursor csr_position is
1010: select 'X'
1011: from per_positions pos, per_jobs job, hr_organization_units org
1012: where pos.position_id = p_position_id
1013: and pos.business_group_id +0 = p_business_group_id
1014: and job.job_id = pos.job_id and org.organization_id = pos.organization_id
1015: and p_effective_date between pos.date_effective

Line 1072: from per_jobs_v job

1068:
1069: cursor csr_jobs
1070: is
1071: select 'X'
1072: from per_jobs_v job
1073: where job.business_group_id +0 = p_business_group_id
1074: and p_effective_date between job.date_from and nvl(job.date_to, g_eot)
1075: and job.job_id = p_job_id;
1076: --

Line 1086: fnd_message.set_token('TABLE','per_jobs');

1082: if csr_jobs%notfound then
1083: close csr_jobs;
1084: fnd_message.set_name('PAY', 'PAY_33452_FK_DATA_INACTIVE');
1085: fnd_message.set_token('COLUMN','Job Id');
1086: fnd_message.set_token('TABLE','per_jobs');
1087: fnd_message.set_token('PROCEDURE',l_proc);
1088: fnd_message.raise_error;
1089: end if;
1090: close csr_jobs;