DBA Data[Home] [Help]

APPS.XLA_00275_AAD_S_000015_PKG dependencies on FND_LOOKUP_VALUES

Line 74079: , fnd_lookup_values fvl73

74075: ELSE null
74076: END source_meaning
74077: FROM xla_events_gt xet
74078: , PA_XLA_EXP_HEADER_V h2
74079: , fnd_lookup_values fvl73
74080: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
74081: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
74082: AND xet.event_class_code = C_EVENT_CLASS_CODE
74083: AND h2.event_id = xet.event_id

Line 74277: , fnd_lookup_values fvl35

74273: ELSE null
74274: END source_meaning
74275: FROM xla_events_gt xet
74276: , PA_XLA_CCDL_LINES_V l1
74277: , fnd_lookup_values fvl35
74278: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
74279: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
74280: AND xet.event_class_code = C_EVENT_CLASS_CODE
74281: AND l1.event_id = xet.event_id

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

74410: l_balance_type_code VARCHAR2(1) :=NULL;
74411: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
74412:
74413: --
74414: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
74415: --
74416:
74417: TYPE t_array_source_33 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
74418: TYPE t_array_source_73 IS TABLE OF PA_XLA_EXP_HEADER_V.TP_AMT_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 74500: , fnd_lookup_values fvl73

74496: , fvl73.meaning source_73_meaning
74497: , h2.GL_DATE source_75
74498: FROM xla_events_gt xet
74499: , PA_XLA_EXP_HEADER_V h2
74500: , fnd_lookup_values fvl73
74501: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
74502: and xet.event_class_code = C_EVENT_CLASS_CODE
74503: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
74504: AND fvl73.lookup_type(+) = 'TP_AMOUNT_TYPE'

Line 74564: , fnd_lookup_values fvl35

74560: , l1.ENTERED_AMOUNT source_42
74561: , l1.ACCT_AMOUNT source_43
74562: FROM xla_events_gt xet
74563: , PA_XLA_CCDL_LINES_V l1
74564: , fnd_lookup_values fvl35
74565: WHERE xet.event_id between x_first_event_id and x_last_event_id
74566: and xet.event_date between p_pad_start_date and p_pad_end_date
74567: and xet.event_class_code = C_EVENT_CLASS_CODE
74568: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 75487: , fnd_lookup_values fvl73

75483: ELSE null
75484: END source_meaning
75485: FROM xla_events_gt xet
75486: , PA_XLA_EXP_HEADER_V h2
75487: , fnd_lookup_values fvl73
75488: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
75489: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
75490: AND xet.event_class_code = C_EVENT_CLASS_CODE
75491: AND h2.event_id = xet.event_id

Line 75685: , fnd_lookup_values fvl35

75681: ELSE null
75682: END source_meaning
75683: FROM xla_events_gt xet
75684: , PA_XLA_CCDL_LINES_V l1
75685: , fnd_lookup_values fvl35
75686: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
75687: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
75688: AND xet.event_class_code = C_EVENT_CLASS_CODE
75689: AND l1.event_id = xet.event_id

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

75818: l_balance_type_code VARCHAR2(1) :=NULL;
75819: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
75820:
75821: --
75822: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
75823: --
75824:
75825: TYPE t_array_source_33 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
75826: TYPE t_array_source_73 IS TABLE OF PA_XLA_EXP_HEADER_V.TP_AMT_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 75908: , fnd_lookup_values fvl73

75904: , fvl73.meaning source_73_meaning
75905: , h2.GL_DATE source_75
75906: FROM xla_events_gt xet
75907: , PA_XLA_EXP_HEADER_V h2
75908: , fnd_lookup_values fvl73
75909: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
75910: and xet.event_class_code = C_EVENT_CLASS_CODE
75911: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
75912: AND fvl73.lookup_type(+) = 'TP_AMOUNT_TYPE'

Line 75972: , fnd_lookup_values fvl35

75968: , l1.ENTERED_AMOUNT source_42
75969: , l1.ACCT_AMOUNT source_43
75970: FROM xla_events_gt xet
75971: , PA_XLA_CCDL_LINES_V l1
75972: , fnd_lookup_values fvl35
75973: WHERE xet.event_id between x_first_event_id and x_last_event_id
75974: and xet.event_date between p_pad_start_date and p_pad_end_date
75975: and xet.event_class_code = C_EVENT_CLASS_CODE
75976: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 76906: , fnd_lookup_values fvl38

76902: END source_meaning
76903: FROM xla_events_gt xet
76904: , PA_XLA_BC_BUDGET_HEADER_V h1
76905: , PA_XLA_PROJECT_REF_V h3
76906: , fnd_lookup_values fvl38
76907: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
76908: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
76909: AND xet.event_class_code = C_EVENT_CLASS_CODE
76910: AND h1.event_id = xet.event_id

Line 77073: , fnd_lookup_values fvl35

77069: ELSE null
77070: END source_meaning
77071: FROM xla_events_gt xet
77072: , PA_XLA_BC_BUDGET_LINES_V l2
77073: , fnd_lookup_values fvl35
77074: , (select rownum r from all_objects where rownum <= 13 and owner = p_apps_owner)
77075: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
77076: AND xet.event_class_code = C_EVENT_CLASS_CODE
77077: AND l2.event_id = xet.event_id

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

77206: l_balance_type_code VARCHAR2(1) :=NULL;
77207: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
77208:
77209: --
77210: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
77211: --
77212:
77213: TYPE t_array_source_37 IS TABLE OF PA_XLA_BC_BUDGET_HEADER_V.BUDGET_AMOUNT_CODE%TYPE INDEX BY BINARY_INTEGER;
77214: TYPE t_array_source_38 IS TABLE OF PA_XLA_PROJECT_REF_V.PROJECT_TYPE_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 77293: , fnd_lookup_values fvl38

77289: , h1.GL_BUDGET_VERSION_ID source_76
77290: FROM xla_events_gt xet
77291: , PA_XLA_BC_BUDGET_HEADER_V h1
77292: , PA_XLA_PROJECT_REF_V h3
77293: , fnd_lookup_values fvl38
77294: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
77295: and xet.event_class_code = C_EVENT_CLASS_CODE
77296: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
77297: AND h3.PROJECT_ID=h1.PROJECT_ID AND fvl38.lookup_type(+) = 'PROJECT TYPE CLASS'

Line 77352: , fnd_lookup_values fvl35

77348: , l2.USE_ENC_UPG_ATTRIB_FLAG source_44
77349: , l2.ENC_UPG_ENC_TYPE_ID source_45
77350: FROM xla_events_gt xet
77351: , PA_XLA_BC_BUDGET_LINES_V l2
77352: , fnd_lookup_values fvl35
77353: WHERE xet.event_id between x_first_event_id and x_last_event_id
77354: and xet.event_date between p_pad_start_date and p_pad_end_date
77355: and xet.event_class_code = C_EVENT_CLASS_CODE
77356: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 78481: , fnd_lookup_values fvl35

78477: ELSE null
78478: END source_meaning
78479: FROM xla_events_gt xet
78480: , PA_XLA_CDL_LINES_V l1
78481: , fnd_lookup_values fvl35
78482: , (select rownum r from all_objects where rownum <= 31 and owner = p_apps_owner)
78483: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
78484: AND xet.event_class_code = C_EVENT_CLASS_CODE
78485: AND l1.event_id = xet.event_id

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

78614: l_balance_type_code VARCHAR2(1) :=NULL;
78615: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
78616:
78617: --
78618: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
78619: --
78620:
78621: TYPE t_array_source_33 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
78622: TYPE t_array_source_75 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 78797: , fnd_lookup_values fvl35

78793: , l1.ENCUMBRANCE_TYPE_ID source_62
78794: , l1.PROJ_ENCUMBRANCE_TYPE_ID source_63
78795: FROM xla_events_gt xet
78796: , PA_XLA_CDL_LINES_V l1
78797: , fnd_lookup_values fvl35
78798: WHERE xet.event_id between x_first_event_id and x_last_event_id
78799: and xet.event_date between p_pad_start_date and p_pad_end_date
78800: and xet.event_class_code = C_EVENT_CLASS_CODE
78801: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 80048: , fnd_lookup_values fvl35

80044: ELSE null
80045: END source_meaning
80046: FROM xla_events_gt xet
80047: , PA_XLA_CDL_LINES_V l1
80048: , fnd_lookup_values fvl35
80049: , (select rownum r from all_objects where rownum <= 31 and owner = p_apps_owner)
80050: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
80051: AND xet.event_class_code = C_EVENT_CLASS_CODE
80052: AND l1.event_id = xet.event_id

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

80181: l_balance_type_code VARCHAR2(1) :=NULL;
80182: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
80183:
80184: --
80185: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
80186: --
80187:
80188: TYPE t_array_source_33 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
80189: TYPE t_array_source_75 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 80364: , fnd_lookup_values fvl35

80360: , l1.ENCUMBRANCE_TYPE_ID source_62
80361: , l1.PROJ_ENCUMBRANCE_TYPE_ID source_63
80362: FROM xla_events_gt xet
80363: , PA_XLA_CDL_LINES_V l1
80364: , fnd_lookup_values fvl35
80365: WHERE xet.event_id between x_first_event_id and x_last_event_id
80366: and xet.event_date between p_pad_start_date and p_pad_end_date
80367: and xet.event_class_code = C_EVENT_CLASS_CODE
80368: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 81550: , fnd_lookup_values fvl35

81546: ELSE null
81547: END source_meaning
81548: FROM xla_events_gt xet
81549: , PA_XLA_CDL_LINES_V l1
81550: , fnd_lookup_values fvl35
81551: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
81552: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
81553: AND xet.event_class_code = C_EVENT_CLASS_CODE
81554: AND l1.event_id = xet.event_id

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

81683: l_balance_type_code VARCHAR2(1) :=NULL;
81684: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
81685:
81686: --
81687: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
81688: --
81689:
81690: TYPE t_array_source_33 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
81691: TYPE t_array_source_75 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 81827: , fnd_lookup_values fvl35

81823: , fvl35.meaning source_35_meaning
81824: , l1.LINE_NUM_REVERSED source_36
81825: FROM xla_events_gt xet
81826: , PA_XLA_CDL_LINES_V l1
81827: , fnd_lookup_values fvl35
81828: WHERE xet.event_id between x_first_event_id and x_last_event_id
81829: and xet.event_date between p_pad_start_date and p_pad_end_date
81830: and xet.event_class_code = C_EVENT_CLASS_CODE
81831: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 82922: , fnd_lookup_values fvl35

82918: ELSE null
82919: END source_meaning
82920: FROM xla_events_gt xet
82921: , PA_XLA_CDL_LINES_V l1
82922: , fnd_lookup_values fvl35
82923: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
82924: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
82925: AND xet.event_class_code = C_EVENT_CLASS_CODE
82926: AND l1.event_id = xet.event_id

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

83055: l_balance_type_code VARCHAR2(1) :=NULL;
83056: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
83057:
83058: --
83059: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
83060: --
83061:
83062: TYPE t_array_source_33 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
83063: TYPE t_array_source_75 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 83199: , fnd_lookup_values fvl35

83195: , fvl35.meaning source_35_meaning
83196: , l1.LINE_NUM_REVERSED source_36
83197: FROM xla_events_gt xet
83198: , PA_XLA_CDL_LINES_V l1
83199: , fnd_lookup_values fvl35
83200: WHERE xet.event_id between x_first_event_id and x_last_event_id
83201: and xet.event_date between p_pad_start_date and p_pad_end_date
83202: and xet.event_class_code = C_EVENT_CLASS_CODE
83203: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 84294: , fnd_lookup_values fvl35

84290: ELSE null
84291: END source_meaning
84292: FROM xla_events_gt xet
84293: , PA_XLA_CDL_LINES_V l1
84294: , fnd_lookup_values fvl35
84295: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
84296: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
84297: AND xet.event_class_code = C_EVENT_CLASS_CODE
84298: AND l1.event_id = xet.event_id

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

84427: l_balance_type_code VARCHAR2(1) :=NULL;
84428: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
84429:
84430: --
84431: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
84432: --
84433:
84434: TYPE t_array_source_33 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
84435: TYPE t_array_source_75 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 84571: , fnd_lookup_values fvl35

84567: , fvl35.meaning source_35_meaning
84568: , l1.LINE_NUM_REVERSED source_36
84569: FROM xla_events_gt xet
84570: , PA_XLA_CDL_LINES_V l1
84571: , fnd_lookup_values fvl35
84572: WHERE xet.event_id between x_first_event_id and x_last_event_id
84573: and xet.event_date between p_pad_start_date and p_pad_end_date
84574: and xet.event_class_code = C_EVENT_CLASS_CODE
84575: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 85666: , fnd_lookup_values fvl35

85662: ELSE null
85663: END source_meaning
85664: FROM xla_events_gt xet
85665: , PA_XLA_CDL_LINES_V l1
85666: , fnd_lookup_values fvl35
85667: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
85668: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
85669: AND xet.event_class_code = C_EVENT_CLASS_CODE
85670: AND l1.event_id = xet.event_id

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

85799: l_balance_type_code VARCHAR2(1) :=NULL;
85800: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
85801:
85802: --
85803: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
85804: --
85805:
85806: TYPE t_array_source_33 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
85807: TYPE t_array_source_75 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 85943: , fnd_lookup_values fvl35

85939: , fvl35.meaning source_35_meaning
85940: , l1.LINE_NUM_REVERSED source_36
85941: FROM xla_events_gt xet
85942: , PA_XLA_CDL_LINES_V l1
85943: , fnd_lookup_values fvl35
85944: WHERE xet.event_id between x_first_event_id and x_last_event_id
85945: and xet.event_date between p_pad_start_date and p_pad_end_date
85946: and xet.event_class_code = C_EVENT_CLASS_CODE
85947: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 87038: , fnd_lookup_values fvl35

87034: ELSE null
87035: END source_meaning
87036: FROM xla_events_gt xet
87037: , PA_XLA_CDL_LINES_V l1
87038: , fnd_lookup_values fvl35
87039: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
87040: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
87041: AND xet.event_class_code = C_EVENT_CLASS_CODE
87042: AND l1.event_id = xet.event_id

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

87171: l_balance_type_code VARCHAR2(1) :=NULL;
87172: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
87173:
87174: --
87175: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
87176: --
87177:
87178: TYPE t_array_source_33 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
87179: TYPE t_array_source_75 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 87315: , fnd_lookup_values fvl35

87311: , fvl35.meaning source_35_meaning
87312: , l1.LINE_NUM_REVERSED source_36
87313: FROM xla_events_gt xet
87314: , PA_XLA_CDL_LINES_V l1
87315: , fnd_lookup_values fvl35
87316: WHERE xet.event_id between x_first_event_id and x_last_event_id
87317: and xet.event_date between p_pad_start_date and p_pad_end_date
87318: and xet.event_class_code = C_EVENT_CLASS_CODE
87319: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 88410: , fnd_lookup_values fvl35

88406: ELSE null
88407: END source_meaning
88408: FROM xla_events_gt xet
88409: , PA_XLA_CDL_LINES_V l1
88410: , fnd_lookup_values fvl35
88411: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
88412: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
88413: AND xet.event_class_code = C_EVENT_CLASS_CODE
88414: AND l1.event_id = xet.event_id

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

88543: l_balance_type_code VARCHAR2(1) :=NULL;
88544: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
88545:
88546: --
88547: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
88548: --
88549:
88550: TYPE t_array_source_33 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
88551: TYPE t_array_source_75 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 88687: , fnd_lookup_values fvl35

88683: , fvl35.meaning source_35_meaning
88684: , l1.LINE_NUM_REVERSED source_36
88685: FROM xla_events_gt xet
88686: , PA_XLA_CDL_LINES_V l1
88687: , fnd_lookup_values fvl35
88688: WHERE xet.event_id between x_first_event_id and x_last_event_id
88689: and xet.event_date between p_pad_start_date and p_pad_end_date
88690: and xet.event_class_code = C_EVENT_CLASS_CODE
88691: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 89782: , fnd_lookup_values fvl35

89778: ELSE null
89779: END source_meaning
89780: FROM xla_events_gt xet
89781: , PA_XLA_CCDL_LINES_V l1
89782: , fnd_lookup_values fvl35
89783: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
89784: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
89785: AND xet.event_class_code = C_EVENT_CLASS_CODE
89786: AND l1.event_id = xet.event_id

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

89915: l_balance_type_code VARCHAR2(1) :=NULL;
89916: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
89917:
89918: --
89919: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
89920: --
89921:
89922: TYPE t_array_source_33 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
89923: TYPE t_array_source_75 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 90059: , fnd_lookup_values fvl35

90055: , l1.ENTERED_AMOUNT source_42
90056: , l1.ACCT_AMOUNT source_43
90057: FROM xla_events_gt xet
90058: , PA_XLA_CCDL_LINES_V l1
90059: , fnd_lookup_values fvl35
90060: WHERE xet.event_id between x_first_event_id and x_last_event_id
90061: and xet.event_date between p_pad_start_date and p_pad_end_date
90062: and xet.event_class_code = C_EVENT_CLASS_CODE
90063: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 91080: , fnd_lookup_values fvl35

91076: ELSE null
91077: END source_meaning
91078: FROM xla_events_gt xet
91079: , PA_XLA_CCDL_LINES_V l1
91080: , fnd_lookup_values fvl35
91081: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
91082: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
91083: AND xet.event_class_code = C_EVENT_CLASS_CODE
91084: AND l1.event_id = xet.event_id

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

91213: l_balance_type_code VARCHAR2(1) :=NULL;
91214: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
91215:
91216: --
91217: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
91218: --
91219:
91220: TYPE t_array_source_33 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
91221: TYPE t_array_source_75 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 91357: , fnd_lookup_values fvl35

91353: , l1.ENTERED_AMOUNT source_42
91354: , l1.ACCT_AMOUNT source_43
91355: FROM xla_events_gt xet
91356: , PA_XLA_CCDL_LINES_V l1
91357: , fnd_lookup_values fvl35
91358: WHERE xet.event_id between x_first_event_id and x_last_event_id
91359: and xet.event_date between p_pad_start_date and p_pad_end_date
91360: and xet.event_class_code = C_EVENT_CLASS_CODE
91361: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 92432: , fnd_lookup_values fvl72

92428: END source_meaning
92429: FROM xla_events_gt xet
92430: , PA_XLA_EVENT_TYPE_REF_V l1
92431: , PA_XLA_REVENUE_LINES_ADJ_V l3
92432: , fnd_lookup_values fvl72
92433: , (select rownum r from all_objects where rownum <= 25 and owner = p_apps_owner)
92434: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
92435: AND xet.event_class_code = C_EVENT_CLASS_CODE
92436: AND l3.event_id = xet.event_id

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

92565: l_balance_type_code VARCHAR2(1) :=NULL;
92566: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
92567:
92568: --
92569: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
92570: --
92571:
92572: TYPE t_array_source_48 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.CREDITING_REVENUE_FLAG%TYPE INDEX BY BINARY_INTEGER;
92573: TYPE t_array_source_51 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.EVENT_ID%TYPE INDEX BY BINARY_INTEGER;

Line 92740: , fnd_lookup_values fvl72

92736: , fvl72.meaning source_72_meaning
92737: FROM xla_events_gt xet
92738: , PA_XLA_EVENT_TYPE_REF_V l1
92739: , PA_XLA_REVENUE_LINES_ADJ_V l3
92740: , fnd_lookup_values fvl72
92741: WHERE xet.event_id between x_first_event_id and x_last_event_id
92742: and xet.event_date between p_pad_start_date and p_pad_end_date
92743: and xet.event_class_code = C_EVENT_CLASS_CODE
92744: and xet.event_status_code <> 'N' AND l3.event_id = xet.event_id

Line 94161: , fnd_lookup_values fvl72

94157: END source_meaning
94158: FROM xla_events_gt xet
94159: , PA_XLA_EVENT_TYPE_REF_V l1
94160: , PA_XLA_REVENUE_LINES_V l3
94161: , fnd_lookup_values fvl72
94162: , (select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
94163: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
94164: AND xet.event_class_code = C_EVENT_CLASS_CODE
94165: AND l3.event_id = xet.event_id

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

94294: l_balance_type_code VARCHAR2(1) :=NULL;
94295: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
94296:
94297: --
94298: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
94299: --
94300:
94301: TYPE t_array_source_48 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.CREDITING_REVENUE_FLAG%TYPE INDEX BY BINARY_INTEGER;
94302: TYPE t_array_source_51 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.EVENT_ID%TYPE INDEX BY BINARY_INTEGER;

Line 94445: , fnd_lookup_values fvl72

94441: , fvl72.meaning source_72_meaning
94442: FROM xla_events_gt xet
94443: , PA_XLA_EVENT_TYPE_REF_V l1
94444: , PA_XLA_REVENUE_LINES_V l3
94445: , fnd_lookup_values fvl72
94446: WHERE xet.event_id between x_first_event_id and x_last_event_id
94447: and xet.event_date between p_pad_start_date and p_pad_end_date
94448: and xet.event_class_code = C_EVENT_CLASS_CODE
94449: and xet.event_status_code <> 'N' AND l3.event_id = xet.event_id

Line 95940: , fnd_lookup_values fvl35

95936: ELSE null
95937: END source_meaning
95938: FROM xla_events_gt xet
95939: , PA_XLA_CDL_LINES_V l2
95940: , fnd_lookup_values fvl35
95941: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
95942: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
95943: AND xet.event_class_code = C_EVENT_CLASS_CODE
95944: AND l2.event_id = xet.event_id

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

96073: l_balance_type_code VARCHAR2(1) :=NULL;
96074: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
96075:
96076: --
96077: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
96078: --
96079:
96080: TYPE t_array_source_2 IS TABLE OF GMS_XLA_AWARD_REF_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
96081: TYPE t_array_source_22 IS TABLE OF PA_XLA_EXP_HEADER_V.EXCHANGE_RATE_VARIANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 96224: , fnd_lookup_values fvl35

96220: , fvl35.meaning source_35_meaning
96221: , l2.LINE_NUM_REVERSED source_36
96222: FROM xla_events_gt xet
96223: , PA_XLA_CDL_LINES_V l2
96224: , fnd_lookup_values fvl35
96225: WHERE xet.event_id between x_first_event_id and x_last_event_id
96226: and xet.event_date between p_pad_start_date and p_pad_end_date
96227: and xet.event_class_code = C_EVENT_CLASS_CODE
96228: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 97501: , fnd_lookup_values fvl35

97497: ELSE null
97498: END source_meaning
97499: FROM xla_events_gt xet
97500: , PA_XLA_CDL_LINES_V l2
97501: , fnd_lookup_values fvl35
97502: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
97503: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
97504: AND xet.event_class_code = C_EVENT_CLASS_CODE
97505: AND l2.event_id = xet.event_id

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

97634: l_balance_type_code VARCHAR2(1) :=NULL;
97635: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
97636:
97637: --
97638: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
97639: --
97640:
97641: TYPE t_array_source_2 IS TABLE OF GMS_XLA_AWARD_REF_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
97642: TYPE t_array_source_22 IS TABLE OF PA_XLA_EXP_HEADER_V.EXCHANGE_RATE_VARIANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 97785: , fnd_lookup_values fvl35

97781: , fvl35.meaning source_35_meaning
97782: , l2.LINE_NUM_REVERSED source_36
97783: FROM xla_events_gt xet
97784: , PA_XLA_CDL_LINES_V l2
97785: , fnd_lookup_values fvl35
97786: WHERE xet.event_id between x_first_event_id and x_last_event_id
97787: and xet.event_date between p_pad_start_date and p_pad_end_date
97788: and xet.event_class_code = C_EVENT_CLASS_CODE
97789: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 99102: , fnd_lookup_values fvl35

99098: ELSE null
99099: END source_meaning
99100: FROM xla_events_gt xet
99101: , PA_XLA_CDL_LINES_V l1
99102: , fnd_lookup_values fvl35
99103: , (select rownum r from all_objects where rownum <= 30 and owner = p_apps_owner)
99104: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
99105: AND xet.event_class_code = C_EVENT_CLASS_CODE
99106: AND l1.event_id = xet.event_id

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

99235: l_balance_type_code VARCHAR2(1) :=NULL;
99236: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
99237:
99238: --
99239: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
99240: --
99241:
99242: TYPE t_array_source_33 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
99243: TYPE t_array_source_75 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 99415: , fnd_lookup_values fvl35

99411: , l1.ENCUMBRANCE_TYPE_ID source_62
99412: , l1.PROJ_ENCUMBRANCE_TYPE_ID source_63
99413: FROM xla_events_gt xet
99414: , PA_XLA_CDL_LINES_V l1
99415: , fnd_lookup_values fvl35
99416: WHERE xet.event_id between x_first_event_id and x_last_event_id
99417: and xet.event_date between p_pad_start_date and p_pad_end_date
99418: and xet.event_class_code = C_EVENT_CLASS_CODE
99419: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 100656: , fnd_lookup_values fvl35

100652: ELSE null
100653: END source_meaning
100654: FROM xla_events_gt xet
100655: , PA_XLA_CDL_LINES_V l1
100656: , fnd_lookup_values fvl35
100657: , (select rownum r from all_objects where rownum <= 31 and owner = p_apps_owner)
100658: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
100659: AND xet.event_class_code = C_EVENT_CLASS_CODE
100660: AND l1.event_id = xet.event_id

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

100789: l_balance_type_code VARCHAR2(1) :=NULL;
100790: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
100791:
100792: --
100793: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
100794: --
100795:
100796: TYPE t_array_source_33 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
100797: TYPE t_array_source_75 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 100972: , fnd_lookup_values fvl35

100968: , l1.ENCUMBRANCE_TYPE_ID source_62
100969: , l1.PROJ_ENCUMBRANCE_TYPE_ID source_63
100970: FROM xla_events_gt xet
100971: , PA_XLA_CDL_LINES_V l1
100972: , fnd_lookup_values fvl35
100973: WHERE xet.event_id between x_first_event_id and x_last_event_id
100974: and xet.event_date between p_pad_start_date and p_pad_end_date
100975: and xet.event_class_code = C_EVENT_CLASS_CODE
100976: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 102170: , fnd_lookup_values fvl35

102166: ELSE null
102167: END source_meaning
102168: FROM xla_events_gt xet
102169: , PA_XLA_CDL_LINES_V l1
102170: , fnd_lookup_values fvl35
102171: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
102172: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
102173: AND xet.event_class_code = C_EVENT_CLASS_CODE
102174: AND l1.event_id = xet.event_id

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

102303: l_balance_type_code VARCHAR2(1) :=NULL;
102304: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
102305:
102306: --
102307: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
102308: --
102309:
102310: TYPE t_array_source_33 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
102311: TYPE t_array_source_75 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 102447: , fnd_lookup_values fvl35

102443: , fvl35.meaning source_35_meaning
102444: , l1.LINE_NUM_REVERSED source_36
102445: FROM xla_events_gt xet
102446: , PA_XLA_CDL_LINES_V l1
102447: , fnd_lookup_values fvl35
102448: WHERE xet.event_id between x_first_event_id and x_last_event_id
102449: and xet.event_date between p_pad_start_date and p_pad_end_date
102450: and xet.event_class_code = C_EVENT_CLASS_CODE
102451: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 103542: , fnd_lookup_values fvl35

103538: ELSE null
103539: END source_meaning
103540: FROM xla_events_gt xet
103541: , PA_XLA_CDL_LINES_V l1
103542: , fnd_lookup_values fvl35
103543: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
103544: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
103545: AND xet.event_class_code = C_EVENT_CLASS_CODE
103546: AND l1.event_id = xet.event_id

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

103675: l_balance_type_code VARCHAR2(1) :=NULL;
103676: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
103677:
103678: --
103679: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
103680: --
103681:
103682: TYPE t_array_source_33 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
103683: TYPE t_array_source_75 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 103819: , fnd_lookup_values fvl35

103815: , fvl35.meaning source_35_meaning
103816: , l1.LINE_NUM_REVERSED source_36
103817: FROM xla_events_gt xet
103818: , PA_XLA_CDL_LINES_V l1
103819: , fnd_lookup_values fvl35
103820: WHERE xet.event_id between x_first_event_id and x_last_event_id
103821: and xet.event_date between p_pad_start_date and p_pad_end_date
103822: and xet.event_class_code = C_EVENT_CLASS_CODE
103823: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 104914: , fnd_lookup_values fvl35

104910: ELSE null
104911: END source_meaning
104912: FROM xla_events_gt xet
104913: , PA_XLA_CDL_LINES_V l1
104914: , fnd_lookup_values fvl35
104915: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
104916: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
104917: AND xet.event_class_code = C_EVENT_CLASS_CODE
104918: AND l1.event_id = xet.event_id

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

105047: l_balance_type_code VARCHAR2(1) :=NULL;
105048: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
105049:
105050: --
105051: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
105052: --
105053:
105054: TYPE t_array_source_33 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
105055: TYPE t_array_source_75 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 105191: , fnd_lookup_values fvl35

105187: , fvl35.meaning source_35_meaning
105188: , l1.LINE_NUM_REVERSED source_36
105189: FROM xla_events_gt xet
105190: , PA_XLA_CDL_LINES_V l1
105191: , fnd_lookup_values fvl35
105192: WHERE xet.event_id between x_first_event_id and x_last_event_id
105193: and xet.event_date between p_pad_start_date and p_pad_end_date
105194: and xet.event_class_code = C_EVENT_CLASS_CODE
105195: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 106286: , fnd_lookup_values fvl35

106282: ELSE null
106283: END source_meaning
106284: FROM xla_events_gt xet
106285: , PA_XLA_CDL_LINES_V l1
106286: , fnd_lookup_values fvl35
106287: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
106288: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
106289: AND xet.event_class_code = C_EVENT_CLASS_CODE
106290: AND l1.event_id = xet.event_id

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

106419: l_balance_type_code VARCHAR2(1) :=NULL;
106420: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
106421:
106422: --
106423: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
106424: --
106425:
106426: TYPE t_array_source_33 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
106427: TYPE t_array_source_75 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 106563: , fnd_lookup_values fvl35

106559: , fvl35.meaning source_35_meaning
106560: , l1.LINE_NUM_REVERSED source_36
106561: FROM xla_events_gt xet
106562: , PA_XLA_CDL_LINES_V l1
106563: , fnd_lookup_values fvl35
106564: WHERE xet.event_id between x_first_event_id and x_last_event_id
106565: and xet.event_date between p_pad_start_date and p_pad_end_date
106566: and xet.event_class_code = C_EVENT_CLASS_CODE
106567: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id