APPS.PAY_GB_ENROLL_PEN_REPORTING dependencies on PER_TIME_PERIODS

Line 62: cursor cur_get_input_time(p_period number,p_payroll_id per_time_periods.payroll_id%type) is

58: FROM per_all_assignments_f
59: WHERE assignment_id = p_assignment_id
60: AND p_end_date between effective_start_date and effective_end_date;
61:
62: cursor cur_get_input_time(p_period number,p_payroll_id per_time_periods.payroll_id%type) is
63: select start_date,end_date,period_name
64: from per_time_periods
65: where TIME_PERIOD_ID=p_period and payroll_id =p_payroll_id;
66:

Line 64: from per_time_periods

60: AND p_end_date between effective_start_date and effective_end_date;
61:
62: cursor cur_get_input_time(p_period number,p_payroll_id per_time_periods.payroll_id%type) is
63: select start_date,end_date,period_name
64: from per_time_periods
65: where TIME_PERIOD_ID=p_period and payroll_id =p_payroll_id;
66:
67: cursor cur_payroll_name(p_payroll number,p_end_date date) is
68: select payroll_name from pay_all_payrolls_f where payroll_id = p_payroll