DBA Data[Home] [Help]

APPS.PAY_CN_BAL_UPLOAD dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 471: , hr_all_organization_units_tl otl

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
475: AND pbbl.tax_unit_id IS NOT NULL

Line 483: , hr_all_organization_units_tl otl

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)
487: AND pbbl.tax_unit_id IS NULL