APPS.OKS_IMPORT_POST_INSERT dependencies on OKS_LEVEL_ELEMENTS

Line 308: INTO OKS_LEVEL_ELEMENTS

304: l_stmt_num :=30 ;
305:
306: INSERT ALL
307: WHEN (FREQUENCY IS NOT NULL ) then
308: INTO OKS_LEVEL_ELEMENTS
309: (ID
310: ,SEQUENCE_NUMBER
311: ,DATE_START
312: ,AMOUNT

Line 834: INTO OKS_LEVEL_ELEMENTS

830: -- this query inserts records into level elements as schedules for billing streams for Usage Counters
831:
832: INSERT ALL
833: WHEN (FREQUENCY IS NOT NULL ) then
834: INTO OKS_LEVEL_ELEMENTS
835: (ID
836: ,SEQUENCE_NUMBER
837: ,DATE_START
838: ,AMOUNT

Line 1269: INTO OKS_LEVEL_ELEMENTS

1265: l_stmt_num :=50;
1266:
1267: INSERT ALL
1268: WHEN (FREQUENCY IS NOT NULL ) then
1269: INTO OKS_LEVEL_ELEMENTS
1270: (ID
1271: ,SEQUENCE_NUMBER
1272: ,DATE_START
1273: ,AMOUNT

Line 1768: INTO OKS_LEVEL_ELEMENTS

1764: -- this query inserts records into level elements as schedules for billing streams for sublines
1765:
1766: INSERT ALL
1767: WHEN (FREQUENCY IS NOT NULL ) then
1768: INTO OKS_LEVEL_ELEMENTS
1769: (ID
1770: ,SEQUENCE_NUMBER
1771: ,DATE_START
1772: ,AMOUNT

Line 2215: INTO OKS_LEVEL_ELEMENTS

2211:
2212: --This query creates billing schedules from streams for lines
2213: INSERT ALL
2214: WHEN (FREQUENCY IS NOT NULL ) then
2215: INTO OKS_LEVEL_ELEMENTS
2216: (ID
2217: ,SEQUENCE_NUMBER
2218: ,DATE_START
2219: ,AMOUNT

Line 2273: FROM OKS_LEVEL_ELEMENTS COV_LVL_ELEM

2269: ,(CASE WHEN LIN_SCH_DT.INVOICING_RULE_ID = -2 THEN LIN_SCH_DT.DATE_START
2270: WHEN LIN_SCH_DT.INVOICING_RULE_ID = -3 THEN LIN_SCH_DT.DATE_END +1
2271: END) DATE_TO_INTERFACE
2272:
2273: FROM OKS_LEVEL_ELEMENTS COV_LVL_ELEM
2274: ,(SELECT INNER_Q2.SEQ SEQUENCE_NUMBER
2275: ,(CASE WHEN INNER_Q2.SEQ=1 THEN INNER_Q1.STRM_START_DATE
2276: -- IN OTHER CASES
2277: ELSE /* DECODE (INNER_Q1.BILLING_INTERVAL_PERIOD