DBA Data[Home] [Help]

APPS.PAY_US_SOE_BALANCES_PKG dependencies on PER_ASSIGNMENTS_F

Line 206: from per_assignments_f paa,

202: -- the current year for which SOE is being viewed
203: CURSOR c_get_assignments (c_assignment_id number,c_period_end_date date)
204: IS
205: select distinct paa1.assignment_id
206: from per_assignments_f paa,
207: per_assignments_f paa1,
208: per_people_f ppa
209: where paa.assignment_id = c_assignment_id
210: and paa.person_id = ppa.person_id

Line 207: per_assignments_f paa1,

203: CURSOR c_get_assignments (c_assignment_id number,c_period_end_date date)
204: IS
205: select distinct paa1.assignment_id
206: from per_assignments_f paa,
207: per_assignments_f paa1,
208: per_people_f ppa
209: where paa.assignment_id = c_assignment_id
210: and paa.person_id = ppa.person_id
211: and paa1.person_id = ppa.person_id