DBA Data[Home] [Help]

APPS.PER_OTHERBG_APL_API dependencies on PER_PERSON_TYPES

Line 377: ,per_person_types ppt

373:
374: cursor csr_ptu_row(l_person_id per_all_assignments_f.person_id%type,l_date_received Date) is
375: select ptu.effective_start_date
376: from per_person_type_usages_f ptu
377: ,per_person_types ppt
378: where ptu.person_id = l_person_id
379: and ptu.effective_start_date > l_date_received
380: and ptu.person_type_id = ppt.person_type_id
381: and ppt.system_person_type = 'EX_APL'