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_JP_SPR_EFILE_PKG dependencies on HR_API

Line 112: between proc_padr.date_from (+) and nvl(proc_padr.date_to(+), hr_api.g_eot)

108: between proc_pp.effective_start_date and proc_pp.effective_end_date
109: and proc_padr.person_id (+) = proc_pjwa.person_id
110: and proc_padr.address_type (+) = 'JP_R'
111: and nvl(proc_pjwa.actual_termination_date, add_months(trunc(proc_pjwa.effective_date, 'YYYY'), 12))
112: between proc_padr.date_from (+) and nvl(proc_padr.date_to(+), hr_api.g_eot)
113: and proc_padc.person_id (+) = proc_pjwa.person_id
114: and proc_padc.address_type (+) = 'JP_C'
115: and nvl(proc_pjwa.actual_termination_date, add_months(trunc(proc_pjwa.effective_date, 'YYYY'), 12))
116: between proc_padc.date_from (+) and nvl(proc_padc.date_to(+), hr_api.g_eot)) proc_wic_v,

Line 116: between proc_padc.date_from (+) and nvl(proc_padc.date_to(+), hr_api.g_eot)) proc_wic_v,

112: between proc_padr.date_from (+) and nvl(proc_padr.date_to(+), hr_api.g_eot)
113: and proc_padc.person_id (+) = proc_pjwa.person_id
114: and proc_padc.address_type (+) = 'JP_C'
115: and nvl(proc_pjwa.actual_termination_date, add_months(trunc(proc_pjwa.effective_date, 'YYYY'), 12))
116: between proc_padc.date_from (+) and nvl(proc_padc.date_to(+), hr_api.g_eot)) proc_wic_v,
117: (select proc_pjsn_act.organization_id,
118: proc_pjsn_act.district_code act_district_code,
119: substrb(nvl(proc_pjsn_act.report_district_code,proc_pjsn_act.district_code),1,5) rep_district_code,
120: proc_pjsn_rep.efile_exclusive_flag rep_efile_exclusive_flag