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_YEPP_ADD_ACTIONS_PKG dependencies on HR_ASSIGNMENT_SET_AMENDMENTS

Line 536: from hr_assignment_set_amendments has,

532: is
533: select /*+ ORDERED */max(paa.assignment_action_id),
534: paf1.assignment_id,
535: paf.person_id
536: from hr_assignment_set_amendments has,
537: per_assignments_f paf,
538: per_assignments_f paf1,
539: pay_assignment_actions paa,
540: pay_payroll_actions ppa,

Line 608: hr_assignment_set_amendments has

604: is
605: select paa.assignment_id,
606: paa.assignment_action_id
607: from pay_assignment_actions paa,
608: hr_assignment_set_amendments has
609: where paa.payroll_action_id = cp_payroll_action_id
610: and paa.action_status = 'M'
611: and paa.tax_unit_id = cp_gre_id
612: and has.assignment_set_id = cp_assignment_set_id

Line 832: from hr_assignment_set_amendments has,

828: cp_gre_id number,
829: cp_assignment_set_id number)
830: is
831: select distinct has.assignment_id
832: from hr_assignment_set_amendments has,
833: per_assignments_f paf
834: where has.assignment_set_id = cp_assignment_set_id
835: and paf.assignment_id = has.assignment_id
836: and paf.primary_flag = 'Y'

Line 855: from hr_assignment_set_amendments has,

851: cp_gre_id number,
852: cp_assignment_set_id number)
853: is
854: select distinct has.assignment_id
855: from hr_assignment_set_amendments has,
856: per_assignments_f paf
857: where has.assignment_set_id = cp_assignment_set_id
858: and paf.assignment_id = has.assignment_id
859: and exists( SELECT 1

Line 920: from hr_assignment_set_amendments has,

916: cp_gre_id number,
917: cp_effective_date date)
918: is
919: select distinct has.assignment_id
920: from hr_assignment_set_amendments has,
921: per_assignments_f paf,
922: pay_us_asg_reporting puar
923: where has.assignment_set_id = cp_assignment_set_id
924: and paf.assignment_id = has.assignment_id

Line 1035: from hr_assignment_set_amendments has,

1031: cp_gre_id number,
1032: cp_effective_date date)
1033: is
1034: select distinct has.assignment_id
1035: from hr_assignment_set_amendments has,
1036: per_assignments_f paf,
1037: pay_us_asg_reporting puar
1038: where assignment_set_id = cp_assignment_set_id
1039: and paf.assignment_id = has.assignment_id

Line 1134: from hr_assignment_set_amendments has,

1130: cp_gre_id number,
1131: cp_effective_date date)
1132: is
1133: select distinct has.assignment_id, puar.tax_unit_id
1134: from hr_assignment_set_amendments has,
1135: per_assignments_f paf,
1136: pay_us_asg_reporting puar
1137: where assignment_set_id = cp_assignment_set_id
1138: and paf.assignment_id = has.assignment_id