APPS.GHR_BEN_VALIDATION dependencies on GHR_PA_REQUESTS

Line 37: l_noa_family_code ghr_pa_requests.noa_family_code%type;

33: , p_assignment_id in number default null)
34:
35: IS
36: l_payroll_id ghr_pa_request_extra_info.rei_information3%type;
37: l_noa_family_code ghr_pa_requests.noa_family_code%type;
38: l_st_month VARCHAR2(20);
39: l_end_month VARCHAR2(20);
40: l_pay_month VARCHAR2(20);
41: l_start_date per_time_periods.start_date%type;

Line 44: CURSOR c_payroll_id(c_pa_request_id ghr_pa_requests.pa_request_id%type) IS

40: l_pay_month VARCHAR2(20);
41: l_start_date per_time_periods.start_date%type;
42: l_validate BOOLEAN;
43:
44: CURSOR c_payroll_id(c_pa_request_id ghr_pa_requests.pa_request_id%type) IS
45: SELECT rei_information3 payroll_id
46: FROM ghr_pa_request_extra_info
47: WHERE pa_request_id = c_pa_request_id
48: AND information_type = 'GHR_US_PAR_PAYROLL_TYPE';

Line 633: l_retirement_plan ghr_pa_requests.retirement_plan%type;

629: l_person_id per_all_people_f.person_id%type;
630: l_new_element_name pay_element_types_f.element_name%type;
631: l_element_name pay_element_types_f.element_name%type;
632: l_ret_plan_name varchar2(200);
633: l_retirement_plan ghr_pa_requests.retirement_plan%type;
634: l_debug_mode BOOLEAN;
635: BEGIN
636: -- Initialization
637: IF ghr_utility.is_ghr = 'TRUE' THEN