APPS.GHR_CORR_CANC_SF52 dependencies on GHR_NATURE_OF_ACTIONS

Line 489: AND nature_of_action_id = (select nature_of_action_id from ghr_nature_of_actions where

485: FROM ghr_pa_history
486: WHERE pa_request_id = p_sf52_data.altered_pa_request_id
487: AND information5 = 'GHR_US_PER_SEPARATE_RETIRE'
488: AND table_name = ghr_history_api.g_peopei_table
489: AND nature_of_action_id = (select nature_of_action_id from ghr_nature_of_actions where
490: code = '352');
491: ghr_history_api.fetch_history_info(
492: p_table_name => ghr_history_api.g_peopei_table,
493: p_hist_data => l_hist_pre,

Line 1550: l_prior_noa_code ghr_nature_of_actions.code%type;

1546: l_pa_history_id number;
1547: l_result boolean;
1548: l_deleted boolean;
1549: l_system_type per_person_types.system_person_type%type;
1550: l_prior_noa_code ghr_nature_of_actions.code%type;
1551: l_noa_family_code ghr_families.noa_family_code%type;
1552: l_prior_asg_id per_assignments_f.assignment_id%type; --Bug# 5442674
1553:
1554: -- bug #6312144

Line 3181: l_retro_first_noa ghr_nature_of_actions.code%type;

3177: l_session_var1 ghr_history_api.g_session_var_type;
3178: l_capped_other_pay number := hr_api.g_number;
3179: l_retro_eff_date ghr_pa_requests.effective_date%type;
3180: l_retro_pa_request_id ghr_pa_requests.pa_request_id%type;
3181: l_retro_first_noa ghr_nature_of_actions.code%type;
3182: l_retro_second_noa ghr_nature_of_actions.code%type;
3183: l_sf52_data_result ghr_pa_requests%rowtype;
3184: -- Bug#3543213 Created l_dummy variable
3185: l_dummy VARCHAR2(30);

Line 3182: l_retro_second_noa ghr_nature_of_actions.code%type;

3178: l_capped_other_pay number := hr_api.g_number;
3179: l_retro_eff_date ghr_pa_requests.effective_date%type;
3180: l_retro_pa_request_id ghr_pa_requests.pa_request_id%type;
3181: l_retro_first_noa ghr_nature_of_actions.code%type;
3182: l_retro_second_noa ghr_nature_of_actions.code%type;
3183: l_sf52_data_result ghr_pa_requests%rowtype;
3184: -- Bug#3543213 Created l_dummy variable
3185: l_dummy VARCHAR2(30);
3186: -- this cursor selects all rows in the correction chain from ghr_pa_requests

Line 5052: l_retro_first_noa ghr_nature_of_actions.code%type;

5048: and grd.grade_definition_id = gdf.grade_definition_id;
5049:
5050: l_retro_eff_date date;
5051: l_retro_pa_request_id ghr_pa_requests.pa_request_id%type;
5052: l_retro_first_noa ghr_nature_of_actions.code%type;
5053: l_retro_second_noa ghr_nature_of_actions.code%type;
5054: l_sf52_ia_rec ghr_pa_requests%rowtype;
5055:
5056:

Line 5053: l_retro_second_noa ghr_nature_of_actions.code%type;

5049:
5050: l_retro_eff_date date;
5051: l_retro_pa_request_id ghr_pa_requests.pa_request_id%type;
5052: l_retro_first_noa ghr_nature_of_actions.code%type;
5053: l_retro_second_noa ghr_nature_of_actions.code%type;
5054: l_sf52_ia_rec ghr_pa_requests%rowtype;
5055:
5056:
5057: begin

Line 6657: cursor c_noa_fam_code(p_noa_id ghr_nature_of_actions.nature_of_action_id%type) is

6653: AND p_effective_date BETWEEN elt.effective_start_date AND elt.effective_end_date
6654: AND p_effective_date BETWEEN ele.effective_start_date AND ele.effective_end_date;
6655:
6656:
6657: cursor c_noa_fam_code(p_noa_id ghr_nature_of_actions.nature_of_action_id%type) is
6658: select fam.noa_family_code
6659: from ghr_noa_families fam
6660: where fam.nature_of_action_id = p_noa_id;
6661:

Line 6666: l_noa_id ghr_nature_of_actions.nature_of_action_id%type;

6662:
6663: l_proc varchar2(30):='get_sf52_to_othpays_for_ia';
6664: l_dummy_varchar varchar2(1);
6665: l_sf52_ia_rec ghr_pa_requests%rowtype;
6666: l_noa_id ghr_nature_of_actions.nature_of_action_id%type;
6667: l_noa_fam_code ghr_noa_families.noa_family_code%type;
6668:
6669: BEGIN
6670: -- First assign the current From pos items to To pos items