APPS.OKS_IMPORT_POST_INSERT dependencies on OKS_LEVEL_ELEMENTS

Line 282: INTO OKS_LEVEL_ELEMENTS

278: l_stmt_num :=30 ;
279:
280: INSERT ALL
281: WHEN (FREQUENCY IS NOT NULL ) then
282: INTO OKS_LEVEL_ELEMENTS
283: (ID
284: ,SEQUENCE_NUMBER
285: ,DATE_START
286: ,AMOUNT

Line 710: INTO OKS_LEVEL_ELEMENTS

706: -- this query inserts records into level elements as schedules for billing streams for Usage Counters
707:
708: INSERT ALL
709: WHEN (FREQUENCY IS NOT NULL ) then
710: INTO OKS_LEVEL_ELEMENTS
711: (ID
712: ,SEQUENCE_NUMBER
713: ,DATE_START
714: ,AMOUNT

Line 1072: INTO OKS_LEVEL_ELEMENTS

1068: l_stmt_num :=50;
1069:
1070: INSERT ALL
1071: WHEN (FREQUENCY IS NOT NULL ) then
1072: INTO OKS_LEVEL_ELEMENTS
1073: (ID
1074: ,SEQUENCE_NUMBER
1075: ,DATE_START
1076: ,AMOUNT

Line 1498: INTO OKS_LEVEL_ELEMENTS

1494: -- this query inserts records into level elements as schedules for billing streams for sublines
1495:
1496: INSERT ALL
1497: WHEN (FREQUENCY IS NOT NULL ) then
1498: INTO OKS_LEVEL_ELEMENTS
1499: (ID
1500: ,SEQUENCE_NUMBER
1501: ,DATE_START
1502: ,AMOUNT

Line 1871: INTO OKS_LEVEL_ELEMENTS

1867:
1868: --This query creates billing schedules from streams for lines
1869: INSERT ALL
1870: WHEN (FREQUENCY IS NOT NULL ) then
1871: INTO OKS_LEVEL_ELEMENTS
1872: (ID
1873: ,SEQUENCE_NUMBER
1874: ,DATE_START
1875: ,AMOUNT

Line 1929: FROM OKS_LEVEL_ELEMENTS COV_LVL_ELEM

1925: ,(CASE WHEN LIN_SCH_DT.INVOICING_RULE_ID = -2 THEN LIN_SCH_DT.DATE_START
1926: WHEN LIN_SCH_DT.INVOICING_RULE_ID = -3 THEN LIN_SCH_DT.DATE_END +1
1927: END) DATE_TO_INTERFACE
1928:
1929: FROM OKS_LEVEL_ELEMENTS COV_LVL_ELEM
1930: ,(SELECT INNER_Q2.SEQ SEQUENCE_NUMBER
1931: ,(CASE WHEN INNER_Q2.SEQ=1 THEN INNER_Q1.STRM_START_DATE
1932: -- IN OTHER CASES
1933: ELSE DECODE (INNER_Q1.BILLING_INTERVAL_PERIOD