eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XLA_00275_AAD_S_000016_PKG dependencies on FND_LOOKUP_VALUES

Line 55394: , fnd_lookup_values fvl67

55390: ELSE null
55391: END source_meaning
55392: FROM xla_events_gt xet
55393: , PA_XLA_EXP_HEADER_V h2
55394: , fnd_lookup_values fvl67
55395: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
55396: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
55397: AND xet.event_class_code = C_EVENT_CLASS_CODE
55398: AND h2.event_id = xet.event_id

Line 55592: , fnd_lookup_values fvl34

55588: ELSE null
55589: END source_meaning
55590: FROM xla_events_gt xet
55591: , PA_XLA_CCDL_LINES_V l1
55592: , fnd_lookup_values fvl34
55593: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
55594: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
55595: AND xet.event_class_code = C_EVENT_CLASS_CODE
55596: AND l1.event_id = xet.event_id

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

55725: l_balance_type_code VARCHAR2(1) :=NULL;
55726: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
55727:
55728: --
55729: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
55730: --
55731:
55732: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
55733: TYPE t_array_source_67 IS TABLE OF PA_XLA_EXP_HEADER_V.TP_AMT_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 55815: , fnd_lookup_values fvl67

55811: , fvl67.meaning source_67_meaning
55812: , h2.GL_DATE source_88
55813: FROM xla_events_gt xet
55814: , PA_XLA_EXP_HEADER_V h2
55815: , fnd_lookup_values fvl67
55816: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
55817: and xet.event_class_code = C_EVENT_CLASS_CODE
55818: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
55819: AND fvl67.lookup_type(+) = 'TP_AMOUNT_TYPE'

Line 55879: , fnd_lookup_values fvl34

55875: , l1.ENTERED_AMOUNT source_41
55876: , l1.ACCT_AMOUNT source_43
55877: FROM xla_events_gt xet
55878: , PA_XLA_CCDL_LINES_V l1
55879: , fnd_lookup_values fvl34
55880: WHERE xet.event_id between x_first_event_id and x_last_event_id
55881: and xet.event_date between p_pad_start_date and p_pad_end_date
55882: and xet.event_class_code = C_EVENT_CLASS_CODE
55883: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 56802: , fnd_lookup_values fvl67

56798: ELSE null
56799: END source_meaning
56800: FROM xla_events_gt xet
56801: , PA_XLA_EXP_HEADER_V h2
56802: , fnd_lookup_values fvl67
56803: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
56804: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
56805: AND xet.event_class_code = C_EVENT_CLASS_CODE
56806: AND h2.event_id = xet.event_id

Line 57000: , fnd_lookup_values fvl34

56996: ELSE null
56997: END source_meaning
56998: FROM xla_events_gt xet
56999: , PA_XLA_CCDL_LINES_V l1
57000: , fnd_lookup_values fvl34
57001: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
57002: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
57003: AND xet.event_class_code = C_EVENT_CLASS_CODE
57004: AND l1.event_id = xet.event_id

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

57133: l_balance_type_code VARCHAR2(1) :=NULL;
57134: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
57135:
57136: --
57137: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
57138: --
57139:
57140: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
57141: TYPE t_array_source_67 IS TABLE OF PA_XLA_EXP_HEADER_V.TP_AMT_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 57223: , fnd_lookup_values fvl67

57219: , fvl67.meaning source_67_meaning
57220: , h2.GL_DATE source_88
57221: FROM xla_events_gt xet
57222: , PA_XLA_EXP_HEADER_V h2
57223: , fnd_lookup_values fvl67
57224: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
57225: and xet.event_class_code = C_EVENT_CLASS_CODE
57226: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
57227: AND fvl67.lookup_type(+) = 'TP_AMOUNT_TYPE'

Line 57287: , fnd_lookup_values fvl34

57283: , l1.ENTERED_AMOUNT source_41
57284: , l1.ACCT_AMOUNT source_43
57285: FROM xla_events_gt xet
57286: , PA_XLA_CCDL_LINES_V l1
57287: , fnd_lookup_values fvl34
57288: WHERE xet.event_id between x_first_event_id and x_last_event_id
57289: and xet.event_date between p_pad_start_date and p_pad_end_date
57290: and xet.event_class_code = C_EVENT_CLASS_CODE
57291: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 58348: , fnd_lookup_values fvl34

58344: ELSE null
58345: END source_meaning
58346: FROM xla_events_gt xet
58347: , PA_XLA_BC_BUDGET_LINES_V l2
58348: , fnd_lookup_values fvl34
58349: , (select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
58350: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
58351: AND xet.event_class_code = C_EVENT_CLASS_CODE
58352: AND l2.event_id = xet.event_id

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

58481: l_balance_type_code VARCHAR2(1) :=NULL;
58482: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
58483:
58484: --
58485: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
58486: --
58487:
58488: TYPE t_array_source_88 IS TABLE OF PA_XLA_BC_BUDGET_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
58489: TYPE t_array_source_89 IS TABLE OF PA_XLA_BC_BUDGET_HEADER_V.GL_BUDGET_VERSION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 58601: , fnd_lookup_values fvl34

58597: , l2.BUDGET_LINE_ID source_90
58598: , l2.ENC_UPG_ENC_TYPE_ID source_91
58599: FROM xla_events_gt xet
58600: , PA_XLA_BC_BUDGET_LINES_V l2
58601: , fnd_lookup_values fvl34
58602: WHERE xet.event_id between x_first_event_id and x_last_event_id
58603: and xet.event_date between p_pad_start_date and p_pad_end_date
58604: and xet.event_class_code = C_EVENT_CLASS_CODE
58605: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 59583: , fnd_lookup_values fvl34

59579: ELSE null
59580: END source_meaning
59581: FROM xla_events_gt xet
59582: , PA_XLA_CDL_LINES_V l1
59583: , fnd_lookup_values fvl34
59584: , (select rownum r from all_objects where rownum <= 31 and owner = p_apps_owner)
59585: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
59586: AND xet.event_class_code = C_EVENT_CLASS_CODE
59587: AND l1.event_id = xet.event_id

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

59716: l_balance_type_code VARCHAR2(1) :=NULL;
59717: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
59718:
59719: --
59720: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
59721: --
59722:
59723: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
59724: TYPE t_array_source_88 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 59899: , fnd_lookup_values fvl34

59895: , l1.ENCUMBRANCE_TYPE_ID source_56
59896: , l1.PROJ_ENCUMBRANCE_TYPE_ID source_57
59897: FROM xla_events_gt xet
59898: , PA_XLA_CDL_LINES_V l1
59899: , fnd_lookup_values fvl34
59900: WHERE xet.event_id between x_first_event_id and x_last_event_id
59901: and xet.event_date between p_pad_start_date and p_pad_end_date
59902: and xet.event_class_code = C_EVENT_CLASS_CODE
59903: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 61146: , fnd_lookup_values fvl34

61142: ELSE null
61143: END source_meaning
61144: FROM xla_events_gt xet
61145: , PA_XLA_CDL_LINES_V l1
61146: , fnd_lookup_values fvl34
61147: , fnd_lookup_values fvl70
61148: , (select rownum r from all_objects where rownum <= 49 and owner = p_apps_owner)
61149: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
61150: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 61147: , fnd_lookup_values fvl70

61143: END source_meaning
61144: FROM xla_events_gt xet
61145: , PA_XLA_CDL_LINES_V l1
61146: , fnd_lookup_values fvl34
61147: , fnd_lookup_values fvl70
61148: , (select rownum r from all_objects where rownum <= 49 and owner = p_apps_owner)
61149: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
61150: AND xet.event_class_code = C_EVENT_CLASS_CODE
61151: AND l1.event_id = xet.event_id

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

61284: l_balance_type_code VARCHAR2(1) :=NULL;
61285: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
61286:
61287: --
61288: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
61289: --
61290:
61291: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
61292: TYPE t_array_source_37 IS TABLE OF PA_XLA_EXP_HEADER_V.SYSTEM_LINKAGE_FUNCTION%TYPE INDEX BY BINARY_INTEGER;

Line 61526: , fnd_lookup_values fvl34

61522: , l1.ENC_ACCT_ENABLED source_86
61523: , l1.LIQUIDATE_ENCUM_FLAG source_87
61524: FROM xla_events_gt xet
61525: , PA_XLA_CDL_LINES_V l1
61526: , fnd_lookup_values fvl34
61527: , fnd_lookup_values fvl70
61528: WHERE xet.event_id between x_first_event_id and x_last_event_id
61529: and xet.event_date between p_pad_start_date and p_pad_end_date
61530: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 61527: , fnd_lookup_values fvl70

61523: , l1.LIQUIDATE_ENCUM_FLAG source_87
61524: FROM xla_events_gt xet
61525: , PA_XLA_CDL_LINES_V l1
61526: , fnd_lookup_values fvl34
61527: , fnd_lookup_values fvl70
61528: WHERE xet.event_id between x_first_event_id and x_last_event_id
61529: and xet.event_date between p_pad_start_date and p_pad_end_date
61530: and xet.event_class_code = C_EVENT_CLASS_CODE
61531: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 62995: , fnd_lookup_values fvl34

62991: ELSE null
62992: END source_meaning
62993: FROM xla_events_gt xet
62994: , PA_XLA_CDL_LINES_V l1
62995: , fnd_lookup_values fvl34
62996: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
62997: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
62998: AND xet.event_class_code = C_EVENT_CLASS_CODE
62999: AND l1.event_id = xet.event_id

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

63128: l_balance_type_code VARCHAR2(1) :=NULL;
63129: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
63130:
63131: --
63132: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
63133: --
63134:
63135: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
63136: TYPE t_array_source_88 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 63272: , fnd_lookup_values fvl34

63268: , fvl34.meaning source_34_meaning
63269: , l1.LINE_NUM_REVERSED source_35
63270: FROM xla_events_gt xet
63271: , PA_XLA_CDL_LINES_V l1
63272: , fnd_lookup_values fvl34
63273: WHERE xet.event_id between x_first_event_id and x_last_event_id
63274: and xet.event_date between p_pad_start_date and p_pad_end_date
63275: and xet.event_class_code = C_EVENT_CLASS_CODE
63276: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 64293: , fnd_lookup_values fvl34

64289: ELSE null
64290: END source_meaning
64291: FROM xla_events_gt xet
64292: , PA_XLA_CDL_LINES_V l1
64293: , fnd_lookup_values fvl34
64294: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
64295: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
64296: AND xet.event_class_code = C_EVENT_CLASS_CODE
64297: AND l1.event_id = xet.event_id

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

64426: l_balance_type_code VARCHAR2(1) :=NULL;
64427: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
64428:
64429: --
64430: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
64431: --
64432:
64433: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
64434: TYPE t_array_source_88 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 64570: , fnd_lookup_values fvl34

64566: , fvl34.meaning source_34_meaning
64567: , l1.LINE_NUM_REVERSED source_35
64568: FROM xla_events_gt xet
64569: , PA_XLA_CDL_LINES_V l1
64570: , fnd_lookup_values fvl34
64571: WHERE xet.event_id between x_first_event_id and x_last_event_id
64572: and xet.event_date between p_pad_start_date and p_pad_end_date
64573: and xet.event_class_code = C_EVENT_CLASS_CODE
64574: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 65591: , fnd_lookup_values fvl34

65587: ELSE null
65588: END source_meaning
65589: FROM xla_events_gt xet
65590: , PA_XLA_CDL_LINES_V l1
65591: , fnd_lookup_values fvl34
65592: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
65593: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
65594: AND xet.event_class_code = C_EVENT_CLASS_CODE
65595: AND l1.event_id = xet.event_id

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

65724: l_balance_type_code VARCHAR2(1) :=NULL;
65725: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
65726:
65727: --
65728: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
65729: --
65730:
65731: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
65732: TYPE t_array_source_88 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 65868: , fnd_lookup_values fvl34

65864: , fvl34.meaning source_34_meaning
65865: , l1.LINE_NUM_REVERSED source_35
65866: FROM xla_events_gt xet
65867: , PA_XLA_CDL_LINES_V l1
65868: , fnd_lookup_values fvl34
65869: WHERE xet.event_id between x_first_event_id and x_last_event_id
65870: and xet.event_date between p_pad_start_date and p_pad_end_date
65871: and xet.event_class_code = C_EVENT_CLASS_CODE
65872: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 66889: , fnd_lookup_values fvl34

66885: ELSE null
66886: END source_meaning
66887: FROM xla_events_gt xet
66888: , PA_XLA_CDL_LINES_V l1
66889: , fnd_lookup_values fvl34
66890: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
66891: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
66892: AND xet.event_class_code = C_EVENT_CLASS_CODE
66893: AND l1.event_id = xet.event_id

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

67022: l_balance_type_code VARCHAR2(1) :=NULL;
67023: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
67024:
67025: --
67026: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
67027: --
67028:
67029: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
67030: TYPE t_array_source_88 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 67166: , fnd_lookup_values fvl34

67162: , fvl34.meaning source_34_meaning
67163: , l1.LINE_NUM_REVERSED source_35
67164: FROM xla_events_gt xet
67165: , PA_XLA_CDL_LINES_V l1
67166: , fnd_lookup_values fvl34
67167: WHERE xet.event_id between x_first_event_id and x_last_event_id
67168: and xet.event_date between p_pad_start_date and p_pad_end_date
67169: and xet.event_class_code = C_EVENT_CLASS_CODE
67170: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 68193: , fnd_lookup_values fvl34

68189: ELSE null
68190: END source_meaning
68191: FROM xla_events_gt xet
68192: , PA_XLA_CDL_LINES_V l1
68193: , fnd_lookup_values fvl34
68194: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
68195: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
68196: AND xet.event_class_code = C_EVENT_CLASS_CODE
68197: AND l1.event_id = xet.event_id

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

68326: l_balance_type_code VARCHAR2(1) :=NULL;
68327: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
68328:
68329: --
68330: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
68331: --
68332:
68333: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
68334: TYPE t_array_source_68 IS TABLE OF PA_XLA_PROJECT_REF_V.PROJECT_NUMBER%TYPE INDEX BY BINARY_INTEGER;

Line 68474: , fnd_lookup_values fvl34

68470: , fvl34.meaning source_34_meaning
68471: , l1.LINE_NUM_REVERSED source_35
68472: FROM xla_events_gt xet
68473: , PA_XLA_CDL_LINES_V l1
68474: , fnd_lookup_values fvl34
68475: WHERE xet.event_id between x_first_event_id and x_last_event_id
68476: and xet.event_date between p_pad_start_date and p_pad_end_date
68477: and xet.event_class_code = C_EVENT_CLASS_CODE
68478: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 69505: , fnd_lookup_values fvl34

69501: ELSE null
69502: END source_meaning
69503: FROM xla_events_gt xet
69504: , PA_XLA_CDL_LINES_V l1
69505: , fnd_lookup_values fvl34
69506: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
69507: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
69508: AND xet.event_class_code = C_EVENT_CLASS_CODE
69509: AND l1.event_id = xet.event_id

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

69638: l_balance_type_code VARCHAR2(1) :=NULL;
69639: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
69640:
69641: --
69642: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
69643: --
69644:
69645: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
69646: TYPE t_array_source_68 IS TABLE OF PA_XLA_PROJECT_REF_V.PROJECT_NUMBER%TYPE INDEX BY BINARY_INTEGER;

Line 69786: , fnd_lookup_values fvl34

69782: , fvl34.meaning source_34_meaning
69783: , l1.LINE_NUM_REVERSED source_35
69784: FROM xla_events_gt xet
69785: , PA_XLA_CDL_LINES_V l1
69786: , fnd_lookup_values fvl34
69787: WHERE xet.event_id between x_first_event_id and x_last_event_id
69788: and xet.event_date between p_pad_start_date and p_pad_end_date
69789: and xet.event_class_code = C_EVENT_CLASS_CODE
69790: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 70811: , fnd_lookup_values fvl34

70807: ELSE null
70808: END source_meaning
70809: FROM xla_events_gt xet
70810: , PA_XLA_CCDL_LINES_V l1
70811: , fnd_lookup_values fvl34
70812: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
70813: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
70814: AND xet.event_class_code = C_EVENT_CLASS_CODE
70815: AND l1.event_id = xet.event_id

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

70944: l_balance_type_code VARCHAR2(1) :=NULL;
70945: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
70946:
70947: --
70948: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
70949: --
70950:
70951: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
70952: TYPE t_array_source_88 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 71088: , fnd_lookup_values fvl34

71084: , l1.ENTERED_AMOUNT source_41
71085: , l1.ACCT_AMOUNT source_43
71086: FROM xla_events_gt xet
71087: , PA_XLA_CCDL_LINES_V l1
71088: , fnd_lookup_values fvl34
71089: WHERE xet.event_id between x_first_event_id and x_last_event_id
71090: and xet.event_date between p_pad_start_date and p_pad_end_date
71091: and xet.event_class_code = C_EVENT_CLASS_CODE
71092: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 72109: , fnd_lookup_values fvl34

72105: ELSE null
72106: END source_meaning
72107: FROM xla_events_gt xet
72108: , PA_XLA_CCDL_LINES_V l1
72109: , fnd_lookup_values fvl34
72110: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
72111: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
72112: AND xet.event_class_code = C_EVENT_CLASS_CODE
72113: AND l1.event_id = xet.event_id

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

72242: l_balance_type_code VARCHAR2(1) :=NULL;
72243: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
72244:
72245: --
72246: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
72247: --
72248:
72249: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
72250: TYPE t_array_source_88 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 72386: , fnd_lookup_values fvl34

72382: , l1.ENTERED_AMOUNT source_41
72383: , l1.ACCT_AMOUNT source_43
72384: FROM xla_events_gt xet
72385: , PA_XLA_CCDL_LINES_V l1
72386: , fnd_lookup_values fvl34
72387: WHERE xet.event_id between x_first_event_id and x_last_event_id
72388: and xet.event_date between p_pad_start_date and p_pad_end_date
72389: and xet.event_class_code = C_EVENT_CLASS_CODE
72390: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 73451: , fnd_lookup_values fvl58

73447: END source_meaning
73448: FROM xla_events_gt xet
73449: , PA_XLA_EVENT_TYPE_REF_V l1
73450: , PA_XLA_REVENUE_LINES_ADJ_V l3
73451: , fnd_lookup_values fvl58
73452: , (select rownum r from all_objects where rownum <= 23 and owner = p_apps_owner)
73453: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
73454: AND xet.event_class_code = C_EVENT_CLASS_CODE
73455: AND l3.event_id = xet.event_id

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

73584: l_balance_type_code VARCHAR2(1) :=NULL;
73585: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
73586:
73587: --
73588: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
73589: --
73590:
73591: TYPE t_array_source_38 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.CREDITING_REVENUE_FLAG%TYPE INDEX BY BINARY_INTEGER;
73592: TYPE t_array_source_42 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.EVENT_ID%TYPE INDEX BY BINARY_INTEGER;

Line 73753: , fnd_lookup_values fvl58

73749: , l3.PDR_DRAFT_REV_NUM_CREDITED source_66
73750: FROM xla_events_gt xet
73751: , PA_XLA_EVENT_TYPE_REF_V l1
73752: , PA_XLA_REVENUE_LINES_ADJ_V l3
73753: , fnd_lookup_values fvl58
73754: WHERE xet.event_id between x_first_event_id and x_last_event_id
73755: and xet.event_date between p_pad_start_date and p_pad_end_date
73756: and xet.event_class_code = C_EVENT_CLASS_CODE
73757: and xet.event_status_code <> 'N' AND l3.event_id = xet.event_id

Line 74963: , fnd_lookup_values fvl58

74959: END source_meaning
74960: FROM xla_events_gt xet
74961: , PA_XLA_EVENT_TYPE_REF_V l1
74962: , PA_XLA_REVENUE_LINES_V l3
74963: , fnd_lookup_values fvl58
74964: , (select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
74965: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
74966: AND xet.event_class_code = C_EVENT_CLASS_CODE
74967: AND l3.event_id = xet.event_id

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

75096: l_balance_type_code VARCHAR2(1) :=NULL;
75097: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
75098:
75099: --
75100: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
75101: --
75102:
75103: TYPE t_array_source_38 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.CREDITING_REVENUE_FLAG%TYPE INDEX BY BINARY_INTEGER;
75104: TYPE t_array_source_42 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.EVENT_ID%TYPE INDEX BY BINARY_INTEGER;

Line 75247: , fnd_lookup_values fvl58

75243: , fvl58.meaning source_58_meaning
75244: FROM xla_events_gt xet
75245: , PA_XLA_EVENT_TYPE_REF_V l1
75246: , PA_XLA_REVENUE_LINES_V l3
75247: , fnd_lookup_values fvl58
75248: WHERE xet.event_id between x_first_event_id and x_last_event_id
75249: and xet.event_date between p_pad_start_date and p_pad_end_date
75250: and xet.event_class_code = C_EVENT_CLASS_CODE
75251: and xet.event_status_code <> 'N' AND l3.event_id = xet.event_id

Line 76597: , fnd_lookup_values fvl34

76593: ELSE null
76594: END source_meaning
76595: FROM xla_events_gt xet
76596: , PA_XLA_CDL_LINES_V l1
76597: , fnd_lookup_values fvl34
76598: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
76599: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
76600: AND xet.event_class_code = C_EVENT_CLASS_CODE
76601: AND l1.event_id = xet.event_id

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

76730: l_balance_type_code VARCHAR2(1) :=NULL;
76731: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
76732:
76733: --
76734: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
76735: --
76736:
76737: TYPE t_array_source_21 IS TABLE OF PA_XLA_EXP_HEADER_V.EXCHANGE_RATE_VARIANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
76738: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;

Line 76877: , fnd_lookup_values fvl34

76873: , fvl34.meaning source_34_meaning
76874: , l1.LINE_NUM_REVERSED source_35
76875: FROM xla_events_gt xet
76876: , PA_XLA_CDL_LINES_V l1
76877: , fnd_lookup_values fvl34
76878: WHERE xet.event_id between x_first_event_id and x_last_event_id
76879: and xet.event_date between p_pad_start_date and p_pad_end_date
76880: and xet.event_class_code = C_EVENT_CLASS_CODE
76881: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 77992: , fnd_lookup_values fvl34

77988: ELSE null
77989: END source_meaning
77990: FROM xla_events_gt xet
77991: , PA_XLA_CDL_LINES_V l1
77992: , fnd_lookup_values fvl34
77993: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
77994: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
77995: AND xet.event_class_code = C_EVENT_CLASS_CODE
77996: AND l1.event_id = xet.event_id

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

78125: l_balance_type_code VARCHAR2(1) :=NULL;
78126: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
78127:
78128: --
78129: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
78130: --
78131:
78132: TYPE t_array_source_21 IS TABLE OF PA_XLA_EXP_HEADER_V.EXCHANGE_RATE_VARIANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
78133: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;

Line 78272: , fnd_lookup_values fvl34

78268: , fvl34.meaning source_34_meaning
78269: , l1.LINE_NUM_REVERSED source_35
78270: FROM xla_events_gt xet
78271: , PA_XLA_CDL_LINES_V l1
78272: , fnd_lookup_values fvl34
78273: WHERE xet.event_id between x_first_event_id and x_last_event_id
78274: and xet.event_date between p_pad_start_date and p_pad_end_date
78275: and xet.event_class_code = C_EVENT_CLASS_CODE
78276: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 79529: , fnd_lookup_values fvl34

79525: ELSE null
79526: END source_meaning
79527: FROM xla_events_gt xet
79528: , PA_XLA_CDL_LINES_V l1
79529: , fnd_lookup_values fvl34
79530: , fnd_lookup_values fvl70
79531: , (select rownum r from all_objects where rownum <= 48 and owner = p_apps_owner)
79532: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
79533: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 79530: , fnd_lookup_values fvl70

79526: END source_meaning
79527: FROM xla_events_gt xet
79528: , PA_XLA_CDL_LINES_V l1
79529: , fnd_lookup_values fvl34
79530: , fnd_lookup_values fvl70
79531: , (select rownum r from all_objects where rownum <= 48 and owner = p_apps_owner)
79532: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
79533: AND xet.event_class_code = C_EVENT_CLASS_CODE
79534: AND l1.event_id = xet.event_id

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

79667: l_balance_type_code VARCHAR2(1) :=NULL;
79668: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
79669:
79670: --
79671: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
79672: --
79673:
79674: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
79675: TYPE t_array_source_37 IS TABLE OF PA_XLA_EXP_HEADER_V.SYSTEM_LINKAGE_FUNCTION%TYPE INDEX BY BINARY_INTEGER;

Line 79906: , fnd_lookup_values fvl34

79902: , l1.ENC_ACCT_ENABLED source_86
79903: , l1.LIQUIDATE_ENCUM_FLAG source_87
79904: FROM xla_events_gt xet
79905: , PA_XLA_CDL_LINES_V l1
79906: , fnd_lookup_values fvl34
79907: , fnd_lookup_values fvl70
79908: WHERE xet.event_id between x_first_event_id and x_last_event_id
79909: and xet.event_date between p_pad_start_date and p_pad_end_date
79910: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 79907: , fnd_lookup_values fvl70

79903: , l1.LIQUIDATE_ENCUM_FLAG source_87
79904: FROM xla_events_gt xet
79905: , PA_XLA_CDL_LINES_V l1
79906: , fnd_lookup_values fvl34
79907: , fnd_lookup_values fvl70
79908: WHERE xet.event_id between x_first_event_id and x_last_event_id
79909: and xet.event_date between p_pad_start_date and p_pad_end_date
79910: and xet.event_class_code = C_EVENT_CLASS_CODE
79911: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 81522: , fnd_lookup_values fvl34

81518: ELSE null
81519: END source_meaning
81520: FROM xla_events_gt xet
81521: , PA_XLA_CDL_LINES_V l1
81522: , fnd_lookup_values fvl34
81523: , fnd_lookup_values fvl70
81524: , (select rownum r from all_objects where rownum <= 49 and owner = p_apps_owner)
81525: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
81526: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 81523: , fnd_lookup_values fvl70

81519: END source_meaning
81520: FROM xla_events_gt xet
81521: , PA_XLA_CDL_LINES_V l1
81522: , fnd_lookup_values fvl34
81523: , fnd_lookup_values fvl70
81524: , (select rownum r from all_objects where rownum <= 49 and owner = p_apps_owner)
81525: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
81526: AND xet.event_class_code = C_EVENT_CLASS_CODE
81527: AND l1.event_id = xet.event_id

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

81660: l_balance_type_code VARCHAR2(1) :=NULL;
81661: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
81662:
81663: --
81664: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
81665: --
81666:
81667: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
81668: TYPE t_array_source_37 IS TABLE OF PA_XLA_EXP_HEADER_V.SYSTEM_LINKAGE_FUNCTION%TYPE INDEX BY BINARY_INTEGER;

Line 81902: , fnd_lookup_values fvl34

81898: , l1.ENC_ACCT_ENABLED source_86
81899: , l1.LIQUIDATE_ENCUM_FLAG source_87
81900: FROM xla_events_gt xet
81901: , PA_XLA_CDL_LINES_V l1
81902: , fnd_lookup_values fvl34
81903: , fnd_lookup_values fvl70
81904: WHERE xet.event_id between x_first_event_id and x_last_event_id
81905: and xet.event_date between p_pad_start_date and p_pad_end_date
81906: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 81903: , fnd_lookup_values fvl70

81899: , l1.LIQUIDATE_ENCUM_FLAG source_87
81900: FROM xla_events_gt xet
81901: , PA_XLA_CDL_LINES_V l1
81902: , fnd_lookup_values fvl34
81903: , fnd_lookup_values fvl70
81904: WHERE xet.event_id between x_first_event_id and x_last_event_id
81905: and xet.event_date between p_pad_start_date and p_pad_end_date
81906: and xet.event_class_code = C_EVENT_CLASS_CODE
81907: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 83384: , fnd_lookup_values fvl34

83380: ELSE null
83381: END source_meaning
83382: FROM xla_events_gt xet
83383: , PA_XLA_CDL_LINES_V l1
83384: , fnd_lookup_values fvl34
83385: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
83386: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
83387: AND xet.event_class_code = C_EVENT_CLASS_CODE
83388: AND l1.event_id = xet.event_id

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

83517: l_balance_type_code VARCHAR2(1) :=NULL;
83518: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
83519:
83520: --
83521: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
83522: --
83523:
83524: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
83525: TYPE t_array_source_88 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 83661: , fnd_lookup_values fvl34

83657: , fvl34.meaning source_34_meaning
83658: , l1.LINE_NUM_REVERSED source_35
83659: FROM xla_events_gt xet
83660: , PA_XLA_CDL_LINES_V l1
83661: , fnd_lookup_values fvl34
83662: WHERE xet.event_id between x_first_event_id and x_last_event_id
83663: and xet.event_date between p_pad_start_date and p_pad_end_date
83664: and xet.event_class_code = C_EVENT_CLASS_CODE
83665: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 84682: , fnd_lookup_values fvl34

84678: ELSE null
84679: END source_meaning
84680: FROM xla_events_gt xet
84681: , PA_XLA_CDL_LINES_V l1
84682: , fnd_lookup_values fvl34
84683: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
84684: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
84685: AND xet.event_class_code = C_EVENT_CLASS_CODE
84686: AND l1.event_id = xet.event_id

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

84815: l_balance_type_code VARCHAR2(1) :=NULL;
84816: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
84817:
84818: --
84819: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
84820: --
84821:
84822: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
84823: TYPE t_array_source_88 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 84959: , fnd_lookup_values fvl34

84955: , fvl34.meaning source_34_meaning
84956: , l1.LINE_NUM_REVERSED source_35
84957: FROM xla_events_gt xet
84958: , PA_XLA_CDL_LINES_V l1
84959: , fnd_lookup_values fvl34
84960: WHERE xet.event_id between x_first_event_id and x_last_event_id
84961: and xet.event_date between p_pad_start_date and p_pad_end_date
84962: and xet.event_class_code = C_EVENT_CLASS_CODE
84963: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 85980: , fnd_lookup_values fvl34

85976: ELSE null
85977: END source_meaning
85978: FROM xla_events_gt xet
85979: , PA_XLA_CDL_LINES_V l1
85980: , fnd_lookup_values fvl34
85981: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
85982: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
85983: AND xet.event_class_code = C_EVENT_CLASS_CODE
85984: AND l1.event_id = xet.event_id

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

86113: l_balance_type_code VARCHAR2(1) :=NULL;
86114: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
86115:
86116: --
86117: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
86118: --
86119:
86120: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
86121: TYPE t_array_source_88 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 86257: , fnd_lookup_values fvl34

86253: , fvl34.meaning source_34_meaning
86254: , l1.LINE_NUM_REVERSED source_35
86255: FROM xla_events_gt xet
86256: , PA_XLA_CDL_LINES_V l1
86257: , fnd_lookup_values fvl34
86258: WHERE xet.event_id between x_first_event_id and x_last_event_id
86259: and xet.event_date between p_pad_start_date and p_pad_end_date
86260: and xet.event_class_code = C_EVENT_CLASS_CODE
86261: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 87278: , fnd_lookup_values fvl34

87274: ELSE null
87275: END source_meaning
87276: FROM xla_events_gt xet
87277: , PA_XLA_CDL_LINES_V l1
87278: , fnd_lookup_values fvl34
87279: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
87280: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
87281: AND xet.event_class_code = C_EVENT_CLASS_CODE
87282: AND l1.event_id = xet.event_id

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

87411: l_balance_type_code VARCHAR2(1) :=NULL;
87412: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
87413:
87414: --
87415: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
87416: --
87417:
87418: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
87419: TYPE t_array_source_88 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 87555: , fnd_lookup_values fvl34

87551: , fvl34.meaning source_34_meaning
87552: , l1.LINE_NUM_REVERSED source_35
87553: FROM xla_events_gt xet
87554: , PA_XLA_CDL_LINES_V l1
87555: , fnd_lookup_values fvl34
87556: WHERE xet.event_id between x_first_event_id and x_last_event_id
87557: and xet.event_date between p_pad_start_date and p_pad_end_date
87558: and xet.event_class_code = C_EVENT_CLASS_CODE
87559: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id