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_MAGTAPE_REPORTING dependencies on PER_ASSIGNMENTS_F

Line 621: FROM per_assignments_f ASG,

617: SELECT ASG.person_id person_id,
618: ASG.assignment_id assignment_id,
619: fnd_number.canonical_to_number(SCL.segment1) tax_unit_id,
620: max(ASG.effective_end_date) effective_end_date
621: FROM per_assignments_f ASG,
622: hr_soft_coding_keyflex SCL,
623: hr_tax_units_v TUV,
624: pay_payrolls_f PPY
625: WHERE ASG.business_group_id = l_bus_group_id

Line 646: FROM per_assignments_f ASG,

642: SELECT ASG.person_id person_id,
643: ASG.assignment_id assignment_id,
644: fnd_number.canonical_to_number(SCL.segment1) tax_unit_id,
645: max(ASG.effective_end_date) effective_end_date
646: FROM per_assignments_f ASG,
647: hr_soft_coding_keyflex SCL,
648: hr_tax_units_v TUV,
649: pay_payrolls_f PPY,
650: pay_state_rules SR,

Line 1104: from pay_assignment_actions aa, per_assignments_f a

1100: l_person_id number;
1101:
1102: cursor get_highly_comp is
1103: select a.person_id
1104: from pay_assignment_actions aa, per_assignments_f a
1105: where aa.payroll_action_id = p_payroll_action_id
1106: and aa.assignment_id = a.assignment_id
1107: and aa.serial_number is NOT NULL;
1108: