eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_CN_EXT dependencies on HR_LOOKUPS

Line 461: FROM ben_ext_dfn ed, hr_lookups hrl, per_business_groups bg

457: CURSOR csr_extract_def_id
458: IS
459: --
460: SELECT ed.ext_dfn_id
461: FROM ben_ext_dfn ed, hr_lookups hrl, per_business_groups bg
462: WHERE ((bg.business_group_id = ed.business_group_id)
463: OR (bg.legislation_code = ed.legislation_code)
464: OR (ed.business_group_id IS NULL AND ed.legislation_code IS NULL))
465: AND bg.business_group_id = p_business_group_id

Line 702: FROM ben_ext_dfn ed, hr_lookups hrl, per_business_groups bg

698: CURSOR csr_extract_def_id
699: IS
700: --
701: SELECT ed.ext_dfn_id
702: FROM ben_ext_dfn ed, hr_lookups hrl, per_business_groups bg
703: WHERE ((bg.business_group_id = ed.business_group_id)
704: OR (bg.legislation_code = ed.legislation_code)
705: OR (ed.business_group_id is null and ed.legislation_code is null))
706: AND bg.business_group_id = p_business_group_id

Line 854: FROM ben_ext_dfn ed, hr_lookups hrl, per_business_groups bg

850: CURSOR csr_extract_def_id
851: IS
852: --
853: SELECT ed.ext_dfn_id
854: FROM ben_ext_dfn ed, hr_lookups hrl, per_business_groups bg
855: WHERE ((bg.business_group_id = ed.business_group_id)
856: OR (bg.legislation_code = ed.legislation_code)
857: OR (ed.business_group_id is null and ed.legislation_code is null))
858: AND bg.business_group_id = p_business_group_id