DBA Data[Home] [Help]

APPS.OTA_TRAINING_SS dependencies on PER_PEOPLE_F

Line 1339: l_delegate_id PER_PEOPLE_F.person_id%TYPE;

1335: (p_validate IN BOOLEAN,p_transaction_step_id IN NUMBER, p_effective_date in varchar2 ) IS
1336:
1337: l_booking_id OTA_DELEGATE_BOOKINGS.booking_id%type := null;
1338: l_booking_status_row OTA_BOOKING_STATUS_TYPES%ROWTYPE;
1339: l_delegate_id PER_PEOPLE_F.person_id%TYPE;
1340: l_eventid ota_events.event_id%TYPE;
1341: l_object_version_number number;
1342: l_person_details OTA_ENROLL_IN_TRAINING_SS.csr_person_to_enroll_details%ROWTYPE;
1343: l_specialInstruction ota_delegate_bookings.SPECIAL_BOOKING_INSTRUCTIONS%TYPE;

Line 2259: l_delegate_id PER_PEOPLE_F.person_id%TYPE;

2255: l_eventid ota_events.event_id%TYPE;
2256: l_booking_id OTA_DELEGATE_BOOKINGS.booking_id%type := null;
2257: l_business_group_id OTA_DELEGATE_BOOKINGS.business_group_id%type;
2258: l_booking_status_row OTA_BOOKING_STATUS_TYPES%ROWTYPE;
2259: l_delegate_id PER_PEOPLE_F.person_id%TYPE;
2260: l_object_version_number number;
2261: l_date_booking_placed date;
2262: l_current_date date;
2263: result_object_version_number OTA_FINANCE_LINES.object_version_number%TYPE;