67: ) is
68: select
69: nvl(ptp.start_date, END_OF_TIME)
70: from
71: per_time_periods ptp, per_assignments_f ass
72: where
73: ass.assignment_id = p_assignment_id
74: and
75: ptp.payroll_id = ass.payroll_id
86: ) is
87: select
88: nvl(min(ass.effective_start_date), END_OF_TIME)
89: from
90: per_assignments_f ass
91: where
92: ass.assignment_id = p_assignment_id
93: and
94: ass.payroll_id is not null
182: business_group_id
183: into
184: l_business_group_id
185: from
186: per_assignments_f
187: where
188: assignment_id = p_assignment_id;
189: l_expiry_date := hr_gbbal.dimension_reset_date
190: (