APPS.PAY_EBRA_DIAGNOSTICS dependencies on HR_LOOKUPS

Line 651: FROM hr_lookups hl1,hr_lookups hl2

647: **************************************************************/
648: CURSOR c_valid_invalid
649: IS
650: SELECT hl1.meaning,hl2.meaning
651: FROM hr_lookups hl1,hr_lookups hl2
652: WHERE hl2.lookup_type = 'RUN_BALANCE_STATUS'
653: AND hl2.lookup_code = 'V'
654: AND hl1.lookup_type = 'RUN_BALANCE_STATUS'
655: AND hl1.lookup_code = 'I';

Line 681: , per_business_groups pbg, hr_lookups hl

677: ,nvl(hl.meaning, hl2.meaning) Status
678: FROM
679: pay_defined_balances pdb, pay_balance_types pbt
680: , pay_balance_dimensions pbd
681: , per_business_groups pbg, hr_lookups hl
682: , pay_balance_validation pbv
683: , hr_lookups hl2
684: WHERE pdb.balance_type_id = pbt.balance_type_id
685: AND pdb.balance_dimension_id = pbd.balance_dimension_id

Line 683: , hr_lookups hl2

679: pay_defined_balances pdb, pay_balance_types pbt
680: , pay_balance_dimensions pbd
681: , per_business_groups pbg, hr_lookups hl
682: , pay_balance_validation pbv
683: , hr_lookups hl2
684: WHERE pdb.balance_type_id = pbt.balance_type_id
685: AND pdb.balance_dimension_id = pbd.balance_dimension_id
686: AND pdb.save_run_balance = 'Y'
687: AND ((pdb.legislation_code = pbg.legislation_code)