APPS.OTA_WF dependencies on OTA_EVENTS

Line 633: FROM OTA_EVENTS

629:
630: CURSOR C_EVENT
631: IS
632: SELECT Course_End_date
633: FROM OTA_EVENTS
634: WHERE LINE_ID = l_line_id;
635: Line_id OE_ORDER_LINES.line_id%type;
636: l_course_end_date OTA_EVENTS.course_end_date%type;
637:

Line 636: l_course_end_date OTA_EVENTS.course_end_date%type;

632: SELECT Course_End_date
633: FROM OTA_EVENTS
634: WHERE LINE_ID = l_line_id;
635: Line_id OE_ORDER_LINES.line_id%type;
636: l_course_end_date OTA_EVENTS.course_end_date%type;
637:
638: CURSOR C_ORDER IS
639: SELECT HEADER_ID,ORG_ID
640: FROM OE_ORDER_LINES_ALL

Line 959: ota_events where

955: SELECT email_address
956: FROM per_people_f
957: WHERE person_id IN(
958: select owner_id from
959: ota_events where
960: line_id = l_line_id);*/
961:
962:
963: BEGIN

Line 1094: OTA_EVENTS

1090: IS
1091: SELECT
1092: null
1093: FROM
1094: OTA_EVENTS
1095: WHERE
1096: line_id = l_line_id;
1097:
1098: CURSOR c_enr

Line 1721: ota_events where

1717: SELECT user_name
1718: FROM FND_USER
1719: WHERE employee_id IN(
1720: select owner_id from
1721: ota_events where
1722: line_id = l_line_id);
1723:
1724:
1725: BEGIN

Line 1819: l_event_id ota_events.event_id%type;

1815: ,resultout OUT NOCOPY VARCHAR2)
1816:
1817: IS
1818:
1819: l_event_id ota_events.event_id%type;
1820:
1821:
1822: CURSOR C_EVENT
1823: IS

Line 1827: OTA_EVENTS

1823: IS
1824: SELECT
1825: EVENT_ID
1826: FROM
1827: OTA_EVENTS
1828: WHERE
1829: line_id = to_number(itemkey);
1830:
1831: CURSOR c_Enroll_type