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.GHR_BEN_VALIDATION dependencies on GHR_NATURE_OF_ACTIONS

Line 811: CURSOR c_noa_family_code(c_noa_id ghr_nature_of_actions.nature_of_action_id%type,

807: l_noa_id number;
808: l_noa_family_code ghr_noa_families.noa_family_code%type;
809:
810: -- Bug 4760226
811: CURSOR c_noa_family_code(c_noa_id ghr_nature_of_actions.nature_of_action_id%type,
812: c_effective_date ghr_nature_of_actions.date_from%type) IS
813: SELECT noa_family_code
814: FROM ghr_noa_families
815: WHERE nature_of_action_id = c_noa_id

Line 812: c_effective_date ghr_nature_of_actions.date_from%type) IS

808: l_noa_family_code ghr_noa_families.noa_family_code%type;
809:
810: -- Bug 4760226
811: CURSOR c_noa_family_code(c_noa_id ghr_nature_of_actions.nature_of_action_id%type,
812: c_effective_date ghr_nature_of_actions.date_from%type) IS
813: SELECT noa_family_code
814: FROM ghr_noa_families
815: WHERE nature_of_action_id = c_noa_id
816: AND c_effective_date BETWEEN NVL(start_date_active,to_date('01/01/1951','dd/mm/yyyy'))