[Home] [Help]
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: --
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
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