DBA Data[Home] [Help]

APPS.XLA_00275_AAD_S_000004_PKG dependencies on FND_LOOKUP_VALUES

Line 55314: , fnd_lookup_values fvl67

55310: ELSE null
55311: END source_meaning
55312: FROM xla_events_gt xet
55313: , PA_XLA_EXP_HEADER_V h2
55314: , fnd_lookup_values fvl67
55315: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
55316: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
55317: AND xet.event_class_code = C_EVENT_CLASS_CODE
55318: AND h2.event_id = xet.event_id

Line 55512: , fnd_lookup_values fvl34

55508: ELSE null
55509: END source_meaning
55510: FROM xla_events_gt xet
55511: , PA_XLA_CCDL_LINES_V l1
55512: , fnd_lookup_values fvl34
55513: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
55514: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
55515: AND xet.event_class_code = C_EVENT_CLASS_CODE
55516: AND l1.event_id = xet.event_id

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

55645: l_balance_type_code VARCHAR2(1) :=NULL;
55646: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
55647:
55648: --
55649: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
55650: --
55651:
55652: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
55653: TYPE t_array_source_67 IS TABLE OF PA_XLA_EXP_HEADER_V.TP_AMT_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 55735: , fnd_lookup_values fvl67

55731: , fvl67.meaning source_67_meaning
55732: , h2.GL_DATE source_87
55733: FROM xla_events_gt xet
55734: , PA_XLA_EXP_HEADER_V h2
55735: , fnd_lookup_values fvl67
55736: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
55737: and xet.event_class_code = C_EVENT_CLASS_CODE
55738: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
55739: AND fvl67.lookup_type(+) = 'TP_AMOUNT_TYPE'

Line 55799: , fnd_lookup_values fvl34

55795: , l1.ENTERED_AMOUNT source_41
55796: , l1.ACCT_AMOUNT source_43
55797: FROM xla_events_gt xet
55798: , PA_XLA_CCDL_LINES_V l1
55799: , fnd_lookup_values fvl34
55800: WHERE xet.event_id between x_first_event_id and x_last_event_id
55801: and xet.event_date between p_pad_start_date and p_pad_end_date
55802: and xet.event_class_code = C_EVENT_CLASS_CODE
55803: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 56722: , fnd_lookup_values fvl67

56718: ELSE null
56719: END source_meaning
56720: FROM xla_events_gt xet
56721: , PA_XLA_EXP_HEADER_V h2
56722: , fnd_lookup_values fvl67
56723: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
56724: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
56725: AND xet.event_class_code = C_EVENT_CLASS_CODE
56726: AND h2.event_id = xet.event_id

Line 56920: , fnd_lookup_values fvl34

56916: ELSE null
56917: END source_meaning
56918: FROM xla_events_gt xet
56919: , PA_XLA_CCDL_LINES_V l1
56920: , fnd_lookup_values fvl34
56921: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
56922: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
56923: AND xet.event_class_code = C_EVENT_CLASS_CODE
56924: AND l1.event_id = xet.event_id

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

57053: l_balance_type_code VARCHAR2(1) :=NULL;
57054: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
57055:
57056: --
57057: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
57058: --
57059:
57060: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
57061: TYPE t_array_source_67 IS TABLE OF PA_XLA_EXP_HEADER_V.TP_AMT_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 57143: , fnd_lookup_values fvl67

57139: , fvl67.meaning source_67_meaning
57140: , h2.GL_DATE source_87
57141: FROM xla_events_gt xet
57142: , PA_XLA_EXP_HEADER_V h2
57143: , fnd_lookup_values fvl67
57144: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
57145: and xet.event_class_code = C_EVENT_CLASS_CODE
57146: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
57147: AND fvl67.lookup_type(+) = 'TP_AMOUNT_TYPE'

Line 57207: , fnd_lookup_values fvl34

57203: , l1.ENTERED_AMOUNT source_41
57204: , l1.ACCT_AMOUNT source_43
57205: FROM xla_events_gt xet
57206: , PA_XLA_CCDL_LINES_V l1
57207: , fnd_lookup_values fvl34
57208: WHERE xet.event_id between x_first_event_id and x_last_event_id
57209: and xet.event_date between p_pad_start_date and p_pad_end_date
57210: and xet.event_class_code = C_EVENT_CLASS_CODE
57211: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 58268: , fnd_lookup_values fvl34

58264: ELSE null
58265: END source_meaning
58266: FROM xla_events_gt xet
58267: , PA_XLA_BC_BUDGET_LINES_V l2
58268: , fnd_lookup_values fvl34
58269: , (select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
58270: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
58271: AND xet.event_class_code = C_EVENT_CLASS_CODE
58272: AND l2.event_id = xet.event_id

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

58401: l_balance_type_code VARCHAR2(1) :=NULL;
58402: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
58403:
58404: --
58405: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
58406: --
58407:
58408: TYPE t_array_source_87 IS TABLE OF PA_XLA_BC_BUDGET_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
58409: TYPE t_array_source_88 IS TABLE OF PA_XLA_BC_BUDGET_HEADER_V.GL_BUDGET_VERSION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 58521: , fnd_lookup_values fvl34

58517: , l2.BUDGET_LINE_ID source_89
58518: , l2.ENC_UPG_ENC_TYPE_ID source_90
58519: FROM xla_events_gt xet
58520: , PA_XLA_BC_BUDGET_LINES_V l2
58521: , fnd_lookup_values fvl34
58522: WHERE xet.event_id between x_first_event_id and x_last_event_id
58523: and xet.event_date between p_pad_start_date and p_pad_end_date
58524: and xet.event_class_code = C_EVENT_CLASS_CODE
58525: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 59503: , fnd_lookup_values fvl34

59499: ELSE null
59500: END source_meaning
59501: FROM xla_events_gt xet
59502: , PA_XLA_CDL_LINES_V l1
59503: , fnd_lookup_values fvl34
59504: , (select rownum r from all_objects where rownum <= 31 and owner = p_apps_owner)
59505: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
59506: AND xet.event_class_code = C_EVENT_CLASS_CODE
59507: AND l1.event_id = xet.event_id

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

59636: l_balance_type_code VARCHAR2(1) :=NULL;
59637: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
59638:
59639: --
59640: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
59641: --
59642:
59643: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
59644: TYPE t_array_source_87 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 59819: , fnd_lookup_values fvl34

59815: , l1.ENCUMBRANCE_TYPE_ID source_56
59816: , l1.PROJ_ENCUMBRANCE_TYPE_ID source_57
59817: FROM xla_events_gt xet
59818: , PA_XLA_CDL_LINES_V l1
59819: , fnd_lookup_values fvl34
59820: WHERE xet.event_id between x_first_event_id and x_last_event_id
59821: and xet.event_date between p_pad_start_date and p_pad_end_date
59822: and xet.event_class_code = C_EVENT_CLASS_CODE
59823: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 61066: , fnd_lookup_values fvl34

61062: ELSE null
61063: END source_meaning
61064: FROM xla_events_gt xet
61065: , PA_XLA_CDL_LINES_V l1
61066: , fnd_lookup_values fvl34
61067: , fnd_lookup_values fvl69
61068: , (select rownum r from all_objects where rownum <= 49 and owner = p_apps_owner)
61069: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
61070: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 61067: , fnd_lookup_values fvl69

61063: END source_meaning
61064: FROM xla_events_gt xet
61065: , PA_XLA_CDL_LINES_V l1
61066: , fnd_lookup_values fvl34
61067: , fnd_lookup_values fvl69
61068: , (select rownum r from all_objects where rownum <= 49 and owner = p_apps_owner)
61069: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
61070: AND xet.event_class_code = C_EVENT_CLASS_CODE
61071: AND l1.event_id = xet.event_id

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

61204: l_balance_type_code VARCHAR2(1) :=NULL;
61205: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
61206:
61207: --
61208: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
61209: --
61210:
61211: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
61212: TYPE t_array_source_37 IS TABLE OF PA_XLA_EXP_HEADER_V.SYSTEM_LINKAGE_FUNCTION%TYPE INDEX BY BINARY_INTEGER;

Line 61446: , fnd_lookup_values fvl34

61442: , l1.ENC_ACCT_ENABLED source_85
61443: , l1.LIQUIDATE_ENCUM_FLAG source_86
61444: FROM xla_events_gt xet
61445: , PA_XLA_CDL_LINES_V l1
61446: , fnd_lookup_values fvl34
61447: , fnd_lookup_values fvl69
61448: WHERE xet.event_id between x_first_event_id and x_last_event_id
61449: and xet.event_date between p_pad_start_date and p_pad_end_date
61450: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 61447: , fnd_lookup_values fvl69

61443: , l1.LIQUIDATE_ENCUM_FLAG source_86
61444: FROM xla_events_gt xet
61445: , PA_XLA_CDL_LINES_V l1
61446: , fnd_lookup_values fvl34
61447: , fnd_lookup_values fvl69
61448: WHERE xet.event_id between x_first_event_id and x_last_event_id
61449: and xet.event_date between p_pad_start_date and p_pad_end_date
61450: and xet.event_class_code = C_EVENT_CLASS_CODE
61451: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 62915: , fnd_lookup_values fvl34

62911: ELSE null
62912: END source_meaning
62913: FROM xla_events_gt xet
62914: , PA_XLA_CDL_LINES_V l1
62915: , fnd_lookup_values fvl34
62916: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
62917: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
62918: AND xet.event_class_code = C_EVENT_CLASS_CODE
62919: AND l1.event_id = xet.event_id

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

63048: l_balance_type_code VARCHAR2(1) :=NULL;
63049: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
63050:
63051: --
63052: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
63053: --
63054:
63055: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
63056: TYPE t_array_source_87 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 63192: , fnd_lookup_values fvl34

63188: , fvl34.meaning source_34_meaning
63189: , l1.LINE_NUM_REVERSED source_35
63190: FROM xla_events_gt xet
63191: , PA_XLA_CDL_LINES_V l1
63192: , fnd_lookup_values fvl34
63193: WHERE xet.event_id between x_first_event_id and x_last_event_id
63194: and xet.event_date between p_pad_start_date and p_pad_end_date
63195: and xet.event_class_code = C_EVENT_CLASS_CODE
63196: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 64213: , fnd_lookup_values fvl34

64209: ELSE null
64210: END source_meaning
64211: FROM xla_events_gt xet
64212: , PA_XLA_CDL_LINES_V l1
64213: , fnd_lookup_values fvl34
64214: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
64215: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
64216: AND xet.event_class_code = C_EVENT_CLASS_CODE
64217: AND l1.event_id = xet.event_id

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

64346: l_balance_type_code VARCHAR2(1) :=NULL;
64347: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
64348:
64349: --
64350: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
64351: --
64352:
64353: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
64354: TYPE t_array_source_87 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 64490: , fnd_lookup_values fvl34

64486: , fvl34.meaning source_34_meaning
64487: , l1.LINE_NUM_REVERSED source_35
64488: FROM xla_events_gt xet
64489: , PA_XLA_CDL_LINES_V l1
64490: , fnd_lookup_values fvl34
64491: WHERE xet.event_id between x_first_event_id and x_last_event_id
64492: and xet.event_date between p_pad_start_date and p_pad_end_date
64493: and xet.event_class_code = C_EVENT_CLASS_CODE
64494: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 65511: , fnd_lookup_values fvl34

65507: ELSE null
65508: END source_meaning
65509: FROM xla_events_gt xet
65510: , PA_XLA_CDL_LINES_V l1
65511: , fnd_lookup_values fvl34
65512: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
65513: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
65514: AND xet.event_class_code = C_EVENT_CLASS_CODE
65515: AND l1.event_id = xet.event_id

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

65644: l_balance_type_code VARCHAR2(1) :=NULL;
65645: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
65646:
65647: --
65648: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
65649: --
65650:
65651: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
65652: TYPE t_array_source_87 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 65788: , fnd_lookup_values fvl34

65784: , fvl34.meaning source_34_meaning
65785: , l1.LINE_NUM_REVERSED source_35
65786: FROM xla_events_gt xet
65787: , PA_XLA_CDL_LINES_V l1
65788: , fnd_lookup_values fvl34
65789: WHERE xet.event_id between x_first_event_id and x_last_event_id
65790: and xet.event_date between p_pad_start_date and p_pad_end_date
65791: and xet.event_class_code = C_EVENT_CLASS_CODE
65792: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 66809: , fnd_lookup_values fvl34

66805: ELSE null
66806: END source_meaning
66807: FROM xla_events_gt xet
66808: , PA_XLA_CDL_LINES_V l1
66809: , fnd_lookup_values fvl34
66810: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
66811: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
66812: AND xet.event_class_code = C_EVENT_CLASS_CODE
66813: AND l1.event_id = xet.event_id

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

66942: l_balance_type_code VARCHAR2(1) :=NULL;
66943: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
66944:
66945: --
66946: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
66947: --
66948:
66949: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
66950: TYPE t_array_source_87 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 67086: , fnd_lookup_values fvl34

67082: , fvl34.meaning source_34_meaning
67083: , l1.LINE_NUM_REVERSED source_35
67084: FROM xla_events_gt xet
67085: , PA_XLA_CDL_LINES_V l1
67086: , fnd_lookup_values fvl34
67087: WHERE xet.event_id between x_first_event_id and x_last_event_id
67088: and xet.event_date between p_pad_start_date and p_pad_end_date
67089: and xet.event_class_code = C_EVENT_CLASS_CODE
67090: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 68107: , fnd_lookup_values fvl34

68103: ELSE null
68104: END source_meaning
68105: FROM xla_events_gt xet
68106: , PA_XLA_CDL_LINES_V l1
68107: , fnd_lookup_values fvl34
68108: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
68109: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
68110: AND xet.event_class_code = C_EVENT_CLASS_CODE
68111: AND l1.event_id = xet.event_id

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

68240: l_balance_type_code VARCHAR2(1) :=NULL;
68241: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
68242:
68243: --
68244: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
68245: --
68246:
68247: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
68248: TYPE t_array_source_87 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 68384: , fnd_lookup_values fvl34

68380: , fvl34.meaning source_34_meaning
68381: , l1.LINE_NUM_REVERSED source_35
68382: FROM xla_events_gt xet
68383: , PA_XLA_CDL_LINES_V l1
68384: , fnd_lookup_values fvl34
68385: WHERE xet.event_id between x_first_event_id and x_last_event_id
68386: and xet.event_date between p_pad_start_date and p_pad_end_date
68387: and xet.event_class_code = C_EVENT_CLASS_CODE
68388: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 69405: , fnd_lookup_values fvl34

69401: ELSE null
69402: END source_meaning
69403: FROM xla_events_gt xet
69404: , PA_XLA_CDL_LINES_V l1
69405: , fnd_lookup_values fvl34
69406: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
69407: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
69408: AND xet.event_class_code = C_EVENT_CLASS_CODE
69409: AND l1.event_id = xet.event_id

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

69538: l_balance_type_code VARCHAR2(1) :=NULL;
69539: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
69540:
69541: --
69542: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
69543: --
69544:
69545: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
69546: TYPE t_array_source_87 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 69682: , fnd_lookup_values fvl34

69678: , fvl34.meaning source_34_meaning
69679: , l1.LINE_NUM_REVERSED source_35
69680: FROM xla_events_gt xet
69681: , PA_XLA_CDL_LINES_V l1
69682: , fnd_lookup_values fvl34
69683: WHERE xet.event_id between x_first_event_id and x_last_event_id
69684: and xet.event_date between p_pad_start_date and p_pad_end_date
69685: and xet.event_class_code = C_EVENT_CLASS_CODE
69686: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 70703: , fnd_lookup_values fvl34

70699: ELSE null
70700: END source_meaning
70701: FROM xla_events_gt xet
70702: , PA_XLA_CCDL_LINES_V l1
70703: , fnd_lookup_values fvl34
70704: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
70705: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
70706: AND xet.event_class_code = C_EVENT_CLASS_CODE
70707: AND l1.event_id = xet.event_id

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

70836: l_balance_type_code VARCHAR2(1) :=NULL;
70837: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
70838:
70839: --
70840: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
70841: --
70842:
70843: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
70844: TYPE t_array_source_87 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 70980: , fnd_lookup_values fvl34

70976: , l1.ENTERED_AMOUNT source_41
70977: , l1.ACCT_AMOUNT source_43
70978: FROM xla_events_gt xet
70979: , PA_XLA_CCDL_LINES_V l1
70980: , fnd_lookup_values fvl34
70981: WHERE xet.event_id between x_first_event_id and x_last_event_id
70982: and xet.event_date between p_pad_start_date and p_pad_end_date
70983: and xet.event_class_code = C_EVENT_CLASS_CODE
70984: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 72001: , fnd_lookup_values fvl34

71997: ELSE null
71998: END source_meaning
71999: FROM xla_events_gt xet
72000: , PA_XLA_CCDL_LINES_V l1
72001: , fnd_lookup_values fvl34
72002: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
72003: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
72004: AND xet.event_class_code = C_EVENT_CLASS_CODE
72005: AND l1.event_id = xet.event_id

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

72134: l_balance_type_code VARCHAR2(1) :=NULL;
72135: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
72136:
72137: --
72138: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
72139: --
72140:
72141: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
72142: TYPE t_array_source_87 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 72278: , fnd_lookup_values fvl34

72274: , l1.ENTERED_AMOUNT source_41
72275: , l1.ACCT_AMOUNT source_43
72276: FROM xla_events_gt xet
72277: , PA_XLA_CCDL_LINES_V l1
72278: , fnd_lookup_values fvl34
72279: WHERE xet.event_id between x_first_event_id and x_last_event_id
72280: and xet.event_date between p_pad_start_date and p_pad_end_date
72281: and xet.event_class_code = C_EVENT_CLASS_CODE
72282: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 73343: , fnd_lookup_values fvl58

73339: END source_meaning
73340: FROM xla_events_gt xet
73341: , PA_XLA_EVENT_TYPE_REF_V l1
73342: , PA_XLA_REVENUE_LINES_ADJ_V l3
73343: , fnd_lookup_values fvl58
73344: , (select rownum r from all_objects where rownum <= 23 and owner = p_apps_owner)
73345: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
73346: AND xet.event_class_code = C_EVENT_CLASS_CODE
73347: AND l3.event_id = xet.event_id

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

73476: l_balance_type_code VARCHAR2(1) :=NULL;
73477: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
73478:
73479: --
73480: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
73481: --
73482:
73483: TYPE t_array_source_38 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.CREDITING_REVENUE_FLAG%TYPE INDEX BY BINARY_INTEGER;
73484: TYPE t_array_source_42 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.EVENT_ID%TYPE INDEX BY BINARY_INTEGER;

Line 73645: , fnd_lookup_values fvl58

73641: , l3.PDR_DRAFT_REV_NUM_CREDITED source_66
73642: FROM xla_events_gt xet
73643: , PA_XLA_EVENT_TYPE_REF_V l1
73644: , PA_XLA_REVENUE_LINES_ADJ_V l3
73645: , fnd_lookup_values fvl58
73646: WHERE xet.event_id between x_first_event_id and x_last_event_id
73647: and xet.event_date between p_pad_start_date and p_pad_end_date
73648: and xet.event_class_code = C_EVENT_CLASS_CODE
73649: and xet.event_status_code <> 'N' AND l3.event_id = xet.event_id

Line 74855: , fnd_lookup_values fvl58

74851: END source_meaning
74852: FROM xla_events_gt xet
74853: , PA_XLA_EVENT_TYPE_REF_V l1
74854: , PA_XLA_REVENUE_LINES_V l3
74855: , fnd_lookup_values fvl58
74856: , (select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
74857: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
74858: AND xet.event_class_code = C_EVENT_CLASS_CODE
74859: AND l3.event_id = xet.event_id

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

74988: l_balance_type_code VARCHAR2(1) :=NULL;
74989: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
74990:
74991: --
74992: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
74993: --
74994:
74995: TYPE t_array_source_38 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.CREDITING_REVENUE_FLAG%TYPE INDEX BY BINARY_INTEGER;
74996: TYPE t_array_source_42 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.EVENT_ID%TYPE INDEX BY BINARY_INTEGER;

Line 75139: , fnd_lookup_values fvl58

75135: , fvl58.meaning source_58_meaning
75136: FROM xla_events_gt xet
75137: , PA_XLA_EVENT_TYPE_REF_V l1
75138: , PA_XLA_REVENUE_LINES_V l3
75139: , fnd_lookup_values fvl58
75140: WHERE xet.event_id between x_first_event_id and x_last_event_id
75141: and xet.event_date between p_pad_start_date and p_pad_end_date
75142: and xet.event_class_code = C_EVENT_CLASS_CODE
75143: and xet.event_status_code <> 'N' AND l3.event_id = xet.event_id

Line 76489: , fnd_lookup_values fvl34

76485: ELSE null
76486: END source_meaning
76487: FROM xla_events_gt xet
76488: , PA_XLA_CDL_LINES_V l1
76489: , fnd_lookup_values fvl34
76490: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
76491: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
76492: AND xet.event_class_code = C_EVENT_CLASS_CODE
76493: AND l1.event_id = xet.event_id

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

76622: l_balance_type_code VARCHAR2(1) :=NULL;
76623: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
76624:
76625: --
76626: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
76627: --
76628:
76629: TYPE t_array_source_21 IS TABLE OF PA_XLA_EXP_HEADER_V.EXCHANGE_RATE_VARIANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
76630: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;

Line 76769: , fnd_lookup_values fvl34

76765: , fvl34.meaning source_34_meaning
76766: , l1.LINE_NUM_REVERSED source_35
76767: FROM xla_events_gt xet
76768: , PA_XLA_CDL_LINES_V l1
76769: , fnd_lookup_values fvl34
76770: WHERE xet.event_id between x_first_event_id and x_last_event_id
76771: and xet.event_date between p_pad_start_date and p_pad_end_date
76772: and xet.event_class_code = C_EVENT_CLASS_CODE
76773: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 77884: , fnd_lookup_values fvl34

77880: ELSE null
77881: END source_meaning
77882: FROM xla_events_gt xet
77883: , PA_XLA_CDL_LINES_V l1
77884: , fnd_lookup_values fvl34
77885: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
77886: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
77887: AND xet.event_class_code = C_EVENT_CLASS_CODE
77888: AND l1.event_id = xet.event_id

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

78017: l_balance_type_code VARCHAR2(1) :=NULL;
78018: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
78019:
78020: --
78021: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
78022: --
78023:
78024: TYPE t_array_source_21 IS TABLE OF PA_XLA_EXP_HEADER_V.EXCHANGE_RATE_VARIANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
78025: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;

Line 78164: , fnd_lookup_values fvl34

78160: , fvl34.meaning source_34_meaning
78161: , l1.LINE_NUM_REVERSED source_35
78162: FROM xla_events_gt xet
78163: , PA_XLA_CDL_LINES_V l1
78164: , fnd_lookup_values fvl34
78165: WHERE xet.event_id between x_first_event_id and x_last_event_id
78166: and xet.event_date between p_pad_start_date and p_pad_end_date
78167: and xet.event_class_code = C_EVENT_CLASS_CODE
78168: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 79421: , fnd_lookup_values fvl34

79417: ELSE null
79418: END source_meaning
79419: FROM xla_events_gt xet
79420: , PA_XLA_CDL_LINES_V l1
79421: , fnd_lookup_values fvl34
79422: , fnd_lookup_values fvl69
79423: , (select rownum r from all_objects where rownum <= 48 and owner = p_apps_owner)
79424: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
79425: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 79422: , fnd_lookup_values fvl69

79418: END source_meaning
79419: FROM xla_events_gt xet
79420: , PA_XLA_CDL_LINES_V l1
79421: , fnd_lookup_values fvl34
79422: , fnd_lookup_values fvl69
79423: , (select rownum r from all_objects where rownum <= 48 and owner = p_apps_owner)
79424: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
79425: AND xet.event_class_code = C_EVENT_CLASS_CODE
79426: AND l1.event_id = xet.event_id

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

79559: l_balance_type_code VARCHAR2(1) :=NULL;
79560: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
79561:
79562: --
79563: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
79564: --
79565:
79566: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
79567: TYPE t_array_source_37 IS TABLE OF PA_XLA_EXP_HEADER_V.SYSTEM_LINKAGE_FUNCTION%TYPE INDEX BY BINARY_INTEGER;

Line 79798: , fnd_lookup_values fvl34

79794: , l1.ENC_ACCT_ENABLED source_85
79795: , l1.LIQUIDATE_ENCUM_FLAG source_86
79796: FROM xla_events_gt xet
79797: , PA_XLA_CDL_LINES_V l1
79798: , fnd_lookup_values fvl34
79799: , fnd_lookup_values fvl69
79800: WHERE xet.event_id between x_first_event_id and x_last_event_id
79801: and xet.event_date between p_pad_start_date and p_pad_end_date
79802: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 79799: , fnd_lookup_values fvl69

79795: , l1.LIQUIDATE_ENCUM_FLAG source_86
79796: FROM xla_events_gt xet
79797: , PA_XLA_CDL_LINES_V l1
79798: , fnd_lookup_values fvl34
79799: , fnd_lookup_values fvl69
79800: WHERE xet.event_id between x_first_event_id and x_last_event_id
79801: and xet.event_date between p_pad_start_date and p_pad_end_date
79802: and xet.event_class_code = C_EVENT_CLASS_CODE
79803: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 81414: , fnd_lookup_values fvl34

81410: ELSE null
81411: END source_meaning
81412: FROM xla_events_gt xet
81413: , PA_XLA_CDL_LINES_V l1
81414: , fnd_lookup_values fvl34
81415: , fnd_lookup_values fvl69
81416: , (select rownum r from all_objects where rownum <= 49 and owner = p_apps_owner)
81417: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
81418: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 81415: , fnd_lookup_values fvl69

81411: END source_meaning
81412: FROM xla_events_gt xet
81413: , PA_XLA_CDL_LINES_V l1
81414: , fnd_lookup_values fvl34
81415: , fnd_lookup_values fvl69
81416: , (select rownum r from all_objects where rownum <= 49 and owner = p_apps_owner)
81417: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
81418: AND xet.event_class_code = C_EVENT_CLASS_CODE
81419: AND l1.event_id = xet.event_id

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

81552: l_balance_type_code VARCHAR2(1) :=NULL;
81553: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
81554:
81555: --
81556: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
81557: --
81558:
81559: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
81560: TYPE t_array_source_37 IS TABLE OF PA_XLA_EXP_HEADER_V.SYSTEM_LINKAGE_FUNCTION%TYPE INDEX BY BINARY_INTEGER;

Line 81794: , fnd_lookup_values fvl34

81790: , l1.ENC_ACCT_ENABLED source_85
81791: , l1.LIQUIDATE_ENCUM_FLAG source_86
81792: FROM xla_events_gt xet
81793: , PA_XLA_CDL_LINES_V l1
81794: , fnd_lookup_values fvl34
81795: , fnd_lookup_values fvl69
81796: WHERE xet.event_id between x_first_event_id and x_last_event_id
81797: and xet.event_date between p_pad_start_date and p_pad_end_date
81798: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 81795: , fnd_lookup_values fvl69

81791: , l1.LIQUIDATE_ENCUM_FLAG source_86
81792: FROM xla_events_gt xet
81793: , PA_XLA_CDL_LINES_V l1
81794: , fnd_lookup_values fvl34
81795: , fnd_lookup_values fvl69
81796: WHERE xet.event_id between x_first_event_id and x_last_event_id
81797: and xet.event_date between p_pad_start_date and p_pad_end_date
81798: and xet.event_class_code = C_EVENT_CLASS_CODE
81799: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 83276: , fnd_lookup_values fvl34

83272: ELSE null
83273: END source_meaning
83274: FROM xla_events_gt xet
83275: , PA_XLA_CDL_LINES_V l1
83276: , fnd_lookup_values fvl34
83277: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
83278: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
83279: AND xet.event_class_code = C_EVENT_CLASS_CODE
83280: AND l1.event_id = xet.event_id

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

83409: l_balance_type_code VARCHAR2(1) :=NULL;
83410: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
83411:
83412: --
83413: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
83414: --
83415:
83416: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
83417: TYPE t_array_source_87 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 83553: , fnd_lookup_values fvl34

83549: , fvl34.meaning source_34_meaning
83550: , l1.LINE_NUM_REVERSED source_35
83551: FROM xla_events_gt xet
83552: , PA_XLA_CDL_LINES_V l1
83553: , fnd_lookup_values fvl34
83554: WHERE xet.event_id between x_first_event_id and x_last_event_id
83555: and xet.event_date between p_pad_start_date and p_pad_end_date
83556: and xet.event_class_code = C_EVENT_CLASS_CODE
83557: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 84574: , fnd_lookup_values fvl34

84570: ELSE null
84571: END source_meaning
84572: FROM xla_events_gt xet
84573: , PA_XLA_CDL_LINES_V l1
84574: , fnd_lookup_values fvl34
84575: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
84576: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
84577: AND xet.event_class_code = C_EVENT_CLASS_CODE
84578: AND l1.event_id = xet.event_id

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

84707: l_balance_type_code VARCHAR2(1) :=NULL;
84708: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
84709:
84710: --
84711: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
84712: --
84713:
84714: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
84715: TYPE t_array_source_87 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 84851: , fnd_lookup_values fvl34

84847: , fvl34.meaning source_34_meaning
84848: , l1.LINE_NUM_REVERSED source_35
84849: FROM xla_events_gt xet
84850: , PA_XLA_CDL_LINES_V l1
84851: , fnd_lookup_values fvl34
84852: WHERE xet.event_id between x_first_event_id and x_last_event_id
84853: and xet.event_date between p_pad_start_date and p_pad_end_date
84854: and xet.event_class_code = C_EVENT_CLASS_CODE
84855: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 85872: , fnd_lookup_values fvl34

85868: ELSE null
85869: END source_meaning
85870: FROM xla_events_gt xet
85871: , PA_XLA_CDL_LINES_V l1
85872: , fnd_lookup_values fvl34
85873: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
85874: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
85875: AND xet.event_class_code = C_EVENT_CLASS_CODE
85876: AND l1.event_id = xet.event_id

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

86005: l_balance_type_code VARCHAR2(1) :=NULL;
86006: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
86007:
86008: --
86009: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
86010: --
86011:
86012: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
86013: TYPE t_array_source_87 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 86149: , fnd_lookup_values fvl34

86145: , fvl34.meaning source_34_meaning
86146: , l1.LINE_NUM_REVERSED source_35
86147: FROM xla_events_gt xet
86148: , PA_XLA_CDL_LINES_V l1
86149: , fnd_lookup_values fvl34
86150: WHERE xet.event_id between x_first_event_id and x_last_event_id
86151: and xet.event_date between p_pad_start_date and p_pad_end_date
86152: and xet.event_class_code = C_EVENT_CLASS_CODE
86153: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 87170: , fnd_lookup_values fvl34

87166: ELSE null
87167: END source_meaning
87168: FROM xla_events_gt xet
87169: , PA_XLA_CDL_LINES_V l1
87170: , fnd_lookup_values fvl34
87171: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
87172: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
87173: AND xet.event_class_code = C_EVENT_CLASS_CODE
87174: AND l1.event_id = xet.event_id

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

87303: l_balance_type_code VARCHAR2(1) :=NULL;
87304: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
87305:
87306: --
87307: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
87308: --
87309:
87310: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
87311: TYPE t_array_source_87 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 87447: , fnd_lookup_values fvl34

87443: , fvl34.meaning source_34_meaning
87444: , l1.LINE_NUM_REVERSED source_35
87445: FROM xla_events_gt xet
87446: , PA_XLA_CDL_LINES_V l1
87447: , fnd_lookup_values fvl34
87448: WHERE xet.event_id between x_first_event_id and x_last_event_id
87449: and xet.event_date between p_pad_start_date and p_pad_end_date
87450: and xet.event_class_code = C_EVENT_CLASS_CODE
87451: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id