APPS.PER_VIEWS_PKG dependencies on PER_TIME_PERIODS

Line 25: from PER_TIME_PERIODS

21: p_effective_date date ) is
22: select PERIOD_NUM,
23: START_DATE,
24: END_DATE
25: from PER_TIME_PERIODS
26: where PAYROLL_ID = p_payroll_id
27: and p_effective_date between START_DATE and END_DATE;
28: --
29: --

Line 54: from per_time_periods

50: min(end_date),
51: max(start_date),
52: max(end_date),
53: count(period_num)
54: from per_time_periods
55: where payroll_id = p_payroll_id
56: -- and to_char(P_date,'YYYY/MM/DD') = to_char(end_date,'YYYY/MM/DD'); -- bug 6706398
57: and to_char(P_date,'YYYY') = to_char(end_date,'YYYY'); -- bug 6706398
58:

Line 1211: from per_time_periods

1207: CURSOR csr_get_time_periods is
1208: select start_date,
1209: end_date,
1210: period_num
1211: from per_time_periods
1212: where to_char(end_date,'YYYY/MM/DD') =
1213: to_char(p_accrual_calc_p_end_date,'YYYY/MM/DD')
1214: and end_date <= p_accrual_calc_p_end_date
1215: and period_num >=

Line 1226: from per_time_periods

1222: CURSOR csr_get_time_periods is
1223: select start_date,
1224: end_date,
1225: period_num
1226: from per_time_periods
1227: where to_char(end_date,'YYYY') =
1228: to_char(p_accrual_calc_p_end_date,'YYYY')
1229: and end_date <= p_accrual_calc_p_end_date
1230: and period_num >=