DBA Data[Home] [Help]

APPS.GHR_SES_CONV_PKG dependencies on GHR_PA_REQUESTS

Line 26: l_effective_date ghr_pa_requests.effective_date%type := to_date('2004/01/11','YYYY/MM/DD');

22: IS
23:
24: l_mesgbuff VARCHAR2(4000);
25: l_prog_name ghr_process_log.program_name%type;
26: l_effective_date ghr_pa_requests.effective_date%type := to_date('2004/01/11','YYYY/MM/DD');
27:
28: l_user_tab_name pay_user_tables.user_table_name%type
29: := 'ESSL Oracle Federal Standard Pay Table (EP, ES, IE, IP, FE, SL and ST) No. ESSL';
30:

Line 127: l_his_eff_date ghr_pa_requests.effective_date%type;

123: l_grade_or_level per_grade_definitions.segment2%type;
124: l_posei_id per_position_extra_info.position_extra_info_id%type;
125: l_grd_id per_position_extra_info.poei_information5%type;
126: l_hist_id ghr_pa_history.pa_history_id%type;
127: l_his_eff_date ghr_pa_requests.effective_date%type;
128: l_counter NUMBER := 0;
129: l_counter1 NUMBER := 0;
130: --
131: --