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_000015_PKG dependencies on PA_XLA_EXP_HEADER_V

Line 74037: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'

74033: FROM (
74034: SELECT xet.event_id event_id
74035: , 0 line_number
74036: , CASE r
74037: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
74038: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
74039: WHEN 3 THEN 'PA_XLA_EXP_HEADER_V'
74040:
74041: ELSE null

Line 74038: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'

74034: SELECT xet.event_id event_id
74035: , 0 line_number
74036: , CASE r
74037: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
74038: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
74039: WHEN 3 THEN 'PA_XLA_EXP_HEADER_V'
74040:
74041: ELSE null
74042: END object_name

Line 74039: WHEN 3 THEN 'PA_XLA_EXP_HEADER_V'

74035: , 0 line_number
74036: , CASE r
74037: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
74038: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
74039: WHEN 3 THEN 'PA_XLA_EXP_HEADER_V'
74040:
74041: ELSE null
74042: END object_name
74043: , CASE r

Line 74078: , PA_XLA_EXP_HEADER_V h2

74074:
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

Line 74417: TYPE t_array_source_33 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;

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;
74419: TYPE t_array_source_75 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
74420:
74421: TYPE t_array_source_5 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 74418: TYPE t_array_source_73 IS TABLE OF PA_XLA_EXP_HEADER_V.TP_AMT_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

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;
74419: TYPE t_array_source_75 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
74420:
74421: TYPE t_array_source_5 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
74422: TYPE t_array_source_9 IS TABLE OF PA_XLA_CCDL_LINES_V.PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 74419: TYPE t_array_source_75 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%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;
74419: TYPE t_array_source_75 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
74420:
74421: TYPE t_array_source_5 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
74422: TYPE t_array_source_9 IS TABLE OF PA_XLA_CCDL_LINES_V.PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
74423: TYPE t_array_source_10 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 74499: , PA_XLA_EXP_HEADER_V h2

74495: , h2.TP_AMT_TYPE_CODE source_73
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

Line 75445: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'

75441: FROM (
75442: SELECT xet.event_id event_id
75443: , 0 line_number
75444: , CASE r
75445: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
75446: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
75447: WHEN 3 THEN 'PA_XLA_EXP_HEADER_V'
75448:
75449: ELSE null

Line 75446: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'

75442: SELECT xet.event_id event_id
75443: , 0 line_number
75444: , CASE r
75445: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
75446: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
75447: WHEN 3 THEN 'PA_XLA_EXP_HEADER_V'
75448:
75449: ELSE null
75450: END object_name

Line 75447: WHEN 3 THEN 'PA_XLA_EXP_HEADER_V'

75443: , 0 line_number
75444: , CASE r
75445: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
75446: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
75447: WHEN 3 THEN 'PA_XLA_EXP_HEADER_V'
75448:
75449: ELSE null
75450: END object_name
75451: , CASE r

Line 75486: , PA_XLA_EXP_HEADER_V h2

75482:
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

Line 75825: TYPE t_array_source_33 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;

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;
75827: TYPE t_array_source_75 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
75828:
75829: TYPE t_array_source_5 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 75826: TYPE t_array_source_73 IS TABLE OF PA_XLA_EXP_HEADER_V.TP_AMT_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

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;
75827: TYPE t_array_source_75 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
75828:
75829: TYPE t_array_source_5 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
75830: TYPE t_array_source_9 IS TABLE OF PA_XLA_CCDL_LINES_V.PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 75827: TYPE t_array_source_75 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%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;
75827: TYPE t_array_source_75 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
75828:
75829: TYPE t_array_source_5 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
75830: TYPE t_array_source_9 IS TABLE OF PA_XLA_CCDL_LINES_V.PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
75831: TYPE t_array_source_10 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 75907: , PA_XLA_EXP_HEADER_V h2

75903: , h2.TP_AMT_TYPE_CODE source_73
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

Line 78190: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'

78186: FROM (
78187: SELECT xet.event_id event_id
78188: , 0 line_number
78189: , CASE r
78190: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
78191: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
78192:
78193: ELSE null
78194: END object_name

Line 78191: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'

78187: SELECT xet.event_id event_id
78188: , 0 line_number
78189: , CASE r
78190: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
78191: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
78192:
78193: ELSE null
78194: END object_name
78195: , CASE r

Line 78222: , PA_XLA_EXP_HEADER_V h2

78218: ELSE null
78219: END source_value
78220: , null source_meaning
78221: FROM xla_events_gt xet
78222: , PA_XLA_EXP_HEADER_V h2
78223: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
78224: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
78225: AND xet.event_class_code = C_EVENT_CLASS_CODE
78226: AND h2.event_id = xet.event_id

Line 78621: TYPE t_array_source_33 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;

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;
78623:
78624: TYPE t_array_source_3 IS TABLE OF PA_XLA_CDL_LINES_V.BUDGET_CCID%TYPE INDEX BY BINARY_INTEGER;
78625: TYPE t_array_source_4 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 78622: TYPE t_array_source_75 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

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;
78623:
78624: TYPE t_array_source_3 IS TABLE OF PA_XLA_CDL_LINES_V.BUDGET_CCID%TYPE INDEX BY BINARY_INTEGER;
78625: TYPE t_array_source_4 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;
78626: TYPE t_array_source_5 IS TABLE OF PA_XLA_CDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 78724: , PA_XLA_EXP_HEADER_V h2

78720: ,xet.budgetary_control_flag
78721: , h2.EXPENDITURE_ITEM_ID source_33
78722: , h2.GL_DATE source_75
78723: FROM xla_events_gt xet
78724: , PA_XLA_EXP_HEADER_V h2
78725: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
78726: and xet.event_class_code = C_EVENT_CLASS_CODE
78727: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
78728:

Line 79757: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'

79753: FROM (
79754: SELECT xet.event_id event_id
79755: , 0 line_number
79756: , CASE r
79757: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
79758: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
79759:
79760: ELSE null
79761: END object_name

Line 79758: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'

79754: SELECT xet.event_id event_id
79755: , 0 line_number
79756: , CASE r
79757: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
79758: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
79759:
79760: ELSE null
79761: END object_name
79762: , CASE r

Line 79789: , PA_XLA_EXP_HEADER_V h2

79785: ELSE null
79786: END source_value
79787: , null source_meaning
79788: FROM xla_events_gt xet
79789: , PA_XLA_EXP_HEADER_V h2
79790: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
79791: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
79792: AND xet.event_class_code = C_EVENT_CLASS_CODE
79793: AND h2.event_id = xet.event_id

Line 80188: TYPE t_array_source_33 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;

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;
80190:
80191: TYPE t_array_source_3 IS TABLE OF PA_XLA_CDL_LINES_V.BUDGET_CCID%TYPE INDEX BY BINARY_INTEGER;
80192: TYPE t_array_source_4 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 80189: TYPE t_array_source_75 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

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;
80190:
80191: TYPE t_array_source_3 IS TABLE OF PA_XLA_CDL_LINES_V.BUDGET_CCID%TYPE INDEX BY BINARY_INTEGER;
80192: TYPE t_array_source_4 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;
80193: TYPE t_array_source_5 IS TABLE OF PA_XLA_CDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 80291: , PA_XLA_EXP_HEADER_V h2

80287: ,xet.budgetary_control_flag
80288: , h2.EXPENDITURE_ITEM_ID source_33
80289: , h2.GL_DATE source_75
80290: FROM xla_events_gt xet
80291: , PA_XLA_EXP_HEADER_V h2
80292: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
80293: and xet.event_class_code = C_EVENT_CLASS_CODE
80294: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
80295:

Line 81324: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'

81320: FROM (
81321: SELECT xet.event_id event_id
81322: , 0 line_number
81323: , CASE r
81324: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
81325: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
81326:
81327: ELSE null
81328: END object_name

Line 81325: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'

81321: SELECT xet.event_id event_id
81322: , 0 line_number
81323: , CASE r
81324: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
81325: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
81326:
81327: ELSE null
81328: END object_name
81329: , CASE r

Line 81356: , PA_XLA_EXP_HEADER_V h2

81352: ELSE null
81353: END source_value
81354: , null source_meaning
81355: FROM xla_events_gt xet
81356: , PA_XLA_EXP_HEADER_V h2
81357: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
81358: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
81359: AND xet.event_class_code = C_EVENT_CLASS_CODE
81360: AND h2.event_id = xet.event_id

Line 81690: TYPE t_array_source_33 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;

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;
81692:
81693: TYPE t_array_source_4 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;
81694: TYPE t_array_source_5 IS TABLE OF PA_XLA_CDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 81691: TYPE t_array_source_75 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

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;
81692:
81693: TYPE t_array_source_4 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;
81694: TYPE t_array_source_5 IS TABLE OF PA_XLA_CDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
81695: TYPE t_array_source_6 IS TABLE OF PA_XLA_CDL_LINES_V.ADJ_COST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 81767: , PA_XLA_EXP_HEADER_V h2

81763: ,xet.budgetary_control_flag
81764: , h2.EXPENDITURE_ITEM_ID source_33
81765: , h2.GL_DATE source_75
81766: FROM xla_events_gt xet
81767: , PA_XLA_EXP_HEADER_V h2
81768: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
81769: and xet.event_class_code = C_EVENT_CLASS_CODE
81770: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
81771:

Line 82696: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'

82692: FROM (
82693: SELECT xet.event_id event_id
82694: , 0 line_number
82695: , CASE r
82696: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
82697: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
82698:
82699: ELSE null
82700: END object_name

Line 82697: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'

82693: SELECT xet.event_id event_id
82694: , 0 line_number
82695: , CASE r
82696: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
82697: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
82698:
82699: ELSE null
82700: END object_name
82701: , CASE r

Line 82728: , PA_XLA_EXP_HEADER_V h2

82724: ELSE null
82725: END source_value
82726: , null source_meaning
82727: FROM xla_events_gt xet
82728: , PA_XLA_EXP_HEADER_V h2
82729: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
82730: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
82731: AND xet.event_class_code = C_EVENT_CLASS_CODE
82732: AND h2.event_id = xet.event_id

Line 83062: TYPE t_array_source_33 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;

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;
83064:
83065: TYPE t_array_source_4 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;
83066: TYPE t_array_source_5 IS TABLE OF PA_XLA_CDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 83063: TYPE t_array_source_75 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

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;
83064:
83065: TYPE t_array_source_4 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;
83066: TYPE t_array_source_5 IS TABLE OF PA_XLA_CDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
83067: TYPE t_array_source_6 IS TABLE OF PA_XLA_CDL_LINES_V.ADJ_COST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 83139: , PA_XLA_EXP_HEADER_V h2

83135: ,xet.budgetary_control_flag
83136: , h2.EXPENDITURE_ITEM_ID source_33
83137: , h2.GL_DATE source_75
83138: FROM xla_events_gt xet
83139: , PA_XLA_EXP_HEADER_V h2
83140: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
83141: and xet.event_class_code = C_EVENT_CLASS_CODE
83142: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
83143:

Line 84068: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'

84064: FROM (
84065: SELECT xet.event_id event_id
84066: , 0 line_number
84067: , CASE r
84068: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
84069: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
84070:
84071: ELSE null
84072: END object_name

Line 84069: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'

84065: SELECT xet.event_id event_id
84066: , 0 line_number
84067: , CASE r
84068: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
84069: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
84070:
84071: ELSE null
84072: END object_name
84073: , CASE r

Line 84100: , PA_XLA_EXP_HEADER_V h2

84096: ELSE null
84097: END source_value
84098: , null source_meaning
84099: FROM xla_events_gt xet
84100: , PA_XLA_EXP_HEADER_V h2
84101: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
84102: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
84103: AND xet.event_class_code = C_EVENT_CLASS_CODE
84104: AND h2.event_id = xet.event_id

Line 84434: TYPE t_array_source_33 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;

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;
84436:
84437: TYPE t_array_source_4 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;
84438: TYPE t_array_source_5 IS TABLE OF PA_XLA_CDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 84435: TYPE t_array_source_75 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

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;
84436:
84437: TYPE t_array_source_4 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;
84438: TYPE t_array_source_5 IS TABLE OF PA_XLA_CDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
84439: TYPE t_array_source_6 IS TABLE OF PA_XLA_CDL_LINES_V.ADJ_COST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 84511: , PA_XLA_EXP_HEADER_V h2

84507: ,xet.budgetary_control_flag
84508: , h2.EXPENDITURE_ITEM_ID source_33
84509: , h2.GL_DATE source_75
84510: FROM xla_events_gt xet
84511: , PA_XLA_EXP_HEADER_V h2
84512: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
84513: and xet.event_class_code = C_EVENT_CLASS_CODE
84514: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
84515:

Line 85440: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'

85436: FROM (
85437: SELECT xet.event_id event_id
85438: , 0 line_number
85439: , CASE r
85440: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
85441: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
85442:
85443: ELSE null
85444: END object_name

Line 85441: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'

85437: SELECT xet.event_id event_id
85438: , 0 line_number
85439: , CASE r
85440: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
85441: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
85442:
85443: ELSE null
85444: END object_name
85445: , CASE r

Line 85472: , PA_XLA_EXP_HEADER_V h2

85468: ELSE null
85469: END source_value
85470: , null source_meaning
85471: FROM xla_events_gt xet
85472: , PA_XLA_EXP_HEADER_V h2
85473: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
85474: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
85475: AND xet.event_class_code = C_EVENT_CLASS_CODE
85476: AND h2.event_id = xet.event_id

Line 85806: TYPE t_array_source_33 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;

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;
85808:
85809: TYPE t_array_source_4 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;
85810: TYPE t_array_source_5 IS TABLE OF PA_XLA_CDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 85807: TYPE t_array_source_75 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

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;
85808:
85809: TYPE t_array_source_4 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;
85810: TYPE t_array_source_5 IS TABLE OF PA_XLA_CDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
85811: TYPE t_array_source_6 IS TABLE OF PA_XLA_CDL_LINES_V.ADJ_COST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 85883: , PA_XLA_EXP_HEADER_V h2

85879: ,xet.budgetary_control_flag
85880: , h2.EXPENDITURE_ITEM_ID source_33
85881: , h2.GL_DATE source_75
85882: FROM xla_events_gt xet
85883: , PA_XLA_EXP_HEADER_V h2
85884: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
85885: and xet.event_class_code = C_EVENT_CLASS_CODE
85886: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
85887:

Line 86812: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'

86808: FROM (
86809: SELECT xet.event_id event_id
86810: , 0 line_number
86811: , CASE r
86812: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
86813: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
86814:
86815: ELSE null
86816: END object_name

Line 86813: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'

86809: SELECT xet.event_id event_id
86810: , 0 line_number
86811: , CASE r
86812: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
86813: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
86814:
86815: ELSE null
86816: END object_name
86817: , CASE r

Line 86844: , PA_XLA_EXP_HEADER_V h2

86840: ELSE null
86841: END source_value
86842: , null source_meaning
86843: FROM xla_events_gt xet
86844: , PA_XLA_EXP_HEADER_V h2
86845: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
86846: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
86847: AND xet.event_class_code = C_EVENT_CLASS_CODE
86848: AND h2.event_id = xet.event_id

Line 87178: TYPE t_array_source_33 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;

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;
87180:
87181: TYPE t_array_source_4 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;
87182: TYPE t_array_source_5 IS TABLE OF PA_XLA_CDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 87179: TYPE t_array_source_75 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

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;
87180:
87181: TYPE t_array_source_4 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;
87182: TYPE t_array_source_5 IS TABLE OF PA_XLA_CDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
87183: TYPE t_array_source_6 IS TABLE OF PA_XLA_CDL_LINES_V.ADJ_COST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 87255: , PA_XLA_EXP_HEADER_V h2

87251: ,xet.budgetary_control_flag
87252: , h2.EXPENDITURE_ITEM_ID source_33
87253: , h2.GL_DATE source_75
87254: FROM xla_events_gt xet
87255: , PA_XLA_EXP_HEADER_V h2
87256: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
87257: and xet.event_class_code = C_EVENT_CLASS_CODE
87258: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
87259:

Line 88184: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'

88180: FROM (
88181: SELECT xet.event_id event_id
88182: , 0 line_number
88183: , CASE r
88184: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
88185: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
88186:
88187: ELSE null
88188: END object_name

Line 88185: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'

88181: SELECT xet.event_id event_id
88182: , 0 line_number
88183: , CASE r
88184: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
88185: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
88186:
88187: ELSE null
88188: END object_name
88189: , CASE r

Line 88216: , PA_XLA_EXP_HEADER_V h2

88212: ELSE null
88213: END source_value
88214: , null source_meaning
88215: FROM xla_events_gt xet
88216: , PA_XLA_EXP_HEADER_V h2
88217: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
88218: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
88219: AND xet.event_class_code = C_EVENT_CLASS_CODE
88220: AND h2.event_id = xet.event_id

Line 88550: TYPE t_array_source_33 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;

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;
88552:
88553: TYPE t_array_source_4 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;
88554: TYPE t_array_source_5 IS TABLE OF PA_XLA_CDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 88551: TYPE t_array_source_75 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

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;
88552:
88553: TYPE t_array_source_4 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;
88554: TYPE t_array_source_5 IS TABLE OF PA_XLA_CDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
88555: TYPE t_array_source_6 IS TABLE OF PA_XLA_CDL_LINES_V.ADJ_COST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 88627: , PA_XLA_EXP_HEADER_V h2

88623: ,xet.budgetary_control_flag
88624: , h2.EXPENDITURE_ITEM_ID source_33
88625: , h2.GL_DATE source_75
88626: FROM xla_events_gt xet
88627: , PA_XLA_EXP_HEADER_V h2
88628: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
88629: and xet.event_class_code = C_EVENT_CLASS_CODE
88630: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
88631:

Line 89556: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'

89552: FROM (
89553: SELECT xet.event_id event_id
89554: , 0 line_number
89555: , CASE r
89556: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
89557: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
89558:
89559: ELSE null
89560: END object_name

Line 89557: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'

89553: SELECT xet.event_id event_id
89554: , 0 line_number
89555: , CASE r
89556: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
89557: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
89558:
89559: ELSE null
89560: END object_name
89561: , CASE r

Line 89588: , PA_XLA_EXP_HEADER_V h2

89584: ELSE null
89585: END source_value
89586: , null source_meaning
89587: FROM xla_events_gt xet
89588: , PA_XLA_EXP_HEADER_V h2
89589: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
89590: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
89591: AND xet.event_class_code = C_EVENT_CLASS_CODE
89592: AND h2.event_id = xet.event_id

Line 89922: TYPE t_array_source_33 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;

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;
89924:
89925: TYPE t_array_source_5 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
89926: TYPE t_array_source_12 IS TABLE OF PA_XLA_CCDL_LINES_V.DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 89923: TYPE t_array_source_75 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

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;
89924:
89925: TYPE t_array_source_5 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
89926: TYPE t_array_source_12 IS TABLE OF PA_XLA_CCDL_LINES_V.DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
89927: TYPE t_array_source_13 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 89999: , PA_XLA_EXP_HEADER_V h2

89995: ,xet.budgetary_control_flag
89996: , h2.EXPENDITURE_ITEM_ID source_33
89997: , h2.GL_DATE source_75
89998: FROM xla_events_gt xet
89999: , PA_XLA_EXP_HEADER_V h2
90000: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
90001: and xet.event_class_code = C_EVENT_CLASS_CODE
90002: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
90003:

Line 90854: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'

90850: FROM (
90851: SELECT xet.event_id event_id
90852: , 0 line_number
90853: , CASE r
90854: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
90855: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
90856:
90857: ELSE null
90858: END object_name

Line 90855: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'

90851: SELECT xet.event_id event_id
90852: , 0 line_number
90853: , CASE r
90854: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
90855: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
90856:
90857: ELSE null
90858: END object_name
90859: , CASE r

Line 90886: , PA_XLA_EXP_HEADER_V h2

90882: ELSE null
90883: END source_value
90884: , null source_meaning
90885: FROM xla_events_gt xet
90886: , PA_XLA_EXP_HEADER_V h2
90887: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
90888: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
90889: AND xet.event_class_code = C_EVENT_CLASS_CODE
90890: AND h2.event_id = xet.event_id

Line 91220: TYPE t_array_source_33 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;

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;
91222:
91223: TYPE t_array_source_5 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
91224: TYPE t_array_source_12 IS TABLE OF PA_XLA_CCDL_LINES_V.DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 91221: TYPE t_array_source_75 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

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;
91222:
91223: TYPE t_array_source_5 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
91224: TYPE t_array_source_12 IS TABLE OF PA_XLA_CCDL_LINES_V.DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
91225: TYPE t_array_source_13 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 91297: , PA_XLA_EXP_HEADER_V h2

91293: ,xet.budgetary_control_flag
91294: , h2.EXPENDITURE_ITEM_ID source_33
91295: , h2.GL_DATE source_75
91296: FROM xla_events_gt xet
91297: , PA_XLA_EXP_HEADER_V h2
91298: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
91299: and xet.event_class_code = C_EVENT_CLASS_CODE
91300: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
91301:

Line 95695: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'

95691: SELECT xet.event_id event_id
95692: , 0 line_number
95693: , CASE r
95694: WHEN 1 THEN 'GMS_XLA_AWARD_REF_V'
95695: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
95696: WHEN 3 THEN 'PA_XLA_EXP_HEADER_V'
95697: WHEN 4 THEN 'PA_XLA_EXP_HEADER_V'
95698:
95699: ELSE null

Line 95696: WHEN 3 THEN 'PA_XLA_EXP_HEADER_V'

95692: , 0 line_number
95693: , CASE r
95694: WHEN 1 THEN 'GMS_XLA_AWARD_REF_V'
95695: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
95696: WHEN 3 THEN 'PA_XLA_EXP_HEADER_V'
95697: WHEN 4 THEN 'PA_XLA_EXP_HEADER_V'
95698:
95699: ELSE null
95700: END object_name

Line 95697: WHEN 4 THEN 'PA_XLA_EXP_HEADER_V'

95693: , CASE r
95694: WHEN 1 THEN 'GMS_XLA_AWARD_REF_V'
95695: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
95696: WHEN 3 THEN 'PA_XLA_EXP_HEADER_V'
95697: WHEN 4 THEN 'PA_XLA_EXP_HEADER_V'
95698:
95699: ELSE null
95700: END object_name
95701: , CASE r

Line 95746: , PA_XLA_EXP_HEADER_V h3

95742: ELSE null
95743: END source_meaning
95744: FROM xla_events_gt xet
95745: , GMS_XLA_AWARD_REF_V h1
95746: , PA_XLA_EXP_HEADER_V h3
95747: ,(select rownum r from all_objects where rownum <= 4 and owner = p_apps_owner)
95748: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
95749: AND xet.event_class_code = C_EVENT_CLASS_CODE
95750: AND h3.event_id = xet.event_id

Line 96081: TYPE t_array_source_22 IS TABLE OF PA_XLA_EXP_HEADER_V.EXCHANGE_RATE_VARIANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;

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;
96082: TYPE t_array_source_33 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
96083: TYPE t_array_source_75 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
96084:
96085: TYPE t_array_source_4 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 96082: TYPE t_array_source_33 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%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;
96082: TYPE t_array_source_33 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
96083: TYPE t_array_source_75 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
96084:
96085: TYPE t_array_source_4 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;
96086: TYPE t_array_source_5 IS TABLE OF PA_XLA_CDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 96083: TYPE t_array_source_75 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

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;
96082: TYPE t_array_source_33 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
96083: TYPE t_array_source_75 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
96084:
96085: TYPE t_array_source_4 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;
96086: TYPE t_array_source_5 IS TABLE OF PA_XLA_CDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
96087: TYPE t_array_source_6 IS TABLE OF PA_XLA_CDL_LINES_V.ADJ_COST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 96164: , PA_XLA_EXP_HEADER_V h3

96160: , h3.EXPENDITURE_ITEM_ID source_33
96161: , h3.GL_DATE source_75
96162: FROM xla_events_gt xet
96163: , GMS_XLA_AWARD_REF_V h1
96164: , PA_XLA_EXP_HEADER_V h3
96165: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
96166: and xet.event_class_code = C_EVENT_CLASS_CODE
96167: and xet.event_status_code <> 'N' AND h3.event_id = xet.event_id
96168: AND h1.expenditure_item_id (+) =h3.expenditure_item_id AND h1.document_type (+) = 'EXP'

Line 97256: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'

97252: SELECT xet.event_id event_id
97253: , 0 line_number
97254: , CASE r
97255: WHEN 1 THEN 'GMS_XLA_AWARD_REF_V'
97256: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
97257: WHEN 3 THEN 'PA_XLA_EXP_HEADER_V'
97258: WHEN 4 THEN 'PA_XLA_EXP_HEADER_V'
97259:
97260: ELSE null

Line 97257: WHEN 3 THEN 'PA_XLA_EXP_HEADER_V'

97253: , 0 line_number
97254: , CASE r
97255: WHEN 1 THEN 'GMS_XLA_AWARD_REF_V'
97256: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
97257: WHEN 3 THEN 'PA_XLA_EXP_HEADER_V'
97258: WHEN 4 THEN 'PA_XLA_EXP_HEADER_V'
97259:
97260: ELSE null
97261: END object_name

Line 97258: WHEN 4 THEN 'PA_XLA_EXP_HEADER_V'

97254: , CASE r
97255: WHEN 1 THEN 'GMS_XLA_AWARD_REF_V'
97256: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
97257: WHEN 3 THEN 'PA_XLA_EXP_HEADER_V'
97258: WHEN 4 THEN 'PA_XLA_EXP_HEADER_V'
97259:
97260: ELSE null
97261: END object_name
97262: , CASE r

Line 97307: , PA_XLA_EXP_HEADER_V h3

97303: ELSE null
97304: END source_meaning
97305: FROM xla_events_gt xet
97306: , GMS_XLA_AWARD_REF_V h1
97307: , PA_XLA_EXP_HEADER_V h3
97308: ,(select rownum r from all_objects where rownum <= 4 and owner = p_apps_owner)
97309: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
97310: AND xet.event_class_code = C_EVENT_CLASS_CODE
97311: AND h3.event_id = xet.event_id

Line 97642: TYPE t_array_source_22 IS TABLE OF PA_XLA_EXP_HEADER_V.EXCHANGE_RATE_VARIANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;

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;
97643: TYPE t_array_source_33 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
97644: TYPE t_array_source_75 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
97645:
97646: TYPE t_array_source_4 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 97643: TYPE t_array_source_33 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%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;
97643: TYPE t_array_source_33 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
97644: TYPE t_array_source_75 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
97645:
97646: TYPE t_array_source_4 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;
97647: TYPE t_array_source_5 IS TABLE OF PA_XLA_CDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 97644: TYPE t_array_source_75 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

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;
97643: TYPE t_array_source_33 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
97644: TYPE t_array_source_75 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
97645:
97646: TYPE t_array_source_4 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;
97647: TYPE t_array_source_5 IS TABLE OF PA_XLA_CDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
97648: TYPE t_array_source_6 IS TABLE OF PA_XLA_CDL_LINES_V.ADJ_COST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 97725: , PA_XLA_EXP_HEADER_V h3

97721: , h3.EXPENDITURE_ITEM_ID source_33
97722: , h3.GL_DATE source_75
97723: FROM xla_events_gt xet
97724: , GMS_XLA_AWARD_REF_V h1
97725: , PA_XLA_EXP_HEADER_V h3
97726: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
97727: and xet.event_class_code = C_EVENT_CLASS_CODE
97728: and xet.event_status_code <> 'N' AND h3.event_id = xet.event_id
97729: AND h1.expenditure_item_id (+) =h3.expenditure_item_id AND h1.document_type (+) = 'EXP'

Line 98816: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'

98812: FROM (
98813: SELECT xet.event_id event_id
98814: , 0 line_number
98815: , CASE r
98816: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
98817: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
98818:
98819: ELSE null
98820: END object_name

Line 98817: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'

98813: SELECT xet.event_id event_id
98814: , 0 line_number
98815: , CASE r
98816: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
98817: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
98818:
98819: ELSE null
98820: END object_name
98821: , CASE r

Line 98848: , PA_XLA_EXP_HEADER_V h2

98844: ELSE null
98845: END source_value
98846: , null source_meaning
98847: FROM xla_events_gt xet
98848: , PA_XLA_EXP_HEADER_V h2
98849: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
98850: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
98851: AND xet.event_class_code = C_EVENT_CLASS_CODE
98852: AND h2.event_id = xet.event_id

Line 99242: TYPE t_array_source_33 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;

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;
99244:
99245: TYPE t_array_source_3 IS TABLE OF PA_XLA_CDL_LINES_V.BUDGET_CCID%TYPE INDEX BY BINARY_INTEGER;
99246: TYPE t_array_source_4 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 99243: TYPE t_array_source_75 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

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;
99244:
99245: TYPE t_array_source_3 IS TABLE OF PA_XLA_CDL_LINES_V.BUDGET_CCID%TYPE INDEX BY BINARY_INTEGER;
99246: TYPE t_array_source_4 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;
99247: TYPE t_array_source_5 IS TABLE OF PA_XLA_CDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 99343: , PA_XLA_EXP_HEADER_V h2

99339: ,xet.budgetary_control_flag
99340: , h2.EXPENDITURE_ITEM_ID source_33
99341: , h2.GL_DATE source_75
99342: FROM xla_events_gt xet
99343: , PA_XLA_EXP_HEADER_V h2
99344: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
99345: and xet.event_class_code = C_EVENT_CLASS_CODE
99346: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
99347:

Line 100365: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'

100361: FROM (
100362: SELECT xet.event_id event_id
100363: , 0 line_number
100364: , CASE r
100365: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
100366: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
100367:
100368: ELSE null
100369: END object_name

Line 100366: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'

100362: SELECT xet.event_id event_id
100363: , 0 line_number
100364: , CASE r
100365: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
100366: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
100367:
100368: ELSE null
100369: END object_name
100370: , CASE r

Line 100397: , PA_XLA_EXP_HEADER_V h2

100393: ELSE null
100394: END source_value
100395: , null source_meaning
100396: FROM xla_events_gt xet
100397: , PA_XLA_EXP_HEADER_V h2
100398: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
100399: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
100400: AND xet.event_class_code = C_EVENT_CLASS_CODE
100401: AND h2.event_id = xet.event_id

Line 100796: TYPE t_array_source_33 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;

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;
100798:
100799: TYPE t_array_source_3 IS TABLE OF PA_XLA_CDL_LINES_V.BUDGET_CCID%TYPE INDEX BY BINARY_INTEGER;
100800: TYPE t_array_source_4 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 100797: TYPE t_array_source_75 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

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;
100798:
100799: TYPE t_array_source_3 IS TABLE OF PA_XLA_CDL_LINES_V.BUDGET_CCID%TYPE INDEX BY BINARY_INTEGER;
100800: TYPE t_array_source_4 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;
100801: TYPE t_array_source_5 IS TABLE OF PA_XLA_CDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 100899: , PA_XLA_EXP_HEADER_V h2

100895: ,xet.budgetary_control_flag
100896: , h2.EXPENDITURE_ITEM_ID source_33
100897: , h2.GL_DATE source_75
100898: FROM xla_events_gt xet
100899: , PA_XLA_EXP_HEADER_V h2
100900: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
100901: and xet.event_class_code = C_EVENT_CLASS_CODE
100902: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
100903:

Line 101944: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'

101940: FROM (
101941: SELECT xet.event_id event_id
101942: , 0 line_number
101943: , CASE r
101944: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
101945: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
101946:
101947: ELSE null
101948: END object_name

Line 101945: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'

101941: SELECT xet.event_id event_id
101942: , 0 line_number
101943: , CASE r
101944: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
101945: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
101946:
101947: ELSE null
101948: END object_name
101949: , CASE r

Line 101976: , PA_XLA_EXP_HEADER_V h2

101972: ELSE null
101973: END source_value
101974: , null source_meaning
101975: FROM xla_events_gt xet
101976: , PA_XLA_EXP_HEADER_V h2
101977: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
101978: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
101979: AND xet.event_class_code = C_EVENT_CLASS_CODE
101980: AND h2.event_id = xet.event_id

Line 102310: TYPE t_array_source_33 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;

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;
102312:
102313: TYPE t_array_source_4 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;
102314: TYPE t_array_source_5 IS TABLE OF PA_XLA_CDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 102311: TYPE t_array_source_75 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

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;
102312:
102313: TYPE t_array_source_4 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;
102314: TYPE t_array_source_5 IS TABLE OF PA_XLA_CDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
102315: TYPE t_array_source_6 IS TABLE OF PA_XLA_CDL_LINES_V.ADJ_COST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 102387: , PA_XLA_EXP_HEADER_V h2

102383: ,xet.budgetary_control_flag
102384: , h2.EXPENDITURE_ITEM_ID source_33
102385: , h2.GL_DATE source_75
102386: FROM xla_events_gt xet
102387: , PA_XLA_EXP_HEADER_V h2
102388: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
102389: and xet.event_class_code = C_EVENT_CLASS_CODE
102390: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
102391:

Line 103316: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'

103312: FROM (
103313: SELECT xet.event_id event_id
103314: , 0 line_number
103315: , CASE r
103316: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
103317: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
103318:
103319: ELSE null
103320: END object_name

Line 103317: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'

103313: SELECT xet.event_id event_id
103314: , 0 line_number
103315: , CASE r
103316: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
103317: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
103318:
103319: ELSE null
103320: END object_name
103321: , CASE r

Line 103348: , PA_XLA_EXP_HEADER_V h2

103344: ELSE null
103345: END source_value
103346: , null source_meaning
103347: FROM xla_events_gt xet
103348: , PA_XLA_EXP_HEADER_V h2
103349: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
103350: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
103351: AND xet.event_class_code = C_EVENT_CLASS_CODE
103352: AND h2.event_id = xet.event_id

Line 103682: TYPE t_array_source_33 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;

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;
103684:
103685: TYPE t_array_source_4 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;
103686: TYPE t_array_source_5 IS TABLE OF PA_XLA_CDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 103683: TYPE t_array_source_75 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

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;
103684:
103685: TYPE t_array_source_4 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;
103686: TYPE t_array_source_5 IS TABLE OF PA_XLA_CDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
103687: TYPE t_array_source_6 IS TABLE OF PA_XLA_CDL_LINES_V.ADJ_COST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 103759: , PA_XLA_EXP_HEADER_V h2

103755: ,xet.budgetary_control_flag
103756: , h2.EXPENDITURE_ITEM_ID source_33
103757: , h2.GL_DATE source_75
103758: FROM xla_events_gt xet
103759: , PA_XLA_EXP_HEADER_V h2
103760: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
103761: and xet.event_class_code = C_EVENT_CLASS_CODE
103762: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
103763:

Line 104688: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'

104684: FROM (
104685: SELECT xet.event_id event_id
104686: , 0 line_number
104687: , CASE r
104688: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
104689: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
104690:
104691: ELSE null
104692: END object_name

Line 104689: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'

104685: SELECT xet.event_id event_id
104686: , 0 line_number
104687: , CASE r
104688: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
104689: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
104690:
104691: ELSE null
104692: END object_name
104693: , CASE r

Line 104720: , PA_XLA_EXP_HEADER_V h2

104716: ELSE null
104717: END source_value
104718: , null source_meaning
104719: FROM xla_events_gt xet
104720: , PA_XLA_EXP_HEADER_V h2
104721: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
104722: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
104723: AND xet.event_class_code = C_EVENT_CLASS_CODE
104724: AND h2.event_id = xet.event_id

Line 105054: TYPE t_array_source_33 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;

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;
105056:
105057: TYPE t_array_source_4 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;
105058: TYPE t_array_source_5 IS TABLE OF PA_XLA_CDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 105055: TYPE t_array_source_75 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

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;
105056:
105057: TYPE t_array_source_4 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;
105058: TYPE t_array_source_5 IS TABLE OF PA_XLA_CDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
105059: TYPE t_array_source_6 IS TABLE OF PA_XLA_CDL_LINES_V.ADJ_COST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 105131: , PA_XLA_EXP_HEADER_V h2

105127: ,xet.budgetary_control_flag
105128: , h2.EXPENDITURE_ITEM_ID source_33
105129: , h2.GL_DATE source_75
105130: FROM xla_events_gt xet
105131: , PA_XLA_EXP_HEADER_V h2
105132: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
105133: and xet.event_class_code = C_EVENT_CLASS_CODE
105134: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
105135:

Line 106060: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'

106056: FROM (
106057: SELECT xet.event_id event_id
106058: , 0 line_number
106059: , CASE r
106060: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
106061: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
106062:
106063: ELSE null
106064: END object_name

Line 106061: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'

106057: SELECT xet.event_id event_id
106058: , 0 line_number
106059: , CASE r
106060: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
106061: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
106062:
106063: ELSE null
106064: END object_name
106065: , CASE r

Line 106092: , PA_XLA_EXP_HEADER_V h2

106088: ELSE null
106089: END source_value
106090: , null source_meaning
106091: FROM xla_events_gt xet
106092: , PA_XLA_EXP_HEADER_V h2
106093: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
106094: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
106095: AND xet.event_class_code = C_EVENT_CLASS_CODE
106096: AND h2.event_id = xet.event_id

Line 106426: TYPE t_array_source_33 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;

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;
106428:
106429: TYPE t_array_source_4 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;
106430: TYPE t_array_source_5 IS TABLE OF PA_XLA_CDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 106427: TYPE t_array_source_75 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

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;
106428:
106429: TYPE t_array_source_4 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;
106430: TYPE t_array_source_5 IS TABLE OF PA_XLA_CDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
106431: TYPE t_array_source_6 IS TABLE OF PA_XLA_CDL_LINES_V.ADJ_COST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 106503: , PA_XLA_EXP_HEADER_V h2

106499: ,xet.budgetary_control_flag
106500: , h2.EXPENDITURE_ITEM_ID source_33
106501: , h2.GL_DATE source_75
106502: FROM xla_events_gt xet
106503: , PA_XLA_EXP_HEADER_V h2
106504: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
106505: and xet.event_class_code = C_EVENT_CLASS_CODE
106506: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
106507: