APPS.PAY_IE_BAL_UPLOAD dependencies on PER_ASSIGNMENTS_F

Line 98: per_time_periods ptp,per_time_periods ptp2,per_assignments_f ass

94: ) is
95: select
96: nvl(min(ptp2.start_date), END_OF_TIME)
97: from
98: per_time_periods ptp,per_time_periods ptp2,per_assignments_f ass
99: where
100: ass.assignment_id = p_assignment_id
101: and
102: p_upload_date between ass.effective_start_date and ass.effective_end_date

Line 122: per_time_periods ptp, per_assignments_f ass

118: ) is
119: select
120: nvl(ptp.start_date, END_OF_TIME)
121: from
122: per_time_periods ptp, per_assignments_f ass
123: where
124: ass.assignment_id = p_assignment_id
125: and
126: ptp.payroll_id = ass.payroll_id

Line 140: per_assignments_f ass

136: ) is
137: select
138: nvl(min(ass.effective_start_date), END_OF_TIME)
139: from
140: per_assignments_f ass
141: where
142: ass.assignment_id = p_assignment_id
143: and
144: ass.payroll_id is not null

Line 161: per_time_periods ptp, per_assignments_f ass

157: ) is
158: select
159: min(ptp.regular_payment_date)
160: from
161: per_time_periods ptp, per_assignments_f ass
162: where
163: ass.assignment_id = l_assignment_id
164: and
165: ptp.payroll_id = ass.payroll_id

Line 182: per_time_periods ptp, per_assignments_f ass

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

Line 259: per_assignments_f

255: distinct business_group_id -- for bug 5258159 added distinct clause.
256: into
257: l_business_group_id
258: from
259: per_assignments_f
260: where
261: assignment_id = p_assignment_id;
262: l_expiry_date := hr_gbbal.dimension_reset_date
263: (