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.PAY_US_MWR_REPORTING_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 571: per_all_assignments_f paa,

567:
568: CURSOR emp_qtr_sui_state_count IS
569: SELECT COUNT(DISTINCT peft.sui_state_code)
570: FROM pay_us_emp_fed_tax_rules_f peft,
571: per_all_assignments_f paa,
572: hr_soft_coding_keyflex hscf
573: WHERE peft.effective_end_date >= trunc(p_effective_date,'Q')
574: AND peft.effective_start_date <= p_effective_date
575: AND peft.assignment_id = p_assignment_id

Line 622: FROM per_all_assignments_f paaf,

618: l_location_id NUMBER;
619:
620: CURSOR asg_with_action_loc_id IS
621: SELECT paaf.location_id
622: FROM per_all_assignments_f paaf,
623: hr_locations_all hl,
624: pay_us_states pus
625: WHERE paaf.effective_start_date <= p_effective_date
626: AND paaf.effective_end_date >= trunc(p_effective_date,'Q')

Line 647: FROM per_all_assignments_f paaf,

643: ORDER BY paaf.effective_end_date desc;
644:
645: CURSOR assignment_loc_id IS
646: SELECT paaf.location_id
647: FROM per_all_assignments_f paaf,
648: hr_locations_all hl,
649: pay_us_states pus
650: WHERE paaf.effective_start_date <= p_effective_date
651: AND paaf.effective_end_date >= trunc(p_effective_date,'Q')

Line 881: FROM per_all_assignments_f paf

877:
878: BEGIN
879: SELECT NVL(paf.work_at_home,'N')
880: INTO l_work_at_home
881: FROM per_all_assignments_f paf
882: WHERE paf.assignment_id = l_ass_id
883: AND l_effective_date between paf.effective_start_date and paf.effective_end_date;
884: EXCEPTION
885: WHEN OTHERS THEN