DBA Data[Home] [Help]

APPS.PAY_JP_SPR_EFILE_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 125: hr_organization_information proc_hoi

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
127: and substrb(proc_pjsn_v.act_district_code(+),1,5) = proc_wic_v.town_or_city
128: and nvl(proc_pjsn_v.rep_district_code,nvl(proc_wic_v.town_or_city,'X'))
129: = nvl(pay_jp_spr_efile_pkg.g_district_code,nvl(proc_pjsn_v.rep_district_code,nvl(proc_wic_v.town_or_city,'X')))