DBA Data[Home] [Help]

APPS.PAY_PAYWSLEE_PKG dependencies on PER_PEOPLE_F

Line 219: from per_people_f PERSON,

215: cursor asgt_details is
216: --
217: select person.full_name,
218: asgt.assignment_number
219: from per_people_f PERSON,
220: per_assignments_f2 ASGT
221: where person.person_id = asgt.person_id
222: and asgt.assignment_id = p_assignment_id
223: and p_effective_end_date between asgt.effective_start_date

Line 754: from per_people_f PERSON,

750: cursor asgt_details is
751: --
752: select person.full_name,
753: asgt.assignment_number
754: from per_people_f PERSON,
755: per_assignments_f2 ASGT
756: where person.person_id = asgt.person_id
757: and asgt.assignment_id = p_assignment_id
758: and p_effective_end_date between asgt.effective_start_date