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.

APPS.GHR_CORR_CANC_SF52 dependencies on GHR_NATURE_OF_ACTIONS

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

503: FROM ghr_pa_history
504: WHERE pa_request_id = p_sf52_data.altered_pa_request_id
505: AND information5 = 'GHR_US_PER_SEPARATE_RETIRE'
506: AND table_name = ghr_history_api.g_peopei_table
507: AND nature_of_action_id = (select nature_of_action_id from ghr_nature_of_actions where
508: code = '352');
509:
510:
511:

Line 1719: l_prior_noa_code ghr_nature_of_actions.code%type;

1715: l_pa_history_id number;
1716: l_result boolean;
1717: l_deleted boolean;
1718: l_system_type per_person_types.system_person_type%type;
1719: l_prior_noa_code ghr_nature_of_actions.code%type;
1720: l_noa_family_code ghr_families.noa_family_code%type;
1721: l_prior_asg_id per_assignments_f.assignment_id%type; --Bug# 5442674
1722:
1723: -- bug #6312144

Line 3487: l_retro_first_noa ghr_nature_of_actions.code%type;

3483: l_session_var1 ghr_history_api.g_session_var_type;
3484: l_capped_other_pay number := hr_api.g_number;
3485: l_retro_eff_date ghr_pa_requests.effective_date%type;
3486: l_retro_pa_request_id ghr_pa_requests.pa_request_id%type;
3487: l_retro_first_noa ghr_nature_of_actions.code%type;
3488: l_retro_second_noa ghr_nature_of_actions.code%type;
3489: l_sf52_data_result ghr_pa_requests%rowtype;
3490: -- Bug#3543213 Created l_dummy variable
3491: l_dummy VARCHAR2(30);

Line 3488: l_retro_second_noa ghr_nature_of_actions.code%type;

3484: l_capped_other_pay number := hr_api.g_number;
3485: l_retro_eff_date ghr_pa_requests.effective_date%type;
3486: l_retro_pa_request_id ghr_pa_requests.pa_request_id%type;
3487: l_retro_first_noa ghr_nature_of_actions.code%type;
3488: l_retro_second_noa ghr_nature_of_actions.code%type;
3489: l_sf52_data_result ghr_pa_requests%rowtype;
3490: -- Bug#3543213 Created l_dummy variable
3491: l_dummy VARCHAR2(30);
3492: -- this cursor selects all rows in the correction chain from ghr_pa_requests

Line 5394: l_retro_first_noa ghr_nature_of_actions.code%type;

5390: and grd.grade_definition_id = gdf.grade_definition_id;
5391:
5392: l_retro_eff_date date;
5393: l_retro_pa_request_id ghr_pa_requests.pa_request_id%type;
5394: l_retro_first_noa ghr_nature_of_actions.code%type;
5395: l_retro_second_noa ghr_nature_of_actions.code%type;
5396: l_sf52_ia_rec ghr_pa_requests%rowtype;
5397:
5398:

Line 5395: l_retro_second_noa ghr_nature_of_actions.code%type;

5391:
5392: l_retro_eff_date date;
5393: l_retro_pa_request_id ghr_pa_requests.pa_request_id%type;
5394: l_retro_first_noa ghr_nature_of_actions.code%type;
5395: l_retro_second_noa ghr_nature_of_actions.code%type;
5396: l_sf52_ia_rec ghr_pa_requests%rowtype;
5397:
5398:
5399: begin

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

7008: AND p_effective_date BETWEEN elt.effective_start_date AND elt.effective_end_date
7009: AND p_effective_date BETWEEN ele.effective_start_date AND ele.effective_end_date;
7010:
7011:
7012: cursor c_noa_fam_code(p_noa_id ghr_nature_of_actions.nature_of_action_id%type) is
7013: select fam.noa_family_code
7014: from ghr_noa_families fam
7015: where fam.nature_of_action_id = p_noa_id;
7016:

Line 7021: l_noa_id ghr_nature_of_actions.nature_of_action_id%type;

7017:
7018: l_proc varchar2(30):='get_sf52_to_othpays_for_ia';
7019: l_dummy_varchar varchar2(1);
7020: l_sf52_ia_rec ghr_pa_requests%rowtype;
7021: l_noa_id ghr_nature_of_actions.nature_of_action_id%type;
7022: l_noa_fam_code ghr_noa_families.noa_family_code%type;
7023:
7024: BEGIN
7025: -- First assign the current From pos items to To pos items

Line 7255: l_retro_first_noa ghr_nature_of_actions.code%type;

7251: l_session_var1 ghr_history_api.g_session_var_type;
7252: l_capped_other_pay number := hr_api.g_number;
7253: l_retro_eff_date ghr_pa_requests.effective_date%type;
7254: l_retro_pa_request_id ghr_pa_requests.pa_request_id%type;
7255: l_retro_first_noa ghr_nature_of_actions.code%type;
7256: l_retro_second_noa ghr_nature_of_actions.code%type;
7257: l_sf52_data_result ghr_pa_requests%rowtype;
7258: -- Bug#3543213 Created l_dummy variable
7259: l_dummy VARCHAR2(30);

Line 7256: l_retro_second_noa ghr_nature_of_actions.code%type;

7252: l_capped_other_pay number := hr_api.g_number;
7253: l_retro_eff_date ghr_pa_requests.effective_date%type;
7254: l_retro_pa_request_id ghr_pa_requests.pa_request_id%type;
7255: l_retro_first_noa ghr_nature_of_actions.code%type;
7256: l_retro_second_noa ghr_nature_of_actions.code%type;
7257: l_sf52_data_result ghr_pa_requests%rowtype;
7258: -- Bug#3543213 Created l_dummy variable
7259: l_dummy VARCHAR2(30);
7260: -- this cursor selects all rows in the correction chain from ghr_pa_requests