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 1197: from pay_us_school_action_info_v school

1193: jurisdiction_name,
1194: sum(school_gross),
1195: sum(school_reduced_subject),
1196: sum(School_Withheld)
1197: from pay_us_school_action_info_v school
1198: where school.action_number = cp_action_number
1199: and school.jurisdiction_code like
1200: cp_state_id||'-'||nvl(cp_school_id,'%')
1201: /* and cp_action_number not in (select school2.action_number

Line 1202: from pay_us_school_action_info_v school2

1198: where school.action_number = cp_action_number
1199: and school.jurisdiction_code like
1200: cp_state_id||'-'||nvl(cp_school_id,'%')
1201: /* and cp_action_number not in (select school2.action_number
1202: from pay_us_school_action_info_v school2
1203: where (school2.school_gross = 0
1204: or school2. school_gross is null)
1205: and (school2.school_reduced_subject = 0
1206: or school2.school_reduced_subject is null)