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_W2C_REPORTING_UTILS dependencies on PER_ALL_ASSIGNMENTS_F

Line 247: per_all_assignments_f paf,

243: cpd_end_date date)
244: IS
245: select paa.assignment_action_id
246: from pay_assignment_actions paa,
247: per_all_assignments_f paf,
248: pay_payroll_actions ppa
249: where ppa.business_group_id = cpn_business_group_id
250: and ppa.effective_date between cpd_start_date and cpd_end_date
251: and ppa.action_type = 'X'

Line 430: per_all_assignments_f paf,

426: hr_utility.set_location(gv_package || '.w2c_mag_range_cursor', 40);
427: lv_sql_string :=
428: 'select distinct paf.person_id
429: from pay_assignment_actions paa,
430: per_all_assignments_f paf,
431: pay_payroll_actions ppa
432: where ppa.business_group_id = '|| ln_business_group_id || '
433: and ppa.effective_date between to_date(''' ||
434: to_char(ld_start_date, 'dd-mon-yyyy') || ''',''dd-mon-yyyy'')

Line 506: per_all_assignments_f paf,

502: IS
503: select distinct paa.assignment_id,
504: paf.person_id
505: from pay_assignment_actions paa,
506: per_all_assignments_f paf,
507: pay_payroll_actions ppa
508: where ppa.business_group_id = cp_business_group_id
509: and ppa.effective_date between cp_start_date and cp_end_date
510: and ppa.action_type = 'X'

Line 584: per_all_assignments_f paf,

580: paa.assignment_Action_id, -- Maximum Assignment Action_ID
581: to_number(substr(paa.serial_number,1,15)) w2c_pp_asg_actid,
582: to_number(substr(paa.serial_number,16,30)) w2c_pp_locked_actid
583: from pay_assignment_actions paa,
584: per_all_assignments_f paf,
585: pay_payroll_actions ppa
586: where ppa.business_group_id = cp_business_group_id
587: and ppa.effective_date between cp_start_date and cp_end_date
588: and ppa.action_type = 'X'

Line 652: per_all_assignments_f paf,

648: cpn_max_asgn_action_id number)
649: IS
650: select paa.assignment_action_id
651: from pay_assignment_actions paa,
652: per_all_assignments_f paf,
653: pay_payroll_actions ppa
654: where ppa.business_group_id = cpn_business_group_id
655: and ppa.effective_date between cpd_start_date and cpd_end_date
656: and ppa.action_type = 'X'

Line 724: per_all_assignments_f paf,

720: paa.assignment_Action_id,
721: ppa.payroll_action_id,
722: to_number(substr(paa.serial_number,1,15)) w2c_pp_asg_actid
723: from pay_assignment_actions paa,
724: per_all_assignments_f paf,
725: pay_payroll_actions ppa
726: where ppa.business_group_id = cp_business_group_id
727: and ppa.effective_date between cp_start_date and cp_end_date
728: and ppa.action_type = 'X'