DBA Data[Home] [Help]

APPS.PAY_CN_BAL_UPLOAD dependencies on PAY_BALANCE_BATCH_LINES

Line 470: FROM pay_balance_batch_lines pbbl

466: -- Get the tax_unit_id from the original balance batch line
467: CURSOR csr_get_tax_unit(p_batch_line_id NUMBER)
468: IS
469: SELECT pbbl.tax_unit_id
470: FROM pay_balance_batch_lines pbbl
471: , hr_all_organization_units_tl otl
472: , hr_organization_information hoi
473: WHERE pbbl.batch_line_id = p_batch_line_id
474: AND pbbl.tax_unit_id = otl.organization_id

Line 482: FROM pay_balance_batch_lines pbbl

478: AND hoi.org_information2 = 'Y'
479: AND otl.language = userenv('LANG')
480: UNION ALL
481: SELECT pbbl.tax_unit_id
482: FROM pay_balance_batch_lines pbbl
483: , hr_all_organization_units_tl otl
484: , hr_organization_information hoi
485: WHERE pbbl.batch_line_id = p_batch_line_id
486: AND upper(pbbl.gre_name) = UPPER(otl.name)