APPS.PAY_CA_ROE_EI_PKG dependencies on PER_TIME_PERIODS

Line 39: FROM per_time_periods tpd

35: p_start_date DATE,
36: p_end_date DATE) IS
37: SELECT tpd.start_date,
38: tpd.end_date
39: FROM per_time_periods tpd
40: WHERE payroll_id = p_payroll_id
41: AND ((start_date >= p_start_date
42: AND end_date < p_end_date )
43: OR

Line 51: FROM per_time_periods tpd

47:
48: CURSOR csr_prev_roe_end_date (p_payroll_id NUMBER,
49: p_start_date DATE) IS
50: SELECT tpd.end_date
51: FROM per_time_periods tpd
52: WHERE tpd.payroll_id = p_payroll_id
53: AND p_start_date BETWEEN
54: tpd.start_date
55: AND tpd.end_date;

Line 398: FROM per_time_periods tpd

394: p_date DATE) IS
395: SELECT tpd.period_type,
396: tpd.start_date,
397: tpd.end_date
398: FROM per_time_periods tpd
399: WHERE tpd.payroll_id = p_payroll_id
400: AND p_date BETWEEN tpd.start_date
401: AND tpd.end_date;
402:

Line 1224: FROM per_time_periods

1220:
1221:
1222: CURSOR cur_count_pay_periods(p_start_date1 DATE) IS
1223: SELECT COUNT(*)
1224: FROM per_time_periods
1225: WHERE payroll_id = p_payroll_id
1226: AND end_date >= p_start_date1
1227: AND start_date <= p_end_date;
1228:

Line 1249: per_time_periods ptp

1245: cursor cur_next_prd_start_date is
1246: select
1247: ptp.end_date + 1
1248: from
1249: per_time_periods ptp
1250: where
1251: ptp.payroll_id = p_payroll_id and
1252: p_start_date between
1253: ptp.start_date and ptp.end_date;

Line 1258: from per_time_periods

1254:
1255: cursor csr_start_date (p_payroll_id number,
1256: p_start_date date) is
1257: select start_date
1258: from per_time_periods
1259: where payroll_id = p_payroll_id
1260: and start_date = p_start_date;
1261:
1262: l_period_start_date date;

Line 1270: per_time_periods ptp,

1266: select
1267: ptp2.start_date,
1268: ptp2.end_date
1269: from
1270: per_time_periods ptp,
1271: per_time_periods ptp1,
1272: per_time_periods ptp2
1273: where
1274: ptp.payroll_id = p_payroll_id and

Line 1271: per_time_periods ptp1,

1267: ptp2.start_date,
1268: ptp2.end_date
1269: from
1270: per_time_periods ptp,
1271: per_time_periods ptp1,
1272: per_time_periods ptp2
1273: where
1274: ptp.payroll_id = p_payroll_id and
1275: p_date between

Line 1272: per_time_periods ptp2

1268: ptp2.end_date
1269: from
1270: per_time_periods ptp,
1271: per_time_periods ptp1,
1272: per_time_periods ptp2
1273: where
1274: ptp.payroll_id = p_payroll_id and
1275: p_date between
1276: ptp.start_date and

Line 1314: per_time_periods ptp

1310: select
1311: ptp.start_date,
1312: ptp.end_date
1313: from
1314: per_time_periods ptp
1315: where
1316: ptp.payroll_id = p_payroll_id and
1317: p_date between
1318: ptp.start_date and