DBA Data[Home] [Help]

APPS.PAY_US_RULES dependencies on PER_JOBS

Line 2291: FROM per_jobs perj,

2287: /* Check if employee is flsa eligible */
2288: CURSOR get_jobs_us_flsa_code(cp_date_earned DATE
2289: ,cp_assignment_id NUMBER) IS
2290: SELECT nvl(perj.JOB_INFORMATION3, 'EX')
2291: FROM per_jobs perj,
2292: per_jobs_tl perjtl,
2293: per_all_assignments_f paa
2294: WHERE cp_date_earned BETWEEN paa.effective_start_date AND paa.effective_end_date
2295: AND paa.assignment_id = cp_assignment_id

Line 2292: per_jobs_tl perjtl,

2288: CURSOR get_jobs_us_flsa_code(cp_date_earned DATE
2289: ,cp_assignment_id NUMBER) IS
2290: SELECT nvl(perj.JOB_INFORMATION3, 'EX')
2291: FROM per_jobs perj,
2292: per_jobs_tl perjtl,
2293: per_all_assignments_f paa
2294: WHERE cp_date_earned BETWEEN paa.effective_start_date AND paa.effective_end_date
2295: AND paa.assignment_id = cp_assignment_id
2296: AND paa.job_id = perj.job_id