APPS.PAY_JP_LTAX_EFILE_PKG dependencies on PER_JP_ADDRESS_LOOKUPS

Line 342: from per_jp_address_lookups adr,

338: select adr.district_name_kana,
339: psn.swot_number
340: into l_district_name_kana,
341: l_swot_number
342: from per_jp_address_lookups adr,
343: pay_jp_swot_numbers psn
344: where adr.district_code = substrb(l_rec.ltax_district_code, 1, 5)
345: and psn.organization_id(+) = g_parameter.organization_id
346: and psn.district_code(+) = adr.district_code || substrb(l_rec.ltax_district_code,6);