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 41: l_noa_code ghr_nature_of_actions.code%type;

37: l_pei_id per_people_extra_info.person_extra_info_id%type;
38: l_rei_rec ghr_pa_request_extra_info%rowtype ;
39: l_org_rec ghr_pa_request_ei_shadow%rowtype;
40: l_ret_grade1 ghr_pa_request_extra_info.rei_information4%type;
41: l_noa_code ghr_nature_of_actions.code%type;
42: l_first_noa_code ghr_nature_of_actions.code%type;
43: l_second_noa_code ghr_nature_of_actions.code%type;
44: l_existed BOOLEAN := FALSE;
45: l_altered_pa_request_id ghr_pa_requests.altered_pa_request_id%type;

Line 42: l_first_noa_code ghr_nature_of_actions.code%type;

38: l_rei_rec ghr_pa_request_extra_info%rowtype ;
39: l_org_rec ghr_pa_request_ei_shadow%rowtype;
40: l_ret_grade1 ghr_pa_request_extra_info.rei_information4%type;
41: l_noa_code ghr_nature_of_actions.code%type;
42: l_first_noa_code ghr_nature_of_actions.code%type;
43: l_second_noa_code ghr_nature_of_actions.code%type;
44: l_existed BOOLEAN := FALSE;
45: l_altered_pa_request_id ghr_pa_requests.altered_pa_request_id%type;
46: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;

Line 43: l_second_noa_code ghr_nature_of_actions.code%type;

39: l_org_rec ghr_pa_request_ei_shadow%rowtype;
40: l_ret_grade1 ghr_pa_request_extra_info.rei_information4%type;
41: l_noa_code ghr_nature_of_actions.code%type;
42: l_first_noa_code ghr_nature_of_actions.code%type;
43: l_second_noa_code ghr_nature_of_actions.code%type;
44: l_existed BOOLEAN := FALSE;
45: l_altered_pa_request_id ghr_pa_requests.altered_pa_request_id%type;
46: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
47:

Line 49: select code from ghr_nature_of_actions

45: l_altered_pa_request_id ghr_pa_requests.altered_pa_request_id%type;
46: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
47:
48: cursor c_noa_code(p_noa_id in ghr_pa_requests.first_noa_id%type) is
49: select code from ghr_nature_of_actions
50: where nature_of_action_id = p_noa_id;
51:
52: Cursor c_702 is
53: SELECT pei_information1 From_Date,

Line 551: select code from ghr_nature_of_actions

547: and pit.noa_family_code = fam.noa_family_code);
548: ---- and pit.information_type LIKE 'GHR_US%');
549:
550: cursor c_noa_code(p_noa_id in ghr_pa_requests.first_noa_id%type) is
551: select code from ghr_nature_of_actions
552: where nature_of_action_id = p_noa_id;
553:
554: cursor c_altered_par_rec is
555: select altered_pa_request_id from ghr_pa_requests

Line 558: l_noa_code ghr_nature_of_actions.code%type;

554: cursor c_altered_par_rec is
555: select altered_pa_request_id from ghr_pa_requests
556: where pa_request_id = p_pa_request_id;
557:
558: l_noa_code ghr_nature_of_actions.code%type;
559: l_first_noa_code ghr_nature_of_actions.code%type;
560: l_second_noa_code ghr_nature_of_actions.code%type;
561: l_altered_pa_request_id ghr_pa_requests.pa_request_id%type;
562:

Line 559: l_first_noa_code ghr_nature_of_actions.code%type;

555: select altered_pa_request_id from ghr_pa_requests
556: where pa_request_id = p_pa_request_id;
557:
558: l_noa_code ghr_nature_of_actions.code%type;
559: l_first_noa_code ghr_nature_of_actions.code%type;
560: l_second_noa_code ghr_nature_of_actions.code%type;
561: l_altered_pa_request_id ghr_pa_requests.pa_request_id%type;
562:
563: cursor c_orig_rei_rec is

Line 560: l_second_noa_code ghr_nature_of_actions.code%type;

556: where pa_request_id = p_pa_request_id;
557:
558: l_noa_code ghr_nature_of_actions.code%type;
559: l_first_noa_code ghr_nature_of_actions.code%type;
560: l_second_noa_code ghr_nature_of_actions.code%type;
561: l_altered_pa_request_id ghr_pa_requests.pa_request_id%type;
562:
563: cursor c_orig_rei_rec is
564: select *

Line 702: l_noa_id ghr_nature_of_actions.nature_of_action_id%type;

698: l_per_ei_data per_people_extra_info%rowtype;
699: l_asg_ei_data per_assignment_extra_info%rowtype;
700: l_pos_ei_data per_position_extra_info%rowtype;
701: l_multiple_error_flag boolean;
702: l_noa_id ghr_nature_of_actions.nature_of_action_id%type;
703: l_proc varchar2(72):= g_package || 'noa_spec_extra_info';
704: l_information_type ghr_pa_request_info_types.information_type%type;
705: l_update_rei varchar2(1) := 'N';
706: l_exists boolean := FALSE;

Line 863: FROM ghr_nature_of_actions noa,

859: where pa_request_id = p_pa_request_id;
860:
861: cursor c_noac_1xx is
862: SELECT par.effective_date
863: FROM ghr_nature_of_actions noa,
864: ghr_pa_requests par,
865: ghr_pay_plans pp
866: WHERE noa.nature_of_action_id = par.first_noa_id
867: and par.pa_request_id = p_pa_request_id

Line 875: FROM ghr_nature_of_actions noa,

871: AND noa.code <> '130';
872:
873: cursor c_noac_5xx is
874: SELECT par.effective_date
875: FROM ghr_nature_of_actions noa,
876: ghr_pa_requests par,
877: ghr_pay_plans pp
878: WHERE (noa.nature_of_action_id = par.first_noa_id
879: ---Bug# 8263918

Line 893: FROM ghr_nature_of_actions noa,

889: AND noa.code not in ('542','543','546','548','549');
890:
891: cursor c_noac_130 is
892: SELECT par.effective_date
893: FROM ghr_nature_of_actions noa,
894: ghr_pa_requests par,
895: ghr_pay_plans pp
896: WHERE noa.nature_of_action_id = par.first_noa_id
897: and par.pa_request_id = p_pa_request_id

Line 905: FROM ghr_nature_of_actions noa,

901: AND par.first_action_la_code1 = 'KVM';
902:
903: cursor c_noac_sal_chg is
904: SELECT par.effective_date
905: FROM ghr_nature_of_actions noa,
906: ghr_pa_requests par,
907: ghr_pay_plans pp
908: WHERE (noa.nature_of_action_id = par.first_noa_id
909: ---Bug# 8263918

Line 2938: FROM ghr_nature_of_actions

2934: FROM per_positions
2935: WHERE position_id = p_position_id;
2936: cursor c_noa_code is
2937: SELECT 'X'
2938: FROM ghr_nature_of_actions
2939: WHERE nature_of_action_id = p_noa_id
2940: and code in ('825','840','841','842','843','844','845','846',
2941: '847','848','849','878','879' ); -- Bug 3266198 Added 848 and 849 to the NOA codes.
2942: l_agency_code ghr_pa_requests.agency_code%type;

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

4761:
4762:
4763: -- Get Information Type
4764: Procedure get_information_type
4765: (p_noa_id in ghr_nature_of_actions.nature_of_action_id%type,
4766: p_information_type out NOCOPY ghr_pa_request_info_types.information_type%type
4767: )
4768: is
4769:

Line 5223: from GHR_PA_REQUEST_INFO_TYPES a,ghr_noa_families b, ghr_nature_of_actions c

5219: cursor get_ord_of_eit(p_information_type1 in varchar2,
5220: p_information_type2 in varchar2)
5221: is
5222: select a.noa_family_code, a.information_type
5223: from GHR_PA_REQUEST_INFO_TYPES a,ghr_noa_families b, ghr_nature_of_actions c
5224: where b.nature_of_action_id= c.nature_of_action_id
5225: and a.noa_family_code= b.noa_family_code
5226: and c.code in (p_first_noa_code,p_second_noa_code)
5227: and a.information_type in (p_information_type1,p_information_type2)