DBA Data[Home] [Help]

APPS.PER_CANCEL_APPLICATION_API dependencies on PER_APPLICATIONS

Line 23: from per_applications pa

19: -- Declare cursors and local variables
20: --
21: cursor date_received is
22: select pa.date_received
23: from per_applications pa
24: where pa.person_id = p_person_id
25: and pa.application_id = p_application_id;
26: --
27: cursor get_person_type(p_received_date DATE) is