eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_PAY_RATE_SS dependencies on PER_JOBS

Line 505: FROM per_jobs jobs , per_assignments_f asg

501: l_proc varchar2(200) := g_package || 'get_flsa_status';
502:
503: CURSOR lc_flsa_status IS
504: SELECT job_information3
505: FROM per_jobs jobs , per_assignments_f asg
506: WHERE jobs.job_id = asg.job_id
507: -- AND jobs.business_group_id = asg.business_group_id
508: -- Fix 2094081
509: AND p_date between asg.effective_start_date and asg.effective_end_date

Line 516: FROM per_jobs jobs

512: AND asg.business_group_id = p_bus_group_id ;
513:
514: CURSOR lc_txn_flsa_status IS
515: SELECT job_information3
516: FROM per_jobs jobs
517: WHERE jobs.job_id = p_job_id
518: AND jobs.business_group_id = p_bus_group_id ;
519:
520: lv_flsa_status VARCHAR2(150);