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.

[Home] [Help]

APPS.GHR_BEN_VALIDATION dependencies on GHR_NATURE_OF_ACTIONS

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

1234: l_noa_id number;
1235: l_noa_family_code ghr_noa_families.noa_family_code%type;
1236:
1237: -- Bug 4760226
1238: CURSOR c_noa_family_code(c_noa_id ghr_nature_of_actions.nature_of_action_id%type,
1239: c_effective_date ghr_nature_of_actions.date_from%type) IS
1240: SELECT noa_family_code
1241: FROM ghr_noa_families
1242: WHERE nature_of_action_id = c_noa_id

Line 1239: c_effective_date ghr_nature_of_actions.date_from%type) IS

1235: l_noa_family_code ghr_noa_families.noa_family_code%type;
1236:
1237: -- Bug 4760226
1238: CURSOR c_noa_family_code(c_noa_id ghr_nature_of_actions.nature_of_action_id%type,
1239: c_effective_date ghr_nature_of_actions.date_from%type) IS
1240: SELECT noa_family_code
1241: FROM ghr_noa_families
1242: WHERE nature_of_action_id = c_noa_id
1243: AND c_effective_date BETWEEN NVL(start_date_active,to_date('01/01/1951','dd/mm/yyyy'))