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_NON_SF52_EXTRA_INFO dependencies on GHR_NATURE_OF_ACTIONS

Line 33: l_noa_code ghr_nature_of_actions.code%type;

29: l_pei_id per_people_extra_info.person_extra_info_id%type;
30: l_rei_rec ghr_pa_request_extra_info%rowtype ;
31: l_org_rec ghr_pa_request_ei_shadow%rowtype;
32: l_ret_grade1 ghr_pa_request_extra_info.rei_information4%type;
33: l_noa_code ghr_nature_of_actions.code%type;
34: l_first_noa_code ghr_nature_of_actions.code%type;
35: l_second_noa_code ghr_nature_of_actions.code%type;
36: l_existed BOOLEAN := FALSE;
37: l_altered_pa_request_id ghr_pa_requests.altered_pa_request_id%type;

Line 34: l_first_noa_code ghr_nature_of_actions.code%type;

30: l_rei_rec ghr_pa_request_extra_info%rowtype ;
31: l_org_rec ghr_pa_request_ei_shadow%rowtype;
32: l_ret_grade1 ghr_pa_request_extra_info.rei_information4%type;
33: l_noa_code ghr_nature_of_actions.code%type;
34: l_first_noa_code ghr_nature_of_actions.code%type;
35: l_second_noa_code ghr_nature_of_actions.code%type;
36: l_existed BOOLEAN := FALSE;
37: l_altered_pa_request_id ghr_pa_requests.altered_pa_request_id%type;
38: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;

Line 35: l_second_noa_code ghr_nature_of_actions.code%type;

31: l_org_rec ghr_pa_request_ei_shadow%rowtype;
32: l_ret_grade1 ghr_pa_request_extra_info.rei_information4%type;
33: l_noa_code ghr_nature_of_actions.code%type;
34: l_first_noa_code ghr_nature_of_actions.code%type;
35: l_second_noa_code ghr_nature_of_actions.code%type;
36: l_existed BOOLEAN := FALSE;
37: l_altered_pa_request_id ghr_pa_requests.altered_pa_request_id%type;
38: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
39:

Line 41: select code from ghr_nature_of_actions

37: l_altered_pa_request_id ghr_pa_requests.altered_pa_request_id%type;
38: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
39:
40: cursor c_noa_code(p_noa_id in ghr_pa_requests.first_noa_id%type) is
41: select code from ghr_nature_of_actions
42: where nature_of_action_id = p_noa_id;
43:
44: Cursor c_702 is
45: SELECT pei_information1 From_Date,

Line 504: select code from ghr_nature_of_actions

500: and pit.noa_family_code = fam.noa_family_code);
501: ---- and pit.information_type LIKE 'GHR_US%');
502:
503: cursor c_noa_code(p_noa_id in ghr_pa_requests.first_noa_id%type) is
504: select code from ghr_nature_of_actions
505: where nature_of_action_id = p_noa_id;
506:
507: cursor c_altered_par_rec is
508: select altered_pa_request_id from ghr_pa_requests

Line 511: l_noa_code ghr_nature_of_actions.code%type;

507: cursor c_altered_par_rec is
508: select altered_pa_request_id from ghr_pa_requests
509: where pa_request_id = p_pa_request_id;
510:
511: l_noa_code ghr_nature_of_actions.code%type;
512: l_first_noa_code ghr_nature_of_actions.code%type;
513: l_second_noa_code ghr_nature_of_actions.code%type;
514: l_altered_pa_request_id ghr_pa_requests.pa_request_id%type;
515:

Line 512: l_first_noa_code ghr_nature_of_actions.code%type;

508: select altered_pa_request_id from ghr_pa_requests
509: where pa_request_id = p_pa_request_id;
510:
511: l_noa_code ghr_nature_of_actions.code%type;
512: l_first_noa_code ghr_nature_of_actions.code%type;
513: l_second_noa_code ghr_nature_of_actions.code%type;
514: l_altered_pa_request_id ghr_pa_requests.pa_request_id%type;
515:
516: cursor c_orig_rei_rec is

Line 513: l_second_noa_code ghr_nature_of_actions.code%type;

509: where pa_request_id = p_pa_request_id;
510:
511: l_noa_code ghr_nature_of_actions.code%type;
512: l_first_noa_code ghr_nature_of_actions.code%type;
513: l_second_noa_code ghr_nature_of_actions.code%type;
514: l_altered_pa_request_id ghr_pa_requests.pa_request_id%type;
515:
516: cursor c_orig_rei_rec is
517: select *

Line 643: l_noa_id ghr_nature_of_actions.nature_of_action_id%type;

639: l_per_ei_data per_people_extra_info%rowtype;
640: l_asg_ei_data per_assignment_extra_info%rowtype;
641: l_pos_ei_data per_position_extra_info%rowtype;
642: l_multiple_error_flag boolean;
643: l_noa_id ghr_nature_of_actions.nature_of_action_id%type;
644: l_proc varchar2(72):= g_package || 'noa_spec_extra_info';
645: l_information_type ghr_pa_request_info_types.information_type%type;
646: l_update_rei varchar2(1) := 'N';
647: l_exists boolean := FALSE;

Line 797: FROM ghr_nature_of_actions noa,

793: where pa_request_id = p_pa_request_id;
794:
795: cursor c_noac_1xx is
796: SELECT par.effective_date
797: FROM ghr_nature_of_actions noa,
798: ghr_pa_requests par,
799: ghr_pay_plans pp
800: WHERE noa.nature_of_action_id = par.first_noa_id
801: and par.pa_request_id = p_pa_request_id

Line 809: FROM ghr_nature_of_actions noa,

805: AND noa.code <> '130';
806:
807: cursor c_noac_5xx is
808: SELECT par.effective_date
809: FROM ghr_nature_of_actions noa,
810: ghr_pa_requests par,
811: ghr_pay_plans pp
812: WHERE noa.nature_of_action_id = par.first_noa_id
813: and par.pa_request_id = p_pa_request_id

Line 821: FROM ghr_nature_of_actions noa,

817: AND noa.code not in ('542','543','546','548','549');
818:
819: cursor c_noac_130 is
820: SELECT par.effective_date
821: FROM ghr_nature_of_actions noa,
822: ghr_pa_requests par,
823: ghr_pay_plans pp
824: WHERE noa.nature_of_action_id = par.first_noa_id
825: and par.pa_request_id = p_pa_request_id

Line 833: FROM ghr_nature_of_actions noa,

829: AND par.first_action_la_code1 = 'KVM';
830:
831: cursor c_noac_sal_chg is
832: SELECT par.effective_date
833: FROM ghr_nature_of_actions noa,
834: ghr_pa_requests par,
835: ghr_pay_plans pp
836: WHERE noa.nature_of_action_id = par.first_noa_id
837: AND par.pa_request_id = p_pa_request_id

Line 2403: FROM ghr_nature_of_actions

2399: FROM per_positions
2400: WHERE position_id = p_position_id;
2401: cursor c_noa_code is
2402: SELECT 'X'
2403: FROM ghr_nature_of_actions
2404: WHERE nature_of_action_id = p_noa_id
2405: and code in ('825','840','841','842','843','844','845','846',
2406: '847','848','849','878','879' ); -- Bug 3266198 Added 848 and 849 to the NOA codes.
2407: l_agency_code ghr_pa_requests.agency_code%type;

Line 4008: (p_noa_id in ghr_nature_of_actions.nature_of_action_id%type,

4004:
4005:
4006: -- Get Information Type
4007: Procedure get_information_type
4008: (p_noa_id in ghr_nature_of_actions.nature_of_action_id%type,
4009: p_information_type out NOCOPY ghr_pa_request_info_types.information_type%type
4010: )
4011: is
4012: