APPS.GHR_MASS_SEL_NOA dependencies on GHR_NATURE_OF_ACTIONS

Line 942: l_temp_noa_code ghr_nature_of_actions.code%type;

938: l_old_type_of_employment varchar2(30);
939: l_new_type_of_employment varchar2(30);
940: l_old_pay_userra_status varchar2(30);
941: l_new_pay_userra_status varchar2(30);
942: l_temp_noa_code ghr_nature_of_actions.code%type;
943: l_furlough_indicator varchar2(30);
944: l_old_lwop_nte_start_date date;
945: l_new_lwop_nte_start_date date;
946: l_old_lwop_nte date;

Line 1985: FROM ghr_nature_of_actions

1981: FROM ghr_noa_families
1982: WHERE nature_of_action_id IN
1983: (
1984: SELECT nature_of_action_id
1985: FROM ghr_nature_of_actions
1986: WHERE code = ghr_msl_pkg.g_first_noa_code
1987: )
1988: )
1989: AND proc_method_flag = 'Y';