DBA Data[Home] [Help]

APPS.GHR_ELEMENT_API dependencies on GHR_NATURE_OF_ACTIONS

Line 818: l_noa_id ghr_nature_of_actions.nature_of_action_id%type;

814: l_input_value_found boolean := FALSE;
815: l_update_mode varchar2(20);
816: l_session ghr_history_api.g_session_var_type;
817: l_session_incentive ghr_history_api.g_session_var_type;
818: l_noa_id ghr_nature_of_actions.nature_of_action_id%type;
819: l_noa_code ghr_nature_of_actions.code%type;
820: l_noa_fam_code ghr_noa_families.noa_family_code%type;
821:
822: --

Line 819: l_noa_code ghr_nature_of_actions.code%type;

815: l_update_mode varchar2(20);
816: l_session ghr_history_api.g_session_var_type;
817: l_session_incentive ghr_history_api.g_session_var_type;
818: l_noa_id ghr_nature_of_actions.nature_of_action_id%type;
819: l_noa_code ghr_nature_of_actions.code%type;
820: l_noa_fam_code ghr_noa_families.noa_family_code%type;
821:
822: --
823: cursor c_business_group (asg_id number, eff_date date) is

Line 845: from ghr_nature_of_actions noa

841:
842:
843: cursor c_noa_code is
844: select noa.code
845: from ghr_nature_of_actions noa
846: where noa.nature_of_action_id = l_noa_id;
847:
848: --
849: -- to pick pay basis from PAR