DBA Data[Home] [Help]

APPS.PAY_US_RULES dependencies on PER_JOBS

Line 2231: FROM per_jobs perj,

2227: /* Check if employee is flsa eligible */
2228: CURSOR get_jobs_us_flsa_code(cp_date_earned DATE
2229: ,cp_assignment_id NUMBER) IS
2230: SELECT nvl(perj.JOB_INFORMATION3, 'EX')
2231: FROM per_jobs perj,
2232: per_jobs_tl perjtl,
2233: per_all_assignments_f paa
2234: WHERE cp_date_earned BETWEEN paa.effective_start_date AND paa.effective_end_date
2235: AND paa.assignment_id = cp_assignment_id

Line 2232: per_jobs_tl perjtl,

2228: CURSOR get_jobs_us_flsa_code(cp_date_earned DATE
2229: ,cp_assignment_id NUMBER) IS
2230: SELECT nvl(perj.JOB_INFORMATION3, 'EX')
2231: FROM per_jobs perj,
2232: per_jobs_tl perjtl,
2233: per_all_assignments_f paa
2234: WHERE cp_date_earned BETWEEN paa.effective_start_date AND paa.effective_end_date
2235: AND paa.assignment_id = cp_assignment_id
2236: AND paa.job_id = perj.job_id