APPS.PAY_NL_EOY_PKG dependencies on PER_TIME_PERIODS

Line 59: per_time_periods

55: select START_DATE
56: ,END_DATE
57: ,PERIOD_NUM
58: from
59: per_time_periods
60: where payroll_id=l_payroll_id
61: and period_name like '%'||l_prev_year||'%';
62: --and START_DATE >= l_prev_year_start_date
63: --and START_DATE <= l_prev_year_end_date;

Line 70: per_time_periods

66: ,p_effective_date DATE ) IS
67: select START_DATE
68: ,END_DATE
69: from
70: per_time_periods
71: where payroll_id=l_payroll_id
72: and p_effective_date between START_DATE and END_DATE;
73: --
74: CURSOR get_dp_period(c_pay_act_id NUMBER) IS

Line 78: ,per_time_periods ptp

74: CURSOR get_dp_period(c_pay_act_id NUMBER) IS
75: select ptp.start_date
76: ,ptp.end_date
77: from pay_payroll_actions ppa
78: ,per_time_periods ptp
79: where ppa.payroll_action_id = c_pay_act_id
80: AND ptp.time_period_id = ppa.time_period_id;
81: --
82: CURSOR get_ass_act_id(c_assignment_id NUMBER