APPS.OTA_CRT_FINANCE_SEGMENT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 106

Select
      tcc.gl_set_of_books_id,
	thg.SEGMENT
	,thg.SEGMENT_NUM
	,thg.HR_DATA_SOURCE
	,thg.CONSTANT
	,thg.HR_COST_SEGMENT
FROM  OTA_HR_GL_FLEX_MAPS THG
      ,OTA_CROSS_CHARGES TCC
WHERE THG.Cross_charge_id = TCC.Cross_charge_id and
      TCC.Business_group_id = p_business_group_id and
      TCC.Type = 'E' and
      TCC.FROM_TO = 'F' and
      Trunc(sysdate) between tcc.start_date_active and nvl(tcc.end_date_active,sysdate)
ORDER BY thg.segment_num;

Line: 125

Select
      tcc.gl_set_of_books_id,
	thg.SEGMENT
	,thg.SEGMENT_NUM
	,thg.HR_DATA_SOURCE
	,thg.CONSTANT
	,thg.HR_COST_SEGMENT
FROM  OTA_HR_GL_FLEX_MAPS THG
      ,OTA_CROSS_CHARGES TCC
WHERE THG.Cross_charge_id = TCC.Cross_charge_id and
      TCC.Business_group_id = p_business_group_id_to and
      TCC.Type = 'E' and
      TCC.FROM_TO = 'T' and
      Trunc(sysdate) between tcc.start_date_active and nvl(tcc.end_date_active,sysdate)
ORDER BY thg.segment_num;

Line: 145

SELECT
  COST_ALLOCATION_KEYFLEX_ID
FROM HR_ALL_ORGANIZATION_UNITS
WHERE ORGANIZATION_ID = l_organization_id;

Line: 152

SELECT CHART_OF_ACCOUNTS_ID
FROM GL_SETS_OF_BOOKS
WHERE SET_OF_BOOKS_ID = p_set_of_books_id;

Line: 157

SELECT hr.COST_ALLOCATION_KEYFLEX_ID
FROM   HR_ALL_ORGANIZATION_UNITS hr ,
       PER_ALL_ASSIGNMENTS_F asg
WHERE hr.organization_id = asg.organization_id and
      asg.organization_id = p_organization_id and
      asg.assignment_id = p_assignment_id and
      trunc(sysdate) between asg.effective_start_date and
                             asg.effective_end_date;

Line: 167

SELECT hr.COST_ALLOCATION_KEYFLEX_ID
FROM   HR_ALL_ORGANIZATION_UNITS hr ,
       OTA_EVENTS EVT
WHERE  hr.organization_id = evt.organization_id and
       evt.event_id = p_event_id;

Line: 176

SELECT offering_id
FROM ota_events
where event_id= p_event_id;

Line: 222

             SELECT COST_ALLOCATION_KEYFLEX_ID INTO l_cost_allocation_keyflex_id
             FROM   HR_ALL_ORGANIZATION_UNITS WHERE organization_id = p_business_group_id_from;

Line: 226

            l_dynamicSqlString := 'SELECT '|| l_hr_cost_segment ||' FROM PAY_COST_ALLOCATION_KEYFLEX
                       WHERE COST_ALLOCATION_KEYFLEX_ID = :txn '  ;

Line: 261

         l_dynamicSqlString := 'SELECT '|| l_hr_cost_segment || ' FROM PAY_COST_ALLOCATION_KEYFLEX
                       WHERE COST_ALLOCATION_KEYFLEX_ID = :txn '  ;

Line: 292

       /*   SELECT hr.COST_ALLOCATION_KEYFLEX_ID INTO l_cost_allocation_keyflex_id
          FROM   HR_ALL_ORGANIZATION_UNITS hr ,
                 PER_ALL_ASSIGNMENTS_F asg
          WHERE hr.organization_id = asg.organization_id and
                asg.organization_id = p_organization_id and
                asg.assignment_id = p_assignment_id ; */

Line: 299

 	    l_dynamicSqlString := 'SELECT '||l_hr_cost_segment || ' FROM PAY_COST_ALLOCATION_KEYFLEX
                       WHERE COST_ALLOCATION_KEYFLEX_ID = :txn '  ;

Line: 335

         /* SELECT hr.COST_ALLOCATION_KEYFLEX_ID INTO l_cost_allocation_keyflex_id
          FROM   HR_ALL_ORGANIZATION_UNITS hr ,
                 OTA_EVENTS EVT
          WHERE hr.organization_id = evt.organization_id and
                evt.event_id = p_event_id; */

Line: 340

          l_dynamicSqlString := 'SELECT '||l_hr_cost_segment || ' FROM PAY_COST_ALLOCATION_KEYFLEX
                       WHERE COST_ALLOCATION_KEYFLEX_ID = :txn '  ;

Line: 458

             SELECT COST_ALLOCATION_KEYFLEX_ID INTO l_cost_allocation_keyflex_id
             FROM   HR_ALL_ORGANIZATION_UNITS WHERE organization_id = p_business_group_id_to;

Line: 462

            l_dynamicSqlString := 'SELECT '||l_hr_cost_segment || ' FROM PAY_COST_ALLOCATION_KEYFLEX
                       WHERE COST_ALLOCATION_KEYFLEX_ID = :txn '  ;

Line: 495

         l_dynamicSqlString := 'SELECT '||l_hr_cost_segment || ' FROM PAY_COST_ALLOCATION_KEYFLEX
                       WHERE COST_ALLOCATION_KEYFLEX_ID = :txn '  ;

Line: 531

         /* SELECT hr.COST_ALLOCATION_KEYFLEX_ID INTO l_cost_allocation_keyflex_id
          FROM   HR_ALL_ORGANIZATION_UNITS hr ,
                 PER_ALL_ASSIGNMENTS_F asg
          WHERE hr.organization_id = asg.organization_id and
                asg.organization_id = p_organization_id and
                asg.assignment_id = p_assignment_id  ; */

Line: 538

 	    l_dynamicSqlString := 'SELECT '||l_hr_cost_segment || ' FROM PAY_COST_ALLOCATION_KEYFLEX
                       WHERE COST_ALLOCATION_KEYFLEX_ID = :txn '  ;

Line: 573

        /*  SELECT hr.COST_ALLOCATION_KEYFLEX_ID INTO l_cost_allocation_keyflex_id
          FROM   HR_ALL_ORGANIZATION_UNITS hr ,
                 OTA_EVENTS EVT
          WHERE hr.organization_id = evt.organization_id and
                evt.event_id = p_event_id; */

Line: 578

        l_dynamicSqlString := 'SELECT '||l_hr_cost_segment || ' FROM PAY_COST_ALLOCATION_KEYFLEX
                       WHERE COST_ALLOCATION_KEYFLEX_ID = :txn '  ;

Line: 761

       ,P_transaction_type          =>  'INSERT');