APPS.PAY_DK_MIA_REPORT_PKG dependencies on PER_TIME_PERIODS

Line 145: from per_time_periods

141: where payroll_action_id = l_payroll_action_id;
142:
143: cursor csr_get_period_dates(l_payroll_id IN NUMBER, l_effective_date IN DATE) is
144: select to_char(start_date,'YYYYMMDD'), to_char(end_date,'YYYYMMDD'), to_char(default_dd_date,'YYYYMMDD')
145: from per_time_periods
146: where payroll_id = l_payroll_id
147: and l_effective_date between start_date and end_date;
148:
149: l_payroll_id NUMBER;

Line 190: from per_time_periods

186: where payroll_action_id = l_payroll_action_id;
187:
188: cursor csr_get_payroll_period(l_payroll_id IN NUMBER, l_effective_date IN DATE) is
189: select period_name,period_num
190: from per_time_periods
191: where payroll_id = l_payroll_id
192: and l_effective_date between start_date and end_date;
193:
194: l_payroll_id NUMBER(9);