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_POSN_RULES dependencies on GHR_PA_REQUESTS

Line 10: ,p_ghr_pa_requests in ghr_pa_requests%rowtype

6: ,p_pos_grp1_type in ghr_api.pos_grp1_type
7: ,p_pos_grp2_type in ghr_api.pos_grp2_type
8: ,p_pos_oblig_type in ghr_api.pos_oblig_type
9: ,p_pos_valid_grade_type in ghr_api.pos_valid_grade_type
10: ,p_ghr_pa_requests in ghr_pa_requests%rowtype
11: )
12: is
13: p_grade ghr_pa_requests.to_grade_or_level%type;
14: p_pay_plan ghr_pa_requests.to_pay_plan%type;

Line 13: p_grade ghr_pa_requests.to_grade_or_level%type;

9: ,p_pos_valid_grade_type in ghr_api.pos_valid_grade_type
10: ,p_ghr_pa_requests in ghr_pa_requests%rowtype
11: )
12: is
13: p_grade ghr_pa_requests.to_grade_or_level%type;
14: p_pay_plan ghr_pa_requests.to_pay_plan%type;
15: p_target_grade ghr_pa_requests.to_grade_or_level%type;
16: p_valid_grade ghr_pa_requests.to_grade_or_level%type;
17: l_grade_or_level ghr_pa_requests.to_grade_or_level%type;

Line 14: p_pay_plan ghr_pa_requests.to_pay_plan%type;

10: ,p_ghr_pa_requests in ghr_pa_requests%rowtype
11: )
12: is
13: p_grade ghr_pa_requests.to_grade_or_level%type;
14: p_pay_plan ghr_pa_requests.to_pay_plan%type;
15: p_target_grade ghr_pa_requests.to_grade_or_level%type;
16: p_valid_grade ghr_pa_requests.to_grade_or_level%type;
17: l_grade_or_level ghr_pa_requests.to_grade_or_level%type;
18: l_pay_plan ghr_pa_requests.to_pay_plan%type;

Line 15: p_target_grade ghr_pa_requests.to_grade_or_level%type;

11: )
12: is
13: p_grade ghr_pa_requests.to_grade_or_level%type;
14: p_pay_plan ghr_pa_requests.to_pay_plan%type;
15: p_target_grade ghr_pa_requests.to_grade_or_level%type;
16: p_valid_grade ghr_pa_requests.to_grade_or_level%type;
17: l_grade_or_level ghr_pa_requests.to_grade_or_level%type;
18: l_pay_plan ghr_pa_requests.to_pay_plan%type;
19:

Line 16: p_valid_grade ghr_pa_requests.to_grade_or_level%type;

12: is
13: p_grade ghr_pa_requests.to_grade_or_level%type;
14: p_pay_plan ghr_pa_requests.to_pay_plan%type;
15: p_target_grade ghr_pa_requests.to_grade_or_level%type;
16: p_valid_grade ghr_pa_requests.to_grade_or_level%type;
17: l_grade_or_level ghr_pa_requests.to_grade_or_level%type;
18: l_pay_plan ghr_pa_requests.to_pay_plan%type;
19:
20: CURSOR cur_grd IS

Line 17: l_grade_or_level ghr_pa_requests.to_grade_or_level%type;

13: p_grade ghr_pa_requests.to_grade_or_level%type;
14: p_pay_plan ghr_pa_requests.to_pay_plan%type;
15: p_target_grade ghr_pa_requests.to_grade_or_level%type;
16: p_valid_grade ghr_pa_requests.to_grade_or_level%type;
17: l_grade_or_level ghr_pa_requests.to_grade_or_level%type;
18: l_pay_plan ghr_pa_requests.to_pay_plan%type;
19:
20: CURSOR cur_grd IS
21: SELECT gdf.segment1 pay_plan

Line 18: l_pay_plan ghr_pa_requests.to_pay_plan%type;

14: p_pay_plan ghr_pa_requests.to_pay_plan%type;
15: p_target_grade ghr_pa_requests.to_grade_or_level%type;
16: p_valid_grade ghr_pa_requests.to_grade_or_level%type;
17: l_grade_or_level ghr_pa_requests.to_grade_or_level%type;
18: l_pay_plan ghr_pa_requests.to_pay_plan%type;
19:
20: CURSOR cur_grd IS
21: SELECT gdf.segment1 pay_plan
22: ,gdf.segment2 grade_or_level

Line 30: p_grade := nvl(p_ghr_pa_requests.to_grade_or_level, p_ghr_pa_requests.from_grade_or_level);

26: AND grd.grade_definition_id = gdf.grade_definition_id;
27:
28: begin
29:
30: p_grade := nvl(p_ghr_pa_requests.to_grade_or_level, p_ghr_pa_requests.from_grade_or_level);
31: p_pay_plan := nvl(p_ghr_pa_requests.to_pay_plan, p_ghr_pa_requests.from_pay_plan);
32: p_valid_grade := p_pay_plan||'-'||p_grade;
33:
34: open cur_grd;

Line 31: p_pay_plan := nvl(p_ghr_pa_requests.to_pay_plan, p_ghr_pa_requests.from_pay_plan);

27:
28: begin
29:
30: p_grade := nvl(p_ghr_pa_requests.to_grade_or_level, p_ghr_pa_requests.from_grade_or_level);
31: p_pay_plan := nvl(p_ghr_pa_requests.to_pay_plan, p_ghr_pa_requests.from_pay_plan);
32: p_valid_grade := p_pay_plan||'-'||p_grade;
33:
34: open cur_grd;
35: fetch cur_grd into l_pay_plan, l_grade_or_level;