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 1064: FROM per_time_periods

1060:
1061:
1062: CURSOR cur_count_pay_periods(p_start_date1 DATE) IS
1063: SELECT COUNT(*)
1064: FROM per_time_periods
1065: WHERE payroll_id = p_payroll_id
1066: AND end_date >= p_start_date1
1067: AND start_date <= p_end_date;
1068:

Line 1089: per_time_periods ptp

1085: cursor cur_next_prd_start_date is
1086: select
1087: ptp.end_date + 1
1088: from
1089: per_time_periods ptp
1090: where
1091: ptp.payroll_id = p_payroll_id and
1092: p_start_date between
1093: ptp.start_date and ptp.end_date;

Line 1098: from per_time_periods

1094:
1095: cursor csr_start_date (p_payroll_id number,
1096: p_start_date date) is
1097: select start_date
1098: from per_time_periods
1099: where payroll_id = p_payroll_id
1100: and start_date = p_start_date;
1101:
1102: l_period_start_date date;

Line 1110: per_time_periods ptp,

1106: select
1107: ptp2.start_date,
1108: ptp2.end_date
1109: from
1110: per_time_periods ptp,
1111: per_time_periods ptp1,
1112: per_time_periods ptp2
1113: where
1114: ptp.payroll_id = p_payroll_id and

Line 1111: per_time_periods ptp1,

1107: ptp2.start_date,
1108: ptp2.end_date
1109: from
1110: per_time_periods ptp,
1111: per_time_periods ptp1,
1112: per_time_periods ptp2
1113: where
1114: ptp.payroll_id = p_payroll_id and
1115: p_date between

Line 1112: per_time_periods ptp2

1108: ptp2.end_date
1109: from
1110: per_time_periods ptp,
1111: per_time_periods ptp1,
1112: per_time_periods ptp2
1113: where
1114: ptp.payroll_id = p_payroll_id and
1115: p_date between
1116: ptp.start_date and

Line 1154: per_time_periods ptp

1150: select
1151: ptp.start_date,
1152: ptp.end_date
1153: from
1154: per_time_periods ptp
1155: where
1156: ptp.payroll_id = p_payroll_id and
1157: p_date between
1158: ptp.start_date and