APPS.PAY_FI_ARCHIVE_PSTA dependencies on PER_JOBS

Line 1237: p_job_id per_jobs.job_id%type,

1233: from ff_globals_f
1234: where legislation_code = 'FI' and global_name = p_global_name;
1235:
1236: cursor csr_get_job (
1237: p_job_id per_jobs.job_id%type,
1238: p_effective_date date
1239: ) is
1240: select name
1241: from per_jobs

Line 1241: from per_jobs

1237: p_job_id per_jobs.job_id%type,
1238: p_effective_date date
1239: ) is
1240: select name
1241: from per_jobs
1242: where job_id = p_job_id and p_effective_date between date_from and nvl (date_to, p_effective_date);
1243:
1244: cursor csr_get_position (
1245: p_position_id hr_positions_f.position_id%type,

Line 1289: l_job_name per_jobs.name%type;

1285: l_car_benefit number := 0;
1286: l_pension number := 0;
1287: l_unemployment_insurance number := 0;
1288: l_trade_union_fee number := 0;
1289: l_job_name per_jobs.name%type;
1290: begin
1291: if g_archive = 'Y' then
1292: open csr_asg_effective_date (
1293: p_asg_id => p_assignment_id,