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

Line 871: FROM per_all_assignments_f paf,

867: ) THEN
868: IF p_report_type = 'FEDW2' THEN
869: p_sqlstr := '
870: SELECT DISTINCT paf.person_id
871: FROM per_all_assignments_f paf,
872: pay_assignment_actions paa,
873: pay_payroll_actions ppa,
874: pay_payroll_actions ppa1
875: WHERE ppa1.payroll_action_id = :payroll_action_id

Line 905: per_all_assignments_f paf,

901: ff_archive_items fai,
902: ff_database_items fdi,
903: pay_assignment_actions paa,
904: pay_payroll_actions ppa,
905: per_all_assignments_f paf,
906: pay_payroll_actions ppa1
907: WHERE
908: ppa1.payroll_action_id = :payroll_action_id
909: AND ppa.business_group_id+0 = ppa1.business_group_id

Line 993: per_all_assignments_f paf,

989:
990: FROM
991: pay_assignment_actions paa, /* YREND PAA */
992: pay_payroll_actions ppa, /* YREND PPA */
993: per_all_assignments_f paf,
994: pay_payroll_actions ppa1,
995: ff_contexts fc1 , --for city context
996: ff_archive_items fai1, -- city
997: ff_archive_item_contexts faic1, -- city_context

Line 1053: per_all_assignments_f paf,

1049: paf.effective_end_date,
1050: paa.assignment_action_id
1051: FROM pay_payroll_actions ppa,
1052: pay_assignment_actions paa,
1053: per_all_assignments_f paf,
1054: pay_payroll_actions ppa1
1055: WHERE ppa1.payroll_action_id = p_pactid
1056: AND ppa.report_type = 'YREND'
1057: AND ppa.business_group_id+0 = ppa1.business_group_id