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 PAY_JP_SWOT_NUMBERS

Line 121: from pay_jp_swot_numbers proc_pjsn_rep,

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
121: from pay_jp_swot_numbers proc_pjsn_rep,
122: pay_jp_swot_numbers proc_pjsn_act
123: where proc_pjsn_rep.organization_id = proc_pjsn_act.organization_id
124: and proc_pjsn_rep.district_code = nvl(proc_pjsn_act.report_district_code,proc_pjsn_act.district_code)) proc_pjsn_v,
125: hr_organization_information proc_hoi

Line 122: pay_jp_swot_numbers proc_pjsn_act

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
121: from pay_jp_swot_numbers proc_pjsn_rep,
122: pay_jp_swot_numbers proc_pjsn_act
123: where proc_pjsn_rep.organization_id = proc_pjsn_act.organization_id
124: and proc_pjsn_rep.district_code = nvl(proc_pjsn_act.report_district_code,proc_pjsn_act.district_code)) proc_pjsn_v,
125: hr_organization_information proc_hoi
126: where proc_pjsn_v.organization_id (+) = proc_wic_v.itax_organization_id

Line 150: from pay_jp_swot_numbers arch_pjsn_rep,

146: (select arch_pjsn_act.organization_id,
147: arch_pjsn_act.district_code act_district_code,
148: substrb(nvl(arch_pjsn_act.report_district_code,arch_pjsn_act.district_code),1,5) rep_district_code,
149: arch_pjsn_rep.efile_exclusive_flag rep_efile_exclusive_flag
150: from pay_jp_swot_numbers arch_pjsn_rep,
151: pay_jp_swot_numbers arch_pjsn_act
152: where arch_pjsn_rep.organization_id = arch_pjsn_act.organization_id
153: and arch_pjsn_rep.district_code = nvl(arch_pjsn_act.report_district_code,arch_pjsn_act.district_code)) arch_pjsn_v
154: where nvl(pay_jp_spr_efile_pkg.g_arch_pact_exist,'N') = 'Y'

Line 151: pay_jp_swot_numbers arch_pjsn_act

147: arch_pjsn_act.district_code act_district_code,
148: substrb(nvl(arch_pjsn_act.report_district_code,arch_pjsn_act.district_code),1,5) rep_district_code,
149: arch_pjsn_rep.efile_exclusive_flag rep_efile_exclusive_flag
150: from pay_jp_swot_numbers arch_pjsn_rep,
151: pay_jp_swot_numbers arch_pjsn_act
152: where arch_pjsn_rep.organization_id = arch_pjsn_act.organization_id
153: and arch_pjsn_rep.district_code = nvl(arch_pjsn_act.report_district_code,arch_pjsn_act.district_code)) arch_pjsn_v
154: where nvl(pay_jp_spr_efile_pkg.g_arch_pact_exist,'N') = 'Y'
155: and arch_ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')