APPS.PAY_CA_BAL_UPLOAD dependencies on PAY_CA_PROVINCES_V

Line 349: ,pay_ca_provinces_v prov

345: p_batch_line_id number
346: ) is
347: select prov.province_abbrev
348: from pay_balance_batch_lines pbbl
349: ,pay_ca_provinces_v prov
350: where pbbl.batch_line_id = p_batch_line_id
351: and pbbl.jurisdiction_code = prov.province_abbrev
352: and pbbl.jurisdiction_code is not null;
353: --