DBA Data[Home] [Help]

APPS.GHR_ELT_TO_BEN_PKG dependencies on GHR_PROCESS_LOG

Line 226: l_log_text ghr_process_log.log_text%TYPE;

222: l_pa_history_rec ghr_pa_history%rowtype;
223: l_new_effective_date DATE;
224: l_old_effective_date DATE;
225: l_cnt NUMBER;
226: l_log_text ghr_process_log.log_text%TYPE;
227: l_program_name ghr_process_log.program_name%TYPE;
228: l_req VARCHAR2 (25);
229: l_errbuf VARCHAR2(2000);
230: l_retcode NUMBER;

Line 227: l_program_name ghr_process_log.program_name%TYPE;

223: l_new_effective_date DATE;
224: l_old_effective_date DATE;
225: l_cnt NUMBER;
226: l_log_text ghr_process_log.log_text%TYPE;
227: l_program_name ghr_process_log.program_name%TYPE;
228: l_req VARCHAR2 (25);
229: l_errbuf VARCHAR2(2000);
230: l_retcode NUMBER;
231:

Line 633: l_program_name ghr_process_log.program_name%TYPE;

629:
630: l_assignment_id pay_element_entries_f.assignment_id%type;
631: l_req VARCHAR2 (25);
632: l_ssn per_all_people_f.national_identifier%TYPE;
633: l_program_name ghr_process_log.program_name%TYPE;
634: cursor cur_business_group is
635: select business_group_id from per_assignments_f
636: where assignment_id = l_assignment_id;
637: