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_LTAX_IMP_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 748: from hr_organization_information hoi,

744: select nvl(pjsn_act.report_district_code,pjsn_act.district_code) rep_district_code,
745: pjsn_act.organization_id,
746: pjsn_rep.swot_number,
747: pjsn_rep.input_file_name
748: from hr_organization_information hoi,
749: hr_all_organization_units hou,
750: pay_jp_swot_numbers pjsn_act,
751: pay_jp_swot_numbers pjsn_rep
752: where hoi.org_information_context = 'CLASS'

Line 787: from hr_organization_information hoi,

783: pjsn_act.organization_id,
784: pjsn_rep.swot_number,
785: pjsn_rep.input_file_name,
786: ptp.regular_payment_date
787: from hr_organization_information hoi,
788: hr_all_organization_units hou,
789: pay_jp_swot_numbers pjsn_act,
790: pay_jp_swot_numbers pjsn_rep,
791: per_addresses pad,

Line 1491: hr_organization_information hoi

1487: from per_addresses pad,
1488: pay_jp_swot_numbers pjsn_act,
1489: pay_jp_swot_numbers pjsn_rep,
1490: hr_all_organization_units hou,
1491: hr_organization_information hoi
1492: where pad.person_id = pp.person_id
1493: and pad.address_type in ('JP_C','JP_R')
1494: and nvl(ppos.actual_termination_date,g_effective_soy)
1495: between pad.date_from and nvl(pad.date_to,hr_api.g_eot)