APPS.PAY_NL_EOY_PKG dependencies on PER_TIME_PERIODS

Line 67: per_time_periods

63: select START_DATE
64: ,END_DATE
65: ,PERIOD_NUM
66: from
67: per_time_periods
68: where payroll_id=l_payroll_id
69: and period_name like '%'||l_prev_year||'%';
70: --and START_DATE >= l_prev_year_start_date
71: --and START_DATE <= l_prev_year_end_date;

Line 78: per_time_periods

74: ,p_effective_date DATE ) IS
75: select START_DATE
76: ,END_DATE
77: from
78: per_time_periods
79: where payroll_id=l_payroll_id
80: and p_effective_date between START_DATE and END_DATE;
81: --
82: CURSOR get_dp_period(c_pay_act_id NUMBER) IS

Line 86: ,per_time_periods ptp

82: CURSOR get_dp_period(c_pay_act_id NUMBER) IS
83: select ptp.start_date
84: ,ptp.end_date
85: from pay_payroll_actions ppa
86: ,per_time_periods ptp
87: where ppa.payroll_action_id = c_pay_act_id
88: AND ptp.time_period_id = ppa.time_period_id;
89: --
90: CURSOR get_ass_act_id(c_assignment_id NUMBER