APPS.OKS_IMPORT_POST_INSERT dependencies on DUAL

Line 262: ,(SELECT ROWNUM AS SEQ FROM DUAL CONNECT BY LEVEL <= 3) INNER_Q2

258: AND OKCLINB_LINE.CHR_ID = OKCHDRB.ID
259: AND OKCLINB_LINE.LINE_NUMBER = OLSTG.LINE_NUMBER
260: AND OLSTG.LINE_TYPE='SUBSCRIPTION' ) INNER_Q1
261:
262: ,(SELECT ROWNUM AS SEQ FROM DUAL CONNECT BY LEVEL <= 3) INNER_Q2
263: WHERE INNER_Q2.SEQ <= INNER_Q1.NUM_STREAMS;
264:
265: /* IF G_STMT_LOG THEN
266:

Line 450: ,(SELECT ROWNUM AS SEQ FROM DUAL CONNECT BY LEVEL <= l_recur_bill_occurance ) INNER_Q2

446: AND OKCLINB_LINE.LINE_NUMBER = OLSTG.LINE_NUMBER
447: AND OKS_STRM_LVL.CLE_ID = OKCLINB_LINE.ID
448: AND OLSTG.LINE_TYPE='SUBSCRIPTION') INNER_Q1
449:
450: ,(SELECT ROWNUM AS SEQ FROM DUAL CONNECT BY LEVEL <= l_recur_bill_occurance ) INNER_Q2
451:
452: WHERE INNER_Q2.SEQ <= INNER_Q1.LEVEL_PERIODS)SUBS_SCH_DT;
453:
454: /*IF G_STMT_LOG THEN

Line 680: ,(SELECT ROWNUM AS SEQ FROM DUAL CONNECT BY LEVEL <= 3) INNER_Q2

676: AND OKCLINB_SUBLINE.CLE_ID = OKCLINB_LINE.ID
677: AND OKCLINB_SUBLINE.LINE_NUMBER = INNER_1.LINE_NUMBER
678: AND OLSTG.LINE_TYPE = 'USAGE') INNER_Q1
679:
680: ,(SELECT ROWNUM AS SEQ FROM DUAL CONNECT BY LEVEL <= 3) INNER_Q2
681:
682: WHERE INNER_Q2.SEQ <= INNER_Q1.NUM_STREAMS;
683:
684: l_int_count := SQL%ROWCOUNT;

Line 894: ,(SELECT ROWNUM AS SEQ FROM DUAL CONNECT BY LEVEL <= l_recur_bill_occurance ) INNER_Q2

890: AND OKS_STRM_LVL.CLE_ID = OKCLINB_SUBLINE.ID
891: AND OKS_STRM_LVL.CHR_ID IS NULL
892: AND OLSTG.LINE_TYPE = 'USAGE') INNER_Q1
893:
894: ,(SELECT ROWNUM AS SEQ FROM DUAL CONNECT BY LEVEL <= l_recur_bill_occurance ) INNER_Q2
895:
896: WHERE INNER_Q2.SEQ <= INNER_Q1.LEVEL_PERIODS) COV_SCH_DT;
897:
898:

Line 1056: ,(SELECT ROWNUM AS SEQ FROM DUAL CONNECT BY LEVEL <= 3) INNER_Q2

1052: AND OKCLINB_LINE.DNZ_CHR_ID = OKCHDRB.ID
1053: AND OKCLINB_LINE.CHR_ID = OKCHDRB.ID
1054: AND OKCLINB_LINE.LINE_NUMBER = OLSTG.LINE_NUMBER
1055: AND OLSTG.LINE_TYPE ='USAGE') INNER_Q1
1056: ,(SELECT ROWNUM AS SEQ FROM DUAL CONNECT BY LEVEL <= 3) INNER_Q2
1057: WHERE INNER_Q2.SEQ <= INNER_Q1.NUM_STREAMS;
1058:
1059: /* l_int_count := SQL%ROWCOUNT;
1060: IF G_STMT_LOG THEN

Line 1236: ,(SELECT ROWNUM AS SEQ FROM DUAL CONNECT BY LEVEL <= l_recur_bill_occurance ) INNER_Q2

1232: AND OKS_STRM_LVL.DNZ_CHR_ID = OKCHDRB.ID
1233: AND OKCLINB_LINE.LINE_NUMBER = OLSTG.LINE_NUMBER
1234: AND OKS_STRM_LVL.CLE_ID = OKCLINB_LINE.ID
1235: AND OLSTG.LINE_TYPE='USAGE' ) INNER_Q1
1236: ,(SELECT ROWNUM AS SEQ FROM DUAL CONNECT BY LEVEL <= l_recur_bill_occurance ) INNER_Q2
1237: WHERE INNER_Q2.SEQ <= INNER_Q1.LEVEL_PERIODS)USG_SCH_DT;
1238:
1239:
1240: /*IF G_STMT_LOG THEN

Line 1468: ,(SELECT ROWNUM AS SEQ FROM DUAL CONNECT BY LEVEL <= 3) INNER_Q2

1464: AND OKCLINB_SUBLINE.CLE_ID = OKCLINB_LINE.ID
1465: AND OKCLINB_SUBLINE.LINE_NUMBER = INNER_1.LINE_NUMBER
1466: AND OLSTG.LINE_TYPE NOT IN ('SUBSCRIPTION','USAGE')) INNER_Q1
1467:
1468: ,(SELECT ROWNUM AS SEQ FROM DUAL CONNECT BY LEVEL <= 3) INNER_Q2
1469:
1470: WHERE INNER_Q2.SEQ <= INNER_Q1.NUM_STREAMS;
1471:
1472: l_int_count := SQL%ROWCOUNT;

Line 1684: ,(SELECT ROWNUM AS SEQ FROM DUAL CONNECT BY LEVEL <= l_recur_bill_occurance ) INNER_Q2

1680: AND OKS_STRM_LVL.CLE_ID = OKCLINB_SUBLINE.ID
1681: AND OKS_STRM_LVL.CHR_ID IS NULL
1682: AND OLSTG.LINE_TYPE NOT IN ('SUBSCRIPTION','USAGE')) INNER_Q1
1683:
1684: ,(SELECT ROWNUM AS SEQ FROM DUAL CONNECT BY LEVEL <= l_recur_bill_occurance ) INNER_Q2
1685:
1686: WHERE INNER_Q2.SEQ <= INNER_Q1.LEVEL_PERIODS) COV_SCH_DT;
1687:
1688: -- Billing Streams and Schedules for Service Lines

Line 1853: ,(SELECT ROWNUM AS SEQ FROM DUAL CONNECT BY LEVEL <= 3) INNER_Q2

1849: AND OKCLINB_LINE.CHR_ID = OKCHDRB.ID
1850: AND OKCLINB_LINE.LINE_NUMBER = OLSTG.LINE_NUMBER
1851: AND OLSTG.LINE_TYPE NOT IN ('SUBSCRIPTION', 'USAGE'))INNER_Q1
1852:
1853: ,(SELECT ROWNUM AS SEQ FROM DUAL CONNECT BY LEVEL <= 3) INNER_Q2
1854:
1855: WHERE INNER_Q2.SEQ <= INNER_Q1.NUM_STREAMS;
1856:
1857: l_int_count := SQL%ROWCOUNT;

Line 2011: ,(SELECT ROWNUM AS SEQ FROM DUAL CONNECT BY LEVEL <= l_recur_bill_occurance ) INNER_Q2

2007: AND OKS_STRM_LVL.DNZ_CHR_ID = OKCHDRB.ID
2008: AND OKCLINB_LINE.LINE_NUMBER = OLSTG.LINE_NUMBER
2009: AND OKS_STRM_LVL.CLE_ID = OKCLINB_LINE.ID
2010: AND OLSTG.LINE_TYPE NOT IN ('SUBSCRIPTION', 'USAGE')) INNER_Q1
2011: ,(SELECT ROWNUM AS SEQ FROM DUAL CONNECT BY LEVEL <= l_recur_bill_occurance ) INNER_Q2
2012: WHERE INNER_Q2.SEQ <= INNER_Q1.LEVEL_PERIODS) LIN_SCH_DT
2013: WHERE COV_LVL_ELEM.PARENT_CLE_ID = LIN_SCH_DT.CLE_ID
2014: AND COV_LVL_ELEM.DATE_START(+) >= LIN_SCH_DT.DATE_START
2015: AND COV_LVL_ELEM.DATE_END(+) <= LIN_SCH_DT.DATE_END ) SCH_LIN_INSERT;