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

Line 383: per_all_assignments_f paf,

379: paf.person_id,
380: ppa_arch.payroll_action_id
381: FROM pay_assignment_actions paa_arch,
382: pay_payroll_actions ppa_arch,
383: per_all_assignments_f paf,
384: pay_action_information pai
385: WHERE paa_arch.payroll_action_id = ppa_arch.payroll_action_id
386: AND paa_arch.assignment_id = paf.assignment_id
387: -- Bug 4518777

Line 442: per_all_assignments_f paf,

438: paf.person_id,
439: ppa_arch.payroll_action_id
440: FROM pay_assignment_actions paa_arch,
441: pay_payroll_actions ppa_arch,
442: per_all_assignments_f paf,
443: pay_population_ranges ppr,
444: pay_action_information pai
445: WHERE paa_arch.payroll_action_id = ppa_arch.payroll_action_id
446: AND paa_arch.assignment_id = paf.assignment_id

Line 676: per_all_assignments_f paf,

672: pai.action_information_id,
673: nvl(pai.action_information21, 'N') -- Do not report flag
674: FROM pay_action_information pai,
675: pay_assignment_actions paa_arch,
676: per_all_assignments_f paf,
677: pay_action_interlocks lck
678: WHERE pai.action_context_id = paa_arch.assignment_action_id
679: AND paf.assignment_id = paa_arch.assignment_id
680: AND pai.effective_date BETWEEN paf.effective_start_date AND

Line 702: per_all_assignments_f paf,

698: fnd_number.canonical_to_number(pai.action_information8), --IDW
699: pai.action_information2 -- transaction date
700: FROM pay_action_information pai,
701: pay_assignment_actions paa_arch,
702: per_all_assignments_f paf,
703: pay_action_interlocks lck
704: WHERE pai.action_context_id = paa_arch.assignment_action_id
705: AND paf.assignment_id = paa_arch.assignment_id
706: --Bug 7185703

Line 927: WHERE table_name IN ('PER_ALL_PEOPLE_F','PER_ALL_ASSIGNMENTS_F','PAY_ELEMENT_ENTRIES_F','PAY_ELEMENT_ENTRY_VALUES_F')

923: FROM pay_process_events ppe
924: WHERE EXISTS
925: (SELECT 1
926: FROM pay_event_updates peu
927: WHERE table_name IN ('PER_ALL_PEOPLE_F','PER_ALL_ASSIGNMENTS_F','PAY_ELEMENT_ENTRIES_F','PAY_ELEMENT_ENTRY_VALUES_F')
928: AND ppe.event_update_id = peu.event_update_id
929: );
930:
931: IF fnd_date.canonical_to_date(ld_event_strt_date) >= fnd_date.canonical_to_date(NVL(ld_imp_date,ld_event_strt_date)) THEN