APPS.PAY_FR_OVERTIME_MAPPING dependencies on PER_TIME_PERIODS

Line 65: from per_time_periods

61: l_py_period_end_date date;
62: --
63: cursor c_get_period_date(p_time_period_id number) is
64: select start_date,end_date
65: from per_time_periods
66: where time_period_id = p_time_period_id;
67: --
68: cursor c_get_last_period_end_date(p_payroll_id number) is
69: select max(end_date)

Line 70: from per_time_periods

66: where time_period_id = p_time_period_id;
67: --
68: cursor c_get_last_period_end_date(p_payroll_id number) is
69: select max(end_date)
70: from per_time_periods
71: where payroll_id = p_payroll_id;
72: --
73: cursor c_payroll_periods is
74: select time_period_id,end_date

Line 75: from per_time_periods

71: where payroll_id = p_payroll_id;
72: --
73: cursor c_payroll_periods is
74: select time_period_id,end_date
75: from per_time_periods
76: where payroll_id = p_payroll_id
77: and end_date >= l_min_py_period
78: and end_date <= l_max_py_period
79: order by end_date;

Line 83: from per_time_periods

79: order by end_date;
80: --
81: cursor c_overtime_periods is
82: select time_period_id,end_date
83: from per_time_periods
84: where payroll_id = p_overtime_payroll_id
85: and end_date >= l_min_ot_period
86: and end_date <= l_max_ot_period
87: order by end_date;

Line 181: UPDATE PER_TIME_PERIODS

177: --
178: /* Update the overtime period record to record the payroll period in which
179: it will be paid */
180: --
181: UPDATE PER_TIME_PERIODS
182: SET PRD_INFORMATION_CATEGORY = 'FR',
183: PRD_INFORMATION1 = to_char(p_payroll_id),
184: PRD_INFORMATION2 = to_char(l_py_period_id)
185: where TIME_PERIOD_ID = o.TIME_PERIOD_ID