APPS.OTA_CRT_FINANCE_SEGMENT dependencies on OTA_EVENTS

Line 102: l_offering_id ota_events.offering_id%type;

98: l_administrator ota_finance_headers.administrator%type;
99: l_date_format varchar2(200);
100: l_hr_cost_segment ota_hr_gl_flex_maps.hr_cost_segment%type;
101:
102: l_offering_id ota_events.offering_id%type;
103:
104: CURSOR THG_FROM(p_business_group_id in number)
105: IS
106: Select

Line 169: OTA_EVENTS EVT

165:
166: CURSOR SPO IS
167: SELECT hr.COST_ALLOCATION_KEYFLEX_ID
168: FROM HR_ALL_ORGANIZATION_UNITS hr ,
169: OTA_EVENTS EVT
170: WHERE hr.organization_id = evt.organization_id and
171: evt.event_id = p_event_id;
172:
173: /* For Ilearning */

Line 177: FROM ota_events

173: /* For Ilearning */
174: CURSOR csr_event
175: IS
176: SELECT offering_id
177: FROM ota_events
178: where event_id= p_event_id;
179:
180: Begin
181: p_result := 'S';

Line 337: OTA_EVENTS EVT

333: CLOSE SPO;
334:
335: /* SELECT hr.COST_ALLOCATION_KEYFLEX_ID INTO l_cost_allocation_keyflex_id
336: FROM HR_ALL_ORGANIZATION_UNITS hr ,
337: OTA_EVENTS EVT
338: WHERE hr.organization_id = evt.organization_id and
339: evt.event_id = p_event_id; */
340: l_dynamicSqlString := 'SELECT '||l_hr_cost_segment || ' FROM PAY_COST_ALLOCATION_KEYFLEX
341: WHERE COST_ALLOCATION_KEYFLEX_ID = :txn ' ;

Line 575: OTA_EVENTS EVT

571: CLOSE SPO;
572:
573: /* SELECT hr.COST_ALLOCATION_KEYFLEX_ID INTO l_cost_allocation_keyflex_id
574: FROM HR_ALL_ORGANIZATION_UNITS hr ,
575: OTA_EVENTS EVT
576: WHERE hr.organization_id = evt.organization_id and
577: evt.event_id = p_event_id; */
578: l_dynamicSqlString := 'SELECT '||l_hr_cost_segment || ' FROM PAY_COST_ALLOCATION_KEYFLEX
579: WHERE COST_ALLOCATION_KEYFLEX_ID = :txn ' ;