APPS.GHR_BEN_VALIDATION dependencies on PER_TIME_PERIODS

Line 41: l_start_date per_time_periods.start_date%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;
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

Line 52: FROM per_time_periods

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
51: SELECT min(start_date) start_date
52: FROM per_time_periods
53: WHERE payroll_id = c_payroll_id
54: AND TO_CHAR(start_date,'YYYY') = c_year
55: AND TO_CHAR(start_date,'MM') = c_month;
56: