DBA Data[Home] [Help]

APPS.PAY_JP_DEF_SS dependencies on PAY_JP_SWOT_NUMBERS

Line 1780: from pay_jp_swot_numbers pjsn_rep,

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,
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

Line 1781: pay_jp_swot_numbers pjsn_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,
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