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_REPORTING1 dependencies on HR_US_W2_REP

Line 875: AND nvl(hr_us_w2_rep.get_w2_arch_bal(

871: AND fai.value = ppa1.report_qualifier
872: AND paf.effective_start_date <= ppa.effective_date
873: AND paf.effective_end_date >= ppa.start_date
874: AND paa.action_status = ''C''
875: AND nvl(hr_us_w2_rep.get_w2_arch_bal(
876: paa.assignment_action_id,
877: ''A_W2_STATE_WAGES'',
878: paa.tax_unit_id,
879: faic.context , 2),0) > 0

Line 936: nvl(hr_us_w2_rep.get_w2_arch_bal(paa.assignment_action_id,

932: paf.assignment_id,
933: paa.tax_unit_id,
934: paf.effective_end_date,
935: paa.assignment_action_id,
936: nvl(hr_us_w2_rep.get_w2_arch_bal(paa.assignment_action_id,
937: 'A_W2_STATE_WAGES',
938: paa.tax_unit_id,
939: faic.context , 2),0)
940: FROM ff_archive_item_contexts faic,

Line 964: and nvL(hr_us_w2_rep.get_w2_arch_bal(paa.assignment_action_id,

960: and paf.effective_start_date <= ppa.effective_date
961: and paf.effective_end_date >= ppa.start_date
962: and paa.action_status = 'C'
963: and paf.person_id BETWEEN p_stperson AND p_endperson
964: and nvL(hr_us_w2_rep.get_w2_arch_bal(paa.assignment_action_id,
965: 'A_W2_STATE_WAGES',
966: paa.tax_unit_id,
967: faic.context , 2),0) > 0
968: and exists ( /*+ INDEX(pustif PAY_US_STATE_TAX_INFO_F_N1) */

Line 1000: nvl(hr_us_w2_rep.get_w2_arch_bal(paa.assignment_action_id,

996: paf.assignment_id,
997: paa.tax_unit_id,
998: paf.effective_end_date,
999: paa.assignment_action_id,
1000: nvl(hr_us_w2_rep.get_w2_arch_bal(paa.assignment_action_id,
1001: 'A_W2_STATE_WAGES',
1002: paa.tax_unit_id,
1003: faic.context , 2),0)
1004: FROM ff_archive_item_contexts faic,

Line 1028: and nvL(hr_us_w2_rep.get_w2_arch_bal(paa.assignment_action_id,

1024: and paf.effective_start_date <= ppa.effective_date
1025: and paf.effective_end_date >= ppa.start_date
1026: and paa.action_status = 'C'
1027: and paf.person_id BETWEEN p_stperson AND p_endperson
1028: and nvL(hr_us_w2_rep.get_w2_arch_bal(paa.assignment_action_id,
1029: 'A_W2_STATE_WAGES',
1030: paa.tax_unit_id,
1031: faic.context , 2),0) > 0
1032: and exists ( /*+ INDEX(pustif PAY_US_STATE_TAX_INFO_F_N1) */