APPS.PAY_JP_DEF_SS dependencies on PER_JP_ADDRESS_LOOKUPS

Line 1776: from per_jp_address_lookups pjal_act,

1772: --
1773: cursor csr_emp_address(p_district_code in varchar2)
1774: is
1775: select decode(pjsn_v.rep_district_code,null,pjal_act.address_line_1,pjal_rep.address_line_1) district_name
1776: from per_jp_address_lookups pjal_act,
1777: (select pjsn_act.organization_id,
1778: pjsn_act.district_code act_district_code,
1779: substrb(nvl(pjsn_act.report_district_code,pjsn_act.district_code),1,5) rep_district_code
1780: from pay_jp_swot_numbers pjsn_rep,

Line 1784: per_jp_address_lookups pjal_rep

1780: from pay_jp_swot_numbers pjsn_rep,
1781: pay_jp_swot_numbers pjsn_act
1782: where pjsn_rep.organization_id = pjsn_act.organization_id
1783: and pjsn_rep.district_code = nvl(pjsn_act.report_district_code,pjsn_act.district_code)) pjsn_v,
1784: per_jp_address_lookups pjal_rep
1785: where substrb(pjal_act.district_code,1,5) = p_district_code
1786: and pjsn_v.organization_id (+) = nvl(l_itax_organization_id,-1)
1787: and substrb(pjsn_v.act_district_code(+),1,5) = substrb(pjal_act.district_code,1,5)
1788: and substrb(pjal_rep.district_code(+),1,5) = pjsn_v.rep_district_code;