APPS.PAY_ZA_BAL_UPLOAD dependencies on PER_ASSIGNMENTS_F

Line 44: per_time_periods ptp, per_time_periods ptp2, per_assignments_f ass

40: ) is
41: select
42: nvl(min(ptp2.start_date), END_OF_TIME)
43: from
44: per_time_periods ptp, per_time_periods ptp2, per_assignments_f ass
45: where
46: ass.assignment_id = p_assignment_id
47: and
48: p_upload_date between ass.effective_start_date and ass.effective_end_date

Line 68: per_time_periods ptp, per_time_periods ptp2, per_assignments_f ass

64: ) is
65: select
66: nvl(min(ptp2.start_date), END_OF_TIME)
67: from
68: per_time_periods ptp, per_time_periods ptp2, per_assignments_f ass
69: where
70: ass.assignment_id = p_assignment_id
71: and
72: p_upload_date between ass.effective_start_date and ass.effective_end_date

Line 94: per_time_periods ptp, per_time_periods ptp2, per_assignments_f ass

90: ) is
91: select
92: nvl(min(ptp2.start_date), END_OF_TIME)
93: from
94: per_time_periods ptp, per_time_periods ptp2, per_assignments_f ass
95: where
96: ass.assignment_id = p_assignment_id
97: and
98: p_upload_date between ass.effective_start_date and ass.effective_end_date

Line 118: per_time_periods ptp, per_time_periods ptp2, per_assignments_f ass

114: ) is
115: select
116: nvl(min(ptp2.start_date), END_OF_TIME)
117: from
118: per_time_periods ptp, per_time_periods ptp2, per_assignments_f ass
119: where
120: ass.assignment_id = p_assignment_id
121: and
122: p_upload_date between ass.effective_start_date and ass.effective_end_date

Line 141: per_time_periods ptp, per_assignments_f ass

137: ) is
138: select
139: nvl(ptp.start_date, END_OF_TIME)
140: from
141: per_time_periods ptp, per_assignments_f ass
142: where
143: ass.assignment_id = p_assignment_id
144: and
145: ptp.payroll_id = ass.payroll_id

Line 160: per_assignments_f ass

156: ) is
157: select
158: nvl(min(ass.effective_start_date), END_OF_TIME)
159: from
160: per_assignments_f ass
161: where
162: ass.assignment_id = p_assignment_id
163: and
164: ass.payroll_id is not null

Line 180: per_time_periods ptp, per_assignments_f ass

176: ) is
177: select
178: min(ptp.regular_payment_date)
179: from
180: per_time_periods ptp, per_assignments_f ass
181: where
182: ass.assignment_id = l_assignment_id
183: and
184: ptp.payroll_id = ass.payroll_id

Line 202: per_time_periods ptp, per_assignments_f ass

198: ) is
199: select
200: ptp.regular_payment_date
201: from
202: per_time_periods ptp, per_assignments_f ass
203: where
204: ass.assignment_id = l_assignment_id
205: and
206: ptp.payroll_id = ass.payroll_id

Line 246: per_assignments_f

242: business_group_id
243: into
244: l_business_group_id
245: from
246: per_assignments_f
247: where
248: assignment_id = p_assignment_id;
249:
250: l_expiry_date := hr_gbbal.dimension_reset_date