DBA Data[Home] [Help]

APPS.PAY_SG_BAL_UPLOAD dependencies on PAY_BALANCE_BATCH_LINES

Line 456: from pay_balance_batch_lines pbbl

452: (
453: p_batch_line_id number
454: ) is
455: select htuv.tax_unit_id
456: from pay_balance_batch_lines pbbl
457: ,hr_tax_units_v htuv
458: where pbbl.batch_line_id = p_batch_line_id
459: and pbbl.tax_unit_id = htuv.tax_unit_id
460: and pbbl.tax_unit_id is not null

Line 463: from pay_balance_batch_lines pbbl

459: and pbbl.tax_unit_id = htuv.tax_unit_id
460: and pbbl.tax_unit_id is not null
461: union all
462: select htuv.tax_unit_id
463: from pay_balance_batch_lines pbbl
464: ,hr_tax_units_v htuv
465: where pbbl.batch_line_id = p_batch_line_id
466: and upper(pbbl.gre_name) = upper(htuv.name)
467: and pbbl.tax_unit_id is null;