DBA Data[Home] [Help]

APPS.PAY_PAYWSLEE_PKG dependencies on PER_ASSIGNMENTS_F2

Line 220: per_assignments_f2 ASGT

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
224: and asgt.effective_end_date

Line 769: per_assignments_f2 ASGT

765: --
766: select person.full_name,
767: asgt.assignment_number
768: from per_people_f PERSON,
769: per_assignments_f2 ASGT
770: where person.person_id = asgt.person_id
771: and asgt.assignment_id = p_assignment_id
772: and p_effective_end_date between asgt.effective_start_date
773: and asgt.effective_end_date