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_ARCHIVER_REPORT_PKG dependencies on PAY_US_SCHOOL_ACTION_INFO_V

Line 1402: from pay_us_school_action_info_v school

1398: jurisdiction_name,
1399: sum(school_gross),
1400: sum(school_reduced_subject),
1401: sum(School_Withheld)
1402: from pay_us_school_action_info_v school
1403: where school.action_number = cp_action_number
1404: and school.jurisdiction_code like
1405: cp_state_id||'-'||nvl(cp_school_id,'%')
1406: /* and cp_action_number not in (select school2.action_number

Line 1407: from pay_us_school_action_info_v school2

1403: where school.action_number = cp_action_number
1404: and school.jurisdiction_code like
1405: cp_state_id||'-'||nvl(cp_school_id,'%')
1406: /* and cp_action_number not in (select school2.action_number
1407: from pay_us_school_action_info_v school2
1408: where (school2.school_gross = 0
1409: or school2. school_gross is null)
1410: and (school2.school_reduced_subject = 0
1411: or school2.school_reduced_subject is null)