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.

[Home] [Help]

APPS.GHR_VALIDATE_PERWSDPO dependencies on GHR_PD_CLASSIFICATIONS

Line 54: l_working_title_table ghr_pd_classifications.official_title%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;
58: l_occ_series_table ghr_pd_classifications.occupational_code%type :=null;

Line 55: l_pay_plan_table ghr_pd_classifications.pay_plan%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;
58: l_occ_series_table ghr_pd_classifications.occupational_code%type :=null;
59:

Line 56: l_valide_grade_table ghr_pd_classifications.grade_level%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;
58: l_occ_series_table ghr_pd_classifications.occupational_code%type :=null;
59:
60: cursor c_pos_extra_info is

Line 58: l_occ_series_table ghr_pd_classifications.occupational_code%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;
58: l_occ_series_table ghr_pd_classifications.occupational_code%type :=null;
59:
60: cursor c_pos_extra_info is
61: select poei.poei_information3,poei.poei_information4,poei.poei_information5
62: from per_position_extra_info poei

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: