DBA Data[Home] [Help]

APPS.GHR_SF52_POST_UPDATE dependencies on PER_ALL_ASSIGNMENTS_F

Line 192: from per_all_assignments_f asg1,

188:
189:
190: Cursor C_asg_posn is
191: select asg1.assignment_id
192: from per_all_assignments_f asg1,
193: per_all_assignments_f asg
194: where asg.person_id = l_person_id
195: and asg1.person_id <> l_person_id
196: and p_effective_date

Line 193: per_all_assignments_f asg

189:
190: Cursor C_asg_posn is
191: select asg1.assignment_id
192: from per_all_assignments_f asg1,
193: per_all_assignments_f asg
194: where asg.person_id = l_person_id
195: and asg1.person_id <> l_person_id
196: and p_effective_date
197: between asg.effective_start_date and asg.effective_end_date