APPS.PAY_JP_SPR_EFILE_PKG dependencies on PAY_JP_ITAX_HOUSING_V

Line 1051: pay_jp_itax_housing_v pjih,

1047: pay_jp_itax_arch_v2 pjia,
1048: pay_jp_itax_tax_v pjit,
1049: pay_jp_itax_other_v pjio,
1050: pay_jp_itax_other2_v2 pjio2,
1051: pay_jp_itax_housing_v pjih,
1052: (select pjsn_act.organization_id,
1053: pjsn_act.district_code act_district_code,
1054: substrb(nvl(pjsn_act.report_district_code,pjsn_act.district_code),1,5) rep_district_code,
1055: pjsn_rep.swot_number rep_swot_number,

Line 1226: pay_jp_itax_housing_v pjih,

1222: pay_jp_itax_arch_v2 pjia,
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,

Line 1405: pay_jp_itax_housing_v pjih,

1401: pay_jp_itax_tax_v pjit,
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,

Line 1657: from pay_jp_itax_housing_v pjih

1653: or (to_number(to_char(pjip.effective_date,'YYYY')) >= 2009
1654: and to_number(to_char(pjip.effective_date,'YYYY')) < 2011
1655: and exists(
1656: select null
1657: from pay_jp_itax_housing_v pjih
1658: where pjih.action_context_id = pjips.action_context_id
1659: and pjih.effective_date = pjips.effective_date))
1660: or (to_number(to_char(pjip.effective_date,'YYYY')) >= 2011 and to_number(to_char(pjip.effective_date,'YYYY')) < 2012
1661: and exists(

Line 1663: from pay_jp_itax_housing_v pjih

1659: and pjih.effective_date = pjips.effective_date))
1660: or (to_number(to_char(pjip.effective_date,'YYYY')) >= 2011 and to_number(to_char(pjip.effective_date,'YYYY')) < 2012
1661: and exists(
1662: select null
1663: from pay_jp_itax_housing_v pjih
1664: where pjih.action_context_id = pjips.action_context_id
1665: and pjih.effective_date = pjips.effective_date)
1666: and exists(
1667: select null

Line 1674: from pay_jp_itax_housing_v pjih

1670: and pjid.effective_date = pjips.effective_date))
1671: or (to_number(to_char(pjip.effective_date,'YYYY')) >= 2012
1672: and exists(
1673: select null
1674: from pay_jp_itax_housing_v pjih
1675: where pjih.action_context_id = pjips.action_context_id
1676: and pjih.effective_date = pjips.effective_date)
1677: and exists(
1678: select null