DBA Data[Home] [Help]

APPS.PAY_JP_LTAX_IMP_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 749: hr_all_organization_units hou,

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'
753: and hoi.org_information1 = 'JP_TAX_SWOT'

Line 788: hr_all_organization_units hou,

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,
792: per_periods_of_service ppos,

Line 1490: hr_all_organization_units hou,

1486: select null
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)