APPS.PAY_PAYACVEA_PKG dependencies on PER_TIME_PERIODS

Line 53: from per_time_periods ptp

49: -- find out what year we're dealing with...
50: --
51: select to_char(ptp.start_date, 'YYYY')
52: into l_year
53: from per_time_periods ptp
54: where p_session_date between
55: ptp.start_date and ptp.end_date
56: and ptp.payroll_id = p_payroll_id;
57: --

Line 63: from per_time_periods ptp1,

59: --
60: hr_utility.set_location('pay_payacvea_pkg.get_dates', 1);
61: select greatest(ptp1.start_date, ptp2.start_date)
62: into p_start_date
63: from per_time_periods ptp1,
64: per_time_periods ptp2
65: where ptp1.start_date =
66: (
67: select min(ptp3.start_date)

Line 64: per_time_periods ptp2

60: hr_utility.set_location('pay_payacvea_pkg.get_dates', 1);
61: select greatest(ptp1.start_date, ptp2.start_date)
62: into p_start_date
63: from per_time_periods ptp1,
64: per_time_periods ptp2
65: where ptp1.start_date =
66: (
67: select min(ptp3.start_date)
68: from per_time_periods ptp3

Line 68: from per_time_periods ptp3

64: per_time_periods ptp2
65: where ptp1.start_date =
66: (
67: select min(ptp3.start_date)
68: from per_time_periods ptp3
69: where ptp3.start_date >=
70: (
71: select min(effective_start_date)
72: from pay_element_entries_f pee

Line 81: from per_time_periods ptp3

77: and ptp1.payroll_id = p_payroll_id
78: and ptp2.start_date =
79: (
80: select min(ptp3.start_date)
81: from per_time_periods ptp3
82: where ptp3.start_date >=
83: to_date('01-01-'||l_year, 'DD-MM-YYYY')
84: and ptp3.payroll_id = ptp2.payroll_id
85: )

Line 103: from per_time_periods ptp1

99: hr_utility.set_location('pay_payacvea_pkg.get_dates', 3);
100: begin
101: select ptp1.end_date
102: into l_end_date
103: from per_time_periods ptp1
104: where ptp1.end_date =
105: (
106: select max(ptp2.end_date)
107: from per_time_periods ptp2

Line 107: from per_time_periods ptp2

103: from per_time_periods ptp1
104: where ptp1.end_date =
105: (
106: select max(ptp2.end_date)
107: from per_time_periods ptp2
108: where ptp2.end_date <=
109: (
110: select max(effective_end_date)
111: from pay_element_entries_f pee

Line 134: from per_time_periods ptp1

130: hr_utility.set_location('pay_payacvea_pkg.get_dates', 4);
131: begin
132: select ptp1.end_date
133: into l_end_date
134: from per_time_periods ptp1
135: where ptp1.end_date =
136: (
137: select max(ptp2.end_date)
138: from per_periods_of_service pos,

Line 139: per_time_periods ptp2

135: where ptp1.end_date =
136: (
137: select max(ptp2.end_date)
138: from per_periods_of_service pos,
139: per_time_periods ptp2
140: where p_session_date between
141: pos.date_start and pos.actual_termination_date
142: and pos.person_id = p_person_id
143: and pos.actual_termination_date <= ptp2.end_date