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