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_VALIDATE_PERWSDPO dependencies on GHR_POSITION_DESCRIPTIONS

Line 49: l_FLSA_table ghr_position_descriptions.FLSA%type :=null;

45: l_Per_office_id_DDF per_position_extra_info.poei_information3%type :=null;
46: l_BU_Status_DDF per_position_extra_info.poei_information8%type :=null;
47: l_Work_Schedule_DDF per_position_extra_info.poei_information10%type :=null;
48:
49: l_FLSA_table ghr_position_descriptions.FLSA%type :=null;
50: l_position_occ_table ghr_position_descriptions.position_status%type :=null;
51: l_super_status_table ghr_position_descriptions.position_is%type :=null;
52: l_position_sens_table ghr_position_descriptions.position_sensitivity%type :=null;
53: l_compet_level_table ghr_position_descriptions.competitive_level%type :=null;

Line 50: l_position_occ_table ghr_position_descriptions.position_status%type :=null;

46: l_BU_Status_DDF per_position_extra_info.poei_information8%type :=null;
47: l_Work_Schedule_DDF per_position_extra_info.poei_information10%type :=null;
48:
49: l_FLSA_table ghr_position_descriptions.FLSA%type :=null;
50: l_position_occ_table ghr_position_descriptions.position_status%type :=null;
51: l_super_status_table ghr_position_descriptions.position_is%type :=null;
52: l_position_sens_table ghr_position_descriptions.position_sensitivity%type :=null;
53: l_compet_level_table ghr_position_descriptions.competitive_level%type :=null;
54: l_working_title_table ghr_pd_classifications.official_title%type :=null;

Line 51: l_super_status_table ghr_position_descriptions.position_is%type :=null;

47: l_Work_Schedule_DDF per_position_extra_info.poei_information10%type :=null;
48:
49: l_FLSA_table ghr_position_descriptions.FLSA%type :=null;
50: l_position_occ_table ghr_position_descriptions.position_status%type :=null;
51: l_super_status_table ghr_position_descriptions.position_is%type :=null;
52: l_position_sens_table ghr_position_descriptions.position_sensitivity%type :=null;
53: l_compet_level_table ghr_position_descriptions.competitive_level%type :=null;
54: l_working_title_table ghr_pd_classifications.official_title%type :=null;
55: l_pay_plan_table ghr_pd_classifications.pay_plan%type :=null;

Line 52: l_position_sens_table ghr_position_descriptions.position_sensitivity%type :=null;

48:
49: l_FLSA_table ghr_position_descriptions.FLSA%type :=null;
50: l_position_occ_table ghr_position_descriptions.position_status%type :=null;
51: l_super_status_table ghr_position_descriptions.position_is%type :=null;
52: l_position_sens_table ghr_position_descriptions.position_sensitivity%type :=null;
53: l_compet_level_table ghr_position_descriptions.competitive_level%type :=null;
54: l_working_title_table ghr_pd_classifications.official_title%type :=null;
55: l_pay_plan_table ghr_pd_classifications.pay_plan%type :=null;
56: l_valide_grade_table ghr_pd_classifications.grade_level%type :=null;

Line 53: l_compet_level_table ghr_position_descriptions.competitive_level%type :=null;

49: l_FLSA_table ghr_position_descriptions.FLSA%type :=null;
50: l_position_occ_table ghr_position_descriptions.position_status%type :=null;
51: l_super_status_table ghr_position_descriptions.position_is%type :=null;
52: l_position_sens_table ghr_position_descriptions.position_sensitivity%type :=null;
53: l_compet_level_table ghr_position_descriptions.competitive_level%type :=null;
54: l_working_title_table ghr_pd_classifications.official_title%type :=null;
55: l_pay_plan_table ghr_pd_classifications.pay_plan%type :=null;
56: l_valide_grade_table ghr_pd_classifications.grade_level%type :=null;
57: l_payplan_grade_table varchar2(10) :=null;

Line 93: from ghr_position_descriptions pd, ghr_pd_classifications cl

89:
90: cursor c_pos_desc_table is
91: select pd.flsa, pd.position_status, pd.position_is,pd.position_sensitivity,pd.competitive_level,
92: cl.official_title, cl.pay_plan, cl.grade_level, cl.occupational_code
93: from ghr_position_descriptions pd, ghr_pd_classifications cl
94: where pd.position_description_id = l_pos_desc_id
95: and pd.position_description_id=cl.position_description_id;
96:
97:

Line 152: /* get values from ghr_position_descriptions */

148: l_occ_series_KF := ghr_api.get_job_occ_series_job(l_job_id ,l_business_group_id);
149: end if;
150:
151:
152: /* get values from ghr_position_descriptions */
153:
154: FOR c_pos_desc_table_rec IN c_pos_desc_table LOOP
155: l_FLSA_table:= c_pos_desc_table_rec.flsa;
156: l_position_occ_table := c_pos_desc_table_rec.position_status;