DBA Data[Home] [Help]

APPS.XLA_00540_AAD_S_000014_PKG dependencies on FND_LOOKUP_VALUES

Line 15524: , fnd_lookup_values fvl6

15520: ELSE null
15521: END source_meaning
15522: FROM xla_events_gt xet
15523: , OKL_CMN_EXTRACT_LINE_V l2
15524: , fnd_lookup_values fvl6
15525: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
15526: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
15527: AND xet.event_class_code = C_EVENT_CLASS_CODE
15528: AND l2.event_id = xet.event_id

Line 15661: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

15657: l_balance_type_code VARCHAR2(1) :=NULL;
15658: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
15659:
15660: --
15661: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
15662: --
15663:
15664: TYPE t_array_source_1 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TEH_CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
15665: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;

Line 15784: , fnd_lookup_values fvl6

15780: , l2.DIST_TYPE source_8
15781: , l2.DIST_ENTERED_AMOUNT source_9
15782: FROM xla_events_gt xet
15783: , OKL_CMN_EXTRACT_LINE_V l2
15784: , fnd_lookup_values fvl6
15785: WHERE xet.event_id between x_first_event_id and x_last_event_id
15786: and xet.event_date between p_pad_start_date and p_pad_end_date
15787: and xet.event_class_code = C_EVENT_CLASS_CODE
15788: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 16771: , fnd_lookup_values fvl6

16767: ELSE null
16768: END source_meaning
16769: FROM xla_events_gt xet
16770: , OKL_CMN_EXTRACT_LINE_V l2
16771: , fnd_lookup_values fvl6
16772: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
16773: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
16774: AND xet.event_class_code = C_EVENT_CLASS_CODE
16775: AND l2.event_id = xet.event_id

Line 16908: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

16904: l_balance_type_code VARCHAR2(1) :=NULL;
16905: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
16906:
16907: --
16908: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
16909: --
16910:
16911: TYPE t_array_source_1 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TEH_CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
16912: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;

Line 17027: , fnd_lookup_values fvl6

17023: , l2.DIST_TYPE source_8
17024: , l2.DIST_ENTERED_AMOUNT source_9
17025: FROM xla_events_gt xet
17026: , OKL_CMN_EXTRACT_LINE_V l2
17027: , fnd_lookup_values fvl6
17028: WHERE xet.event_id between x_first_event_id and x_last_event_id
17029: and xet.event_date between p_pad_start_date and p_pad_end_date
17030: and xet.event_class_code = C_EVENT_CLASS_CODE
17031: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 17956: , fnd_lookup_values fvl6

17952: ELSE null
17953: END source_meaning
17954: FROM xla_events_gt xet
17955: , OKL_CMN_EXTRACT_LINE_V l2
17956: , fnd_lookup_values fvl6
17957: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
17958: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
17959: AND xet.event_class_code = C_EVENT_CLASS_CODE
17960: AND l2.event_id = xet.event_id

Line 18093: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

18089: l_balance_type_code VARCHAR2(1) :=NULL;
18090: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
18091:
18092: --
18093: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
18094: --
18095:
18096: TYPE t_array_source_1 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TEH_CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
18097: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;

Line 18212: , fnd_lookup_values fvl6

18208: , l2.DIST_TYPE source_8
18209: , l2.DIST_ENTERED_AMOUNT source_9
18210: FROM xla_events_gt xet
18211: , OKL_CMN_EXTRACT_LINE_V l2
18212: , fnd_lookup_values fvl6
18213: WHERE xet.event_id between x_first_event_id and x_last_event_id
18214: and xet.event_date between p_pad_start_date and p_pad_end_date
18215: and xet.event_class_code = C_EVENT_CLASS_CODE
18216: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 19141: , fnd_lookup_values fvl6

19137: ELSE null
19138: END source_meaning
19139: FROM xla_events_gt xet
19140: , OKL_CMN_EXTRACT_LINE_V l2
19141: , fnd_lookup_values fvl6
19142: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
19143: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
19144: AND xet.event_class_code = C_EVENT_CLASS_CODE
19145: AND l2.event_id = xet.event_id

Line 19278: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

19274: l_balance_type_code VARCHAR2(1) :=NULL;
19275: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
19276:
19277: --
19278: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
19279: --
19280:
19281: TYPE t_array_source_1 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TEH_CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
19282: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;

Line 19397: , fnd_lookup_values fvl6

19393: , l2.DIST_TYPE source_8
19394: , l2.DIST_ENTERED_AMOUNT source_9
19395: FROM xla_events_gt xet
19396: , OKL_CMN_EXTRACT_LINE_V l2
19397: , fnd_lookup_values fvl6
19398: WHERE xet.event_id between x_first_event_id and x_last_event_id
19399: and xet.event_date between p_pad_start_date and p_pad_end_date
19400: and xet.event_class_code = C_EVENT_CLASS_CODE
19401: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 20326: , fnd_lookup_values fvl6

20322: ELSE null
20323: END source_meaning
20324: FROM xla_events_gt xet
20325: , OKL_CMN_EXTRACT_LINE_V l2
20326: , fnd_lookup_values fvl6
20327: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
20328: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
20329: AND xet.event_class_code = C_EVENT_CLASS_CODE
20330: AND l2.event_id = xet.event_id

Line 20463: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

20459: l_balance_type_code VARCHAR2(1) :=NULL;
20460: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
20461:
20462: --
20463: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
20464: --
20465:
20466: TYPE t_array_source_1 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TEH_CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
20467: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;

Line 20582: , fnd_lookup_values fvl6

20578: , l2.DIST_TYPE source_8
20579: , l2.DIST_ENTERED_AMOUNT source_9
20580: FROM xla_events_gt xet
20581: , OKL_CMN_EXTRACT_LINE_V l2
20582: , fnd_lookup_values fvl6
20583: WHERE xet.event_id between x_first_event_id and x_last_event_id
20584: and xet.event_date between p_pad_start_date and p_pad_end_date
20585: and xet.event_class_code = C_EVENT_CLASS_CODE
20586: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 21511: , fnd_lookup_values fvl6

21507: ELSE null
21508: END source_meaning
21509: FROM xla_events_gt xet
21510: , OKL_CMN_EXTRACT_LINE_V l1
21511: , fnd_lookup_values fvl6
21512: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
21513: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
21514: AND xet.event_class_code = C_EVENT_CLASS_CODE
21515: AND l1.event_id = xet.event_id

Line 21648: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

21644: l_balance_type_code VARCHAR2(1) :=NULL;
21645: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
21646:
21647: --
21648: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
21649: --
21650:
21651: TYPE t_array_source_3 IS TABLE OF OKL_IA_EXTRACT_HDR_V.TEH_INV_AGRMNT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
21652: TYPE t_array_source_4 IS TABLE OF OKL_IA_EXTRACT_HDR_V.TCN_INV_AGRMNT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;

Line 21767: , fnd_lookup_values fvl6

21763: , l1.DIST_TYPE source_8
21764: , l1.DIST_ENTERED_AMOUNT source_9
21765: FROM xla_events_gt xet
21766: , OKL_CMN_EXTRACT_LINE_V l1
21767: , fnd_lookup_values fvl6
21768: WHERE xet.event_id between x_first_event_id and x_last_event_id
21769: and xet.event_date between p_pad_start_date and p_pad_end_date
21770: and xet.event_class_code = C_EVENT_CLASS_CODE
21771: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 22696: , fnd_lookup_values fvl6

22692: ELSE null
22693: END source_meaning
22694: FROM xla_events_gt xet
22695: , OKL_CMN_EXTRACT_LINE_V l2
22696: , fnd_lookup_values fvl6
22697: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
22698: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
22699: AND xet.event_class_code = C_EVENT_CLASS_CODE
22700: AND l2.event_id = xet.event_id

Line 22833: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

22829: l_balance_type_code VARCHAR2(1) :=NULL;
22830: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
22831:
22832: --
22833: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
22834: --
22835:
22836: TYPE t_array_source_1 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TEH_CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
22837: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;

Line 22952: , fnd_lookup_values fvl6

22948: , l2.DIST_TYPE source_8
22949: , l2.DIST_ENTERED_AMOUNT source_9
22950: FROM xla_events_gt xet
22951: , OKL_CMN_EXTRACT_LINE_V l2
22952: , fnd_lookup_values fvl6
22953: WHERE xet.event_id between x_first_event_id and x_last_event_id
22954: and xet.event_date between p_pad_start_date and p_pad_end_date
22955: and xet.event_class_code = C_EVENT_CLASS_CODE
22956: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 23881: , fnd_lookup_values fvl6

23877: ELSE null
23878: END source_meaning
23879: FROM xla_events_gt xet
23880: , OKL_CMN_EXTRACT_LINE_V l2
23881: , fnd_lookup_values fvl6
23882: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
23883: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
23884: AND xet.event_class_code = C_EVENT_CLASS_CODE
23885: AND l2.event_id = xet.event_id

Line 24018: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

24014: l_balance_type_code VARCHAR2(1) :=NULL;
24015: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
24016:
24017: --
24018: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
24019: --
24020:
24021: TYPE t_array_source_1 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TEH_CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
24022: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;

Line 24137: , fnd_lookup_values fvl6

24133: , l2.DIST_TYPE source_8
24134: , l2.DIST_ENTERED_AMOUNT source_9
24135: FROM xla_events_gt xet
24136: , OKL_CMN_EXTRACT_LINE_V l2
24137: , fnd_lookup_values fvl6
24138: WHERE xet.event_id between x_first_event_id and x_last_event_id
24139: and xet.event_date between p_pad_start_date and p_pad_end_date
24140: and xet.event_class_code = C_EVENT_CLASS_CODE
24141: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 25066: , fnd_lookup_values fvl6

25062: ELSE null
25063: END source_meaning
25064: FROM xla_events_gt xet
25065: , OKL_CMN_EXTRACT_LINE_V l2
25066: , fnd_lookup_values fvl6
25067: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
25068: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
25069: AND xet.event_class_code = C_EVENT_CLASS_CODE
25070: AND l2.event_id = xet.event_id

Line 25203: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

25199: l_balance_type_code VARCHAR2(1) :=NULL;
25200: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
25201:
25202: --
25203: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
25204: --
25205:
25206: TYPE t_array_source_1 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TEH_CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
25207: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;

Line 25322: , fnd_lookup_values fvl6

25318: , l2.DIST_TYPE source_8
25319: , l2.DIST_ENTERED_AMOUNT source_9
25320: FROM xla_events_gt xet
25321: , OKL_CMN_EXTRACT_LINE_V l2
25322: , fnd_lookup_values fvl6
25323: WHERE xet.event_id between x_first_event_id and x_last_event_id
25324: and xet.event_date between p_pad_start_date and p_pad_end_date
25325: and xet.event_class_code = C_EVENT_CLASS_CODE
25326: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 26251: , fnd_lookup_values fvl6

26247: ELSE null
26248: END source_meaning
26249: FROM xla_events_gt xet
26250: , OKL_CMN_EXTRACT_LINE_V l2
26251: , fnd_lookup_values fvl6
26252: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
26253: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
26254: AND xet.event_class_code = C_EVENT_CLASS_CODE
26255: AND l2.event_id = xet.event_id

Line 26388: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

26384: l_balance_type_code VARCHAR2(1) :=NULL;
26385: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
26386:
26387: --
26388: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
26389: --
26390:
26391: TYPE t_array_source_1 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TEH_CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
26392: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;

Line 26507: , fnd_lookup_values fvl6

26503: , l2.DIST_TYPE source_8
26504: , l2.DIST_ENTERED_AMOUNT source_9
26505: FROM xla_events_gt xet
26506: , OKL_CMN_EXTRACT_LINE_V l2
26507: , fnd_lookup_values fvl6
26508: WHERE xet.event_id between x_first_event_id and x_last_event_id
26509: and xet.event_date between p_pad_start_date and p_pad_end_date
26510: and xet.event_class_code = C_EVENT_CLASS_CODE
26511: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 27436: , fnd_lookup_values fvl6

27432: ELSE null
27433: END source_meaning
27434: FROM xla_events_gt xet
27435: , OKL_CMN_EXTRACT_LINE_V l2
27436: , fnd_lookup_values fvl6
27437: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
27438: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
27439: AND xet.event_class_code = C_EVENT_CLASS_CODE
27440: AND l2.event_id = xet.event_id

Line 27573: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

27569: l_balance_type_code VARCHAR2(1) :=NULL;
27570: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
27571:
27572: --
27573: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
27574: --
27575:
27576: TYPE t_array_source_1 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TEH_CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
27577: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;

Line 27692: , fnd_lookup_values fvl6

27688: , l2.DIST_TYPE source_8
27689: , l2.DIST_ENTERED_AMOUNT source_9
27690: FROM xla_events_gt xet
27691: , OKL_CMN_EXTRACT_LINE_V l2
27692: , fnd_lookup_values fvl6
27693: WHERE xet.event_id between x_first_event_id and x_last_event_id
27694: and xet.event_date between p_pad_start_date and p_pad_end_date
27695: and xet.event_class_code = C_EVENT_CLASS_CODE
27696: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 28616: , fnd_lookup_values fvl6

28612: ELSE null
28613: END source_meaning
28614: FROM xla_events_gt xet
28615: , OKL_CMN_EXTRACT_LINE_V l2
28616: , fnd_lookup_values fvl6
28617: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
28618: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
28619: AND xet.event_class_code = C_EVENT_CLASS_CODE
28620: AND l2.event_id = xet.event_id

Line 28753: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

28749: l_balance_type_code VARCHAR2(1) :=NULL;
28750: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
28751:
28752: --
28753: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
28754: --
28755:
28756: TYPE t_array_source_1 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TEH_CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
28757: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;

Line 28869: , fnd_lookup_values fvl6

28865: , l2.DIST_TYPE source_8
28866: , l2.DIST_ENTERED_AMOUNT source_9
28867: FROM xla_events_gt xet
28868: , OKL_CMN_EXTRACT_LINE_V l2
28869: , fnd_lookup_values fvl6
28870: WHERE xet.event_id between x_first_event_id and x_last_event_id
28871: and xet.event_date between p_pad_start_date and p_pad_end_date
28872: and xet.event_class_code = C_EVENT_CLASS_CODE
28873: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 29784: , fnd_lookup_values fvl6

29780: ELSE null
29781: END source_meaning
29782: FROM xla_events_gt xet
29783: , OKL_CMN_EXTRACT_LINE_V l2
29784: , fnd_lookup_values fvl6
29785: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
29786: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
29787: AND xet.event_class_code = C_EVENT_CLASS_CODE
29788: AND l2.event_id = xet.event_id

Line 29921: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

29917: l_balance_type_code VARCHAR2(1) :=NULL;
29918: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
29919:
29920: --
29921: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
29922: --
29923:
29924: TYPE t_array_source_1 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TEH_CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
29925: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;

Line 30040: , fnd_lookup_values fvl6

30036: , l2.DIST_TYPE source_8
30037: , l2.DIST_ENTERED_AMOUNT source_9
30038: FROM xla_events_gt xet
30039: , OKL_CMN_EXTRACT_LINE_V l2
30040: , fnd_lookup_values fvl6
30041: WHERE xet.event_id between x_first_event_id and x_last_event_id
30042: and xet.event_date between p_pad_start_date and p_pad_end_date
30043: and xet.event_class_code = C_EVENT_CLASS_CODE
30044: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 30969: , fnd_lookup_values fvl6

30965: ELSE null
30966: END source_meaning
30967: FROM xla_events_gt xet
30968: , OKL_CMN_EXTRACT_LINE_V l2
30969: , fnd_lookup_values fvl6
30970: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
30971: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
30972: AND xet.event_class_code = C_EVENT_CLASS_CODE
30973: AND l2.event_id = xet.event_id

Line 31106: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

31102: l_balance_type_code VARCHAR2(1) :=NULL;
31103: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
31104:
31105: --
31106: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
31107: --
31108:
31109: TYPE t_array_source_1 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TEH_CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
31110: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;

Line 31225: , fnd_lookup_values fvl6

31221: , l2.DIST_TYPE source_8
31222: , l2.DIST_ENTERED_AMOUNT source_9
31223: FROM xla_events_gt xet
31224: , OKL_CMN_EXTRACT_LINE_V l2
31225: , fnd_lookup_values fvl6
31226: WHERE xet.event_id between x_first_event_id and x_last_event_id
31227: and xet.event_date between p_pad_start_date and p_pad_end_date
31228: and xet.event_class_code = C_EVENT_CLASS_CODE
31229: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id