APPS.PAY_JP_SPR_EFILE_PKG dependencies on PAY_JP_ITAX_DEP_V

Line 1227: pay_jp_itax_dep_v pjid,

1223: pay_jp_itax_tax_v pjit,
1224: pay_jp_itax_other_v pjio,
1225: pay_jp_itax_other2_v2 pjio2,
1226: pay_jp_itax_housing_v pjih,
1227: pay_jp_itax_dep_v pjid,
1228: (select pjsn_act.organization_id,
1229: pjsn_act.district_code act_district_code,
1230: substrb(nvl(pjsn_act.report_district_code,pjsn_act.district_code),1,5) rep_district_code,
1231: pjsn_rep.swot_number rep_swot_number,

Line 1406: pay_jp_itax_dep_v pjid,

1402: pay_jp_itax_tax_v2 tax1,
1403: pay_jp_itax_other_v pjio,
1404: pay_jp_itax_other2_v2 pjio2,
1405: pay_jp_itax_housing_v pjih,
1406: pay_jp_itax_dep_v pjid,
1407: (select pjsn_act.organization_id,
1408: pjsn_act.district_code act_district_code,
1409: substrb(nvl(pjsn_act.report_district_code,pjsn_act.district_code),1,5) rep_district_code,
1410: pjsn_rep.swot_number rep_swot_number,

Line 1668: from pay_jp_itax_dep_v pjid

1664: where pjih.action_context_id = pjips.action_context_id
1665: and pjih.effective_date = pjips.effective_date)
1666: and exists(
1667: select null
1668: from pay_jp_itax_dep_v pjid
1669: where pjid.action_context_id = pjips.action_context_id
1670: and pjid.effective_date = pjips.effective_date))
1671: or (to_number(to_char(pjip.effective_date,'YYYY')) >= 2012
1672: and exists(

Line 1679: from pay_jp_itax_dep_v pjid

1675: where pjih.action_context_id = pjips.action_context_id
1676: and pjih.effective_date = pjips.effective_date)
1677: and exists(
1678: select null
1679: from pay_jp_itax_dep_v pjid
1680: where pjid.action_context_id = pjips.action_context_id
1681: and pjid.effective_date = pjips.effective_date))
1682: ))));
1683: --