APPS.GHR_BEN_VALIDATION dependencies on GHR_PA_REQUEST_EXTRA_INFO

Line 36: l_payroll_id ghr_pa_request_extra_info.rei_information3%type;

32: , p_annuitant_indicator in varchar2 default null
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);

Line 46: FROM ghr_pa_request_extra_info

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';
49:
50: CURSOR c_start_date(c_payroll_id pay_payrolls_f.payroll_id%type, c_year varchar2, c_month varchar2) IS