APPS.GHR_BEN_VALIDATION dependencies on GHR_PA_REQUEST_EXTRA_INFO

Line 38: l_payroll_id ghr_pa_request_extra_info.rei_information3%type;

34: --Bug # 12973371 Added TSP Roth amount and rate
35: , p_tsp_roth_401k_amt in number default null
36: , p_tsp_roth_401k_rate in number default null)
37: IS
38: l_payroll_id ghr_pa_request_extra_info.rei_information3%type;
39: l_noa_family_code ghr_pa_requests.noa_family_code%type;
40: l_st_month VARCHAR2(20);
41: l_end_month VARCHAR2(20);
42: l_pay_month VARCHAR2(20);

Line 48: FROM ghr_pa_request_extra_info

44: l_validate BOOLEAN;
45:
46: CURSOR c_payroll_id(c_pa_request_id ghr_pa_requests.pa_request_id%type) IS
47: SELECT rei_information3 payroll_id
48: FROM ghr_pa_request_extra_info
49: WHERE pa_request_id = c_pa_request_id
50: AND information_type = 'GHR_US_PAR_PAYROLL_TYPE';
51:
52: CURSOR c_start_date(c_payroll_id pay_payrolls_f.payroll_id%type, c_year varchar2, c_month varchar2) IS