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

APPS.XLA_00275_AAD_S_000016_PKG dependencies on PA_XLA_EXP_HEADER_V

Line 55352: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'

55348: FROM (
55349: SELECT xet.event_id event_id
55350: , 0 line_number
55351: , CASE r
55352: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
55353: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
55354: WHEN 3 THEN 'PA_XLA_EXP_HEADER_V'
55355:
55356: ELSE null

Line 55353: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'

55349: SELECT xet.event_id event_id
55350: , 0 line_number
55351: , CASE r
55352: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
55353: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
55354: WHEN 3 THEN 'PA_XLA_EXP_HEADER_V'
55355:
55356: ELSE null
55357: END object_name

Line 55354: WHEN 3 THEN 'PA_XLA_EXP_HEADER_V'

55350: , 0 line_number
55351: , CASE r
55352: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
55353: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
55354: WHEN 3 THEN 'PA_XLA_EXP_HEADER_V'
55355:
55356: ELSE null
55357: END object_name
55358: , CASE r

Line 55393: , PA_XLA_EXP_HEADER_V h2

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

Line 55732: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;

55728: --
55729: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
55730: --
55731:
55732: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
55733: TYPE t_array_source_67 IS TABLE OF PA_XLA_EXP_HEADER_V.TP_AMT_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
55734: TYPE t_array_source_88 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
55735:
55736: TYPE t_array_source_4 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 55733: TYPE t_array_source_67 IS TABLE OF PA_XLA_EXP_HEADER_V.TP_AMT_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

55729: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
55730: --
55731:
55732: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
55733: TYPE t_array_source_67 IS TABLE OF PA_XLA_EXP_HEADER_V.TP_AMT_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
55734: TYPE t_array_source_88 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
55735:
55736: TYPE t_array_source_4 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
55737: TYPE t_array_source_8 IS TABLE OF PA_XLA_CCDL_LINES_V.PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 55734: TYPE t_array_source_88 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

55730: --
55731:
55732: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
55733: TYPE t_array_source_67 IS TABLE OF PA_XLA_EXP_HEADER_V.TP_AMT_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
55734: TYPE t_array_source_88 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
55735:
55736: TYPE t_array_source_4 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
55737: TYPE t_array_source_8 IS TABLE OF PA_XLA_CCDL_LINES_V.PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
55738: TYPE t_array_source_9 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 55814: , PA_XLA_EXP_HEADER_V h2

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

Line 56760: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'

56756: FROM (
56757: SELECT xet.event_id event_id
56758: , 0 line_number
56759: , CASE r
56760: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
56761: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
56762: WHEN 3 THEN 'PA_XLA_EXP_HEADER_V'
56763:
56764: ELSE null

Line 56761: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'

56757: SELECT xet.event_id event_id
56758: , 0 line_number
56759: , CASE r
56760: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
56761: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
56762: WHEN 3 THEN 'PA_XLA_EXP_HEADER_V'
56763:
56764: ELSE null
56765: END object_name

Line 56762: WHEN 3 THEN 'PA_XLA_EXP_HEADER_V'

56758: , 0 line_number
56759: , CASE r
56760: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
56761: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
56762: WHEN 3 THEN 'PA_XLA_EXP_HEADER_V'
56763:
56764: ELSE null
56765: END object_name
56766: , CASE r

Line 56801: , PA_XLA_EXP_HEADER_V h2

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

Line 57140: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;

57136: --
57137: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
57138: --
57139:
57140: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
57141: TYPE t_array_source_67 IS TABLE OF PA_XLA_EXP_HEADER_V.TP_AMT_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
57142: TYPE t_array_source_88 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
57143:
57144: TYPE t_array_source_4 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 57141: TYPE t_array_source_67 IS TABLE OF PA_XLA_EXP_HEADER_V.TP_AMT_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

57137: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
57138: --
57139:
57140: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
57141: TYPE t_array_source_67 IS TABLE OF PA_XLA_EXP_HEADER_V.TP_AMT_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
57142: TYPE t_array_source_88 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
57143:
57144: TYPE t_array_source_4 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
57145: TYPE t_array_source_8 IS TABLE OF PA_XLA_CCDL_LINES_V.PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 57142: TYPE t_array_source_88 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

57138: --
57139:
57140: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
57141: TYPE t_array_source_67 IS TABLE OF PA_XLA_EXP_HEADER_V.TP_AMT_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
57142: TYPE t_array_source_88 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
57143:
57144: TYPE t_array_source_4 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
57145: TYPE t_array_source_8 IS TABLE OF PA_XLA_CCDL_LINES_V.PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
57146: TYPE t_array_source_9 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 57222: , PA_XLA_EXP_HEADER_V h2

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

Line 59292: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'

59288: FROM (
59289: SELECT xet.event_id event_id
59290: , 0 line_number
59291: , CASE r
59292: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
59293: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
59294:
59295: ELSE null
59296: END object_name

Line 59293: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'

59289: SELECT xet.event_id event_id
59290: , 0 line_number
59291: , CASE r
59292: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
59293: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
59294:
59295: ELSE null
59296: END object_name
59297: , CASE r

Line 59324: , PA_XLA_EXP_HEADER_V h2

59320: ELSE null
59321: END source_value
59322: , null source_meaning
59323: FROM xla_events_gt xet
59324: , PA_XLA_EXP_HEADER_V h2
59325: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
59326: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
59327: AND xet.event_class_code = C_EVENT_CLASS_CODE
59328: AND h2.event_id = xet.event_id

Line 59723: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;

59719: --
59720: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
59721: --
59722:
59723: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
59724: TYPE t_array_source_88 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
59725:
59726: TYPE t_array_source_2 IS TABLE OF PA_XLA_CDL_LINES_V.BUDGET_CCID%TYPE INDEX BY BINARY_INTEGER;
59727: TYPE t_array_source_3 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 59724: TYPE t_array_source_88 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

59720: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
59721: --
59722:
59723: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
59724: TYPE t_array_source_88 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
59725:
59726: TYPE t_array_source_2 IS TABLE OF PA_XLA_CDL_LINES_V.BUDGET_CCID%TYPE INDEX BY BINARY_INTEGER;
59727: TYPE t_array_source_3 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;
59728: TYPE t_array_source_4 IS TABLE OF PA_XLA_CDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 59826: , PA_XLA_EXP_HEADER_V h2

59822: ,xet.budgetary_control_flag
59823: , h2.EXPENDITURE_ITEM_ID source_32
59824: , h2.GL_DATE source_88
59825: FROM xla_events_gt xet
59826: , PA_XLA_EXP_HEADER_V h2
59827: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
59828: and xet.event_class_code = C_EVENT_CLASS_CODE
59829: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
59830:

Line 60759: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'

60755: FROM (
60756: SELECT xet.event_id event_id
60757: , 0 line_number
60758: , CASE r
60759: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
60760: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
60761: WHEN 3 THEN 'PA_XLA_EXP_HEADER_V'
60762:
60763: ELSE null

Line 60760: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'

60756: SELECT xet.event_id event_id
60757: , 0 line_number
60758: , CASE r
60759: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
60760: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
60761: WHEN 3 THEN 'PA_XLA_EXP_HEADER_V'
60762:
60763: ELSE null
60764: END object_name

Line 60761: WHEN 3 THEN 'PA_XLA_EXP_HEADER_V'

60757: , 0 line_number
60758: , CASE r
60759: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
60760: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
60761: WHEN 3 THEN 'PA_XLA_EXP_HEADER_V'
60762:
60763: ELSE null
60764: END object_name
60765: , CASE r

Line 60796: , PA_XLA_EXP_HEADER_V h2

60792: ELSE null
60793: END source_value
60794: , null source_meaning
60795: FROM xla_events_gt xet
60796: , PA_XLA_EXP_HEADER_V h2
60797: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
60798: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
60799: AND xet.event_class_code = C_EVENT_CLASS_CODE
60800: AND h2.event_id = xet.event_id

Line 61291: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;

61287: --
61288: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
61289: --
61290:
61291: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
61292: TYPE t_array_source_37 IS TABLE OF PA_XLA_EXP_HEADER_V.SYSTEM_LINKAGE_FUNCTION%TYPE INDEX BY BINARY_INTEGER;
61293: TYPE t_array_source_88 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
61294:
61295: TYPE t_array_source_2 IS TABLE OF PA_XLA_CDL_LINES_V.BUDGET_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 61292: TYPE t_array_source_37 IS TABLE OF PA_XLA_EXP_HEADER_V.SYSTEM_LINKAGE_FUNCTION%TYPE INDEX BY BINARY_INTEGER;

61288: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
61289: --
61290:
61291: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
61292: TYPE t_array_source_37 IS TABLE OF PA_XLA_EXP_HEADER_V.SYSTEM_LINKAGE_FUNCTION%TYPE INDEX BY BINARY_INTEGER;
61293: TYPE t_array_source_88 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
61294:
61295: TYPE t_array_source_2 IS TABLE OF PA_XLA_CDL_LINES_V.BUDGET_CCID%TYPE INDEX BY BINARY_INTEGER;
61296: TYPE t_array_source_3 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 61293: TYPE t_array_source_88 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

61289: --
61290:
61291: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
61292: TYPE t_array_source_37 IS TABLE OF PA_XLA_EXP_HEADER_V.SYSTEM_LINKAGE_FUNCTION%TYPE INDEX BY BINARY_INTEGER;
61293: TYPE t_array_source_88 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
61294:
61295: TYPE t_array_source_2 IS TABLE OF PA_XLA_CDL_LINES_V.BUDGET_CCID%TYPE INDEX BY BINARY_INTEGER;
61296: TYPE t_array_source_3 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;
61297: TYPE t_array_source_4 IS TABLE OF PA_XLA_CDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 61434: , PA_XLA_EXP_HEADER_V h2

61430: , h2.EXPENDITURE_ITEM_ID source_32
61431: , h2.SYSTEM_LINKAGE_FUNCTION source_37
61432: , h2.GL_DATE source_88
61433: FROM xla_events_gt xet
61434: , PA_XLA_EXP_HEADER_V h2
61435: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
61436: and xet.event_class_code = C_EVENT_CLASS_CODE
61437: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
61438:

Line 62769: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'

62765: FROM (
62766: SELECT xet.event_id event_id
62767: , 0 line_number
62768: , CASE r
62769: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
62770: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
62771:
62772: ELSE null
62773: END object_name

Line 62770: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'

62766: SELECT xet.event_id event_id
62767: , 0 line_number
62768: , CASE r
62769: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
62770: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
62771:
62772: ELSE null
62773: END object_name
62774: , CASE r

Line 62801: , PA_XLA_EXP_HEADER_V h2

62797: ELSE null
62798: END source_value
62799: , null source_meaning
62800: FROM xla_events_gt xet
62801: , PA_XLA_EXP_HEADER_V h2
62802: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
62803: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
62804: AND xet.event_class_code = C_EVENT_CLASS_CODE
62805: AND h2.event_id = xet.event_id

Line 63135: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;

63131: --
63132: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
63133: --
63134:
63135: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
63136: TYPE t_array_source_88 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
63137:
63138: TYPE t_array_source_3 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;
63139: TYPE t_array_source_4 IS TABLE OF PA_XLA_CDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 63136: TYPE t_array_source_88 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

63132: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
63133: --
63134:
63135: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
63136: TYPE t_array_source_88 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
63137:
63138: TYPE t_array_source_3 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;
63139: TYPE t_array_source_4 IS TABLE OF PA_XLA_CDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
63140: TYPE t_array_source_5 IS TABLE OF PA_XLA_CDL_LINES_V.ADJ_COST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 63212: , PA_XLA_EXP_HEADER_V h2

63208: ,xet.budgetary_control_flag
63209: , h2.EXPENDITURE_ITEM_ID source_32
63210: , h2.GL_DATE source_88
63211: FROM xla_events_gt xet
63212: , PA_XLA_EXP_HEADER_V h2
63213: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
63214: and xet.event_class_code = C_EVENT_CLASS_CODE
63215: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
63216:

Line 64067: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'

64063: FROM (
64064: SELECT xet.event_id event_id
64065: , 0 line_number
64066: , CASE r
64067: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
64068: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
64069:
64070: ELSE null
64071: END object_name

Line 64068: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'

64064: SELECT xet.event_id event_id
64065: , 0 line_number
64066: , CASE r
64067: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
64068: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
64069:
64070: ELSE null
64071: END object_name
64072: , CASE r

Line 64099: , PA_XLA_EXP_HEADER_V h2

64095: ELSE null
64096: END source_value
64097: , null source_meaning
64098: FROM xla_events_gt xet
64099: , PA_XLA_EXP_HEADER_V h2
64100: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
64101: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
64102: AND xet.event_class_code = C_EVENT_CLASS_CODE
64103: AND h2.event_id = xet.event_id

Line 64433: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;

64429: --
64430: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
64431: --
64432:
64433: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
64434: TYPE t_array_source_88 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
64435:
64436: TYPE t_array_source_3 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;
64437: TYPE t_array_source_4 IS TABLE OF PA_XLA_CDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 64434: TYPE t_array_source_88 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

64430: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
64431: --
64432:
64433: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
64434: TYPE t_array_source_88 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
64435:
64436: TYPE t_array_source_3 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;
64437: TYPE t_array_source_4 IS TABLE OF PA_XLA_CDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
64438: TYPE t_array_source_5 IS TABLE OF PA_XLA_CDL_LINES_V.ADJ_COST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 64510: , PA_XLA_EXP_HEADER_V h2

64506: ,xet.budgetary_control_flag
64507: , h2.EXPENDITURE_ITEM_ID source_32
64508: , h2.GL_DATE source_88
64509: FROM xla_events_gt xet
64510: , PA_XLA_EXP_HEADER_V h2
64511: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
64512: and xet.event_class_code = C_EVENT_CLASS_CODE
64513: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
64514:

Line 65365: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'

65361: FROM (
65362: SELECT xet.event_id event_id
65363: , 0 line_number
65364: , CASE r
65365: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
65366: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
65367:
65368: ELSE null
65369: END object_name

Line 65366: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'

65362: SELECT xet.event_id event_id
65363: , 0 line_number
65364: , CASE r
65365: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
65366: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
65367:
65368: ELSE null
65369: END object_name
65370: , CASE r

Line 65397: , PA_XLA_EXP_HEADER_V h2

65393: ELSE null
65394: END source_value
65395: , null source_meaning
65396: FROM xla_events_gt xet
65397: , PA_XLA_EXP_HEADER_V h2
65398: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
65399: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
65400: AND xet.event_class_code = C_EVENT_CLASS_CODE
65401: AND h2.event_id = xet.event_id

Line 65731: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;

65727: --
65728: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
65729: --
65730:
65731: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
65732: TYPE t_array_source_88 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
65733:
65734: TYPE t_array_source_3 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;
65735: TYPE t_array_source_4 IS TABLE OF PA_XLA_CDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 65732: TYPE t_array_source_88 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

65728: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
65729: --
65730:
65731: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
65732: TYPE t_array_source_88 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
65733:
65734: TYPE t_array_source_3 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;
65735: TYPE t_array_source_4 IS TABLE OF PA_XLA_CDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
65736: TYPE t_array_source_5 IS TABLE OF PA_XLA_CDL_LINES_V.ADJ_COST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 65808: , PA_XLA_EXP_HEADER_V h2

65804: ,xet.budgetary_control_flag
65805: , h2.EXPENDITURE_ITEM_ID source_32
65806: , h2.GL_DATE source_88
65807: FROM xla_events_gt xet
65808: , PA_XLA_EXP_HEADER_V h2
65809: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
65810: and xet.event_class_code = C_EVENT_CLASS_CODE
65811: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
65812:

Line 66663: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'

66659: FROM (
66660: SELECT xet.event_id event_id
66661: , 0 line_number
66662: , CASE r
66663: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
66664: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
66665:
66666: ELSE null
66667: END object_name

Line 66664: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'

66660: SELECT xet.event_id event_id
66661: , 0 line_number
66662: , CASE r
66663: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
66664: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
66665:
66666: ELSE null
66667: END object_name
66668: , CASE r

Line 66695: , PA_XLA_EXP_HEADER_V h2

66691: ELSE null
66692: END source_value
66693: , null source_meaning
66694: FROM xla_events_gt xet
66695: , PA_XLA_EXP_HEADER_V h2
66696: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
66697: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
66698: AND xet.event_class_code = C_EVENT_CLASS_CODE
66699: AND h2.event_id = xet.event_id

Line 67029: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;

67025: --
67026: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
67027: --
67028:
67029: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
67030: TYPE t_array_source_88 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
67031:
67032: TYPE t_array_source_3 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;
67033: TYPE t_array_source_4 IS TABLE OF PA_XLA_CDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 67030: TYPE t_array_source_88 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

67026: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
67027: --
67028:
67029: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
67030: TYPE t_array_source_88 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
67031:
67032: TYPE t_array_source_3 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;
67033: TYPE t_array_source_4 IS TABLE OF PA_XLA_CDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
67034: TYPE t_array_source_5 IS TABLE OF PA_XLA_CDL_LINES_V.ADJ_COST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 67106: , PA_XLA_EXP_HEADER_V h2

67102: ,xet.budgetary_control_flag
67103: , h2.EXPENDITURE_ITEM_ID source_32
67104: , h2.GL_DATE source_88
67105: FROM xla_events_gt xet
67106: , PA_XLA_EXP_HEADER_V h2
67107: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
67108: and xet.event_class_code = C_EVENT_CLASS_CODE
67109: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
67110:

Line 67961: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'

67957: FROM (
67958: SELECT xet.event_id event_id
67959: , 0 line_number
67960: , CASE r
67961: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
67962: WHEN 2 THEN 'PA_XLA_PROJECT_REF_V'
67963: WHEN 3 THEN 'PA_XLA_EXP_HEADER_V'
67964:
67965: ELSE null

Line 67963: WHEN 3 THEN 'PA_XLA_EXP_HEADER_V'

67959: , 0 line_number
67960: , CASE r
67961: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
67962: WHEN 2 THEN 'PA_XLA_PROJECT_REF_V'
67963: WHEN 3 THEN 'PA_XLA_EXP_HEADER_V'
67964:
67965: ELSE null
67966: END object_name
67967: , CASE r

Line 67998: , PA_XLA_EXP_HEADER_V h2

67994: ELSE null
67995: END source_value
67996: , null source_meaning
67997: FROM xla_events_gt xet
67998: , PA_XLA_EXP_HEADER_V h2
67999: , PA_XLA_PROJECT_REF_V h3
68000: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
68001: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
68002: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 68333: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;

68329: --
68330: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
68331: --
68332:
68333: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
68334: TYPE t_array_source_68 IS TABLE OF PA_XLA_PROJECT_REF_V.PROJECT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
68335: TYPE t_array_source_88 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
68336:
68337: TYPE t_array_source_3 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 68335: TYPE t_array_source_88 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

68331: --
68332:
68333: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
68334: TYPE t_array_source_68 IS TABLE OF PA_XLA_PROJECT_REF_V.PROJECT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
68335: TYPE t_array_source_88 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
68336:
68337: TYPE t_array_source_3 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;
68338: TYPE t_array_source_4 IS TABLE OF PA_XLA_CDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
68339: TYPE t_array_source_5 IS TABLE OF PA_XLA_CDL_LINES_V.ADJ_COST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 68413: , PA_XLA_EXP_HEADER_V h2

68409: , h2.EXPENDITURE_ITEM_ID source_32
68410: , h3.PROJECT_NUMBER source_68
68411: , h2.GL_DATE source_88
68412: FROM xla_events_gt xet
68413: , PA_XLA_EXP_HEADER_V h2
68414: , PA_XLA_PROJECT_REF_V h3
68415: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
68416: and xet.event_class_code = C_EVENT_CLASS_CODE
68417: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id

Line 69273: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'

69269: FROM (
69270: SELECT xet.event_id event_id
69271: , 0 line_number
69272: , CASE r
69273: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
69274: WHEN 2 THEN 'PA_XLA_PROJECT_REF_V'
69275: WHEN 3 THEN 'PA_XLA_EXP_HEADER_V'
69276:
69277: ELSE null

Line 69275: WHEN 3 THEN 'PA_XLA_EXP_HEADER_V'

69271: , 0 line_number
69272: , CASE r
69273: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
69274: WHEN 2 THEN 'PA_XLA_PROJECT_REF_V'
69275: WHEN 3 THEN 'PA_XLA_EXP_HEADER_V'
69276:
69277: ELSE null
69278: END object_name
69279: , CASE r

Line 69310: , PA_XLA_EXP_HEADER_V h2

69306: ELSE null
69307: END source_value
69308: , null source_meaning
69309: FROM xla_events_gt xet
69310: , PA_XLA_EXP_HEADER_V h2
69311: , PA_XLA_PROJECT_REF_V h3
69312: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
69313: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
69314: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 69645: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;

69641: --
69642: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
69643: --
69644:
69645: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
69646: TYPE t_array_source_68 IS TABLE OF PA_XLA_PROJECT_REF_V.PROJECT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
69647: TYPE t_array_source_88 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
69648:
69649: TYPE t_array_source_3 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 69647: TYPE t_array_source_88 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

69643: --
69644:
69645: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
69646: TYPE t_array_source_68 IS TABLE OF PA_XLA_PROJECT_REF_V.PROJECT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
69647: TYPE t_array_source_88 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
69648:
69649: TYPE t_array_source_3 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;
69650: TYPE t_array_source_4 IS TABLE OF PA_XLA_CDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
69651: TYPE t_array_source_5 IS TABLE OF PA_XLA_CDL_LINES_V.ADJ_COST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 69725: , PA_XLA_EXP_HEADER_V h2

69721: , h2.EXPENDITURE_ITEM_ID source_32
69722: , h3.PROJECT_NUMBER source_68
69723: , h2.GL_DATE source_88
69724: FROM xla_events_gt xet
69725: , PA_XLA_EXP_HEADER_V h2
69726: , PA_XLA_PROJECT_REF_V h3
69727: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
69728: and xet.event_class_code = C_EVENT_CLASS_CODE
69729: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id

Line 70585: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'

70581: FROM (
70582: SELECT xet.event_id event_id
70583: , 0 line_number
70584: , CASE r
70585: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
70586: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
70587:
70588: ELSE null
70589: END object_name

Line 70586: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'

70582: SELECT xet.event_id event_id
70583: , 0 line_number
70584: , CASE r
70585: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
70586: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
70587:
70588: ELSE null
70589: END object_name
70590: , CASE r

Line 70617: , PA_XLA_EXP_HEADER_V h2

70613: ELSE null
70614: END source_value
70615: , null source_meaning
70616: FROM xla_events_gt xet
70617: , PA_XLA_EXP_HEADER_V h2
70618: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
70619: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
70620: AND xet.event_class_code = C_EVENT_CLASS_CODE
70621: AND h2.event_id = xet.event_id

Line 70951: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;

70947: --
70948: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
70949: --
70950:
70951: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
70952: TYPE t_array_source_88 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
70953:
70954: TYPE t_array_source_4 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
70955: TYPE t_array_source_11 IS TABLE OF PA_XLA_CCDL_LINES_V.DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 70952: TYPE t_array_source_88 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

70948: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
70949: --
70950:
70951: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
70952: TYPE t_array_source_88 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
70953:
70954: TYPE t_array_source_4 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
70955: TYPE t_array_source_11 IS TABLE OF PA_XLA_CCDL_LINES_V.DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
70956: TYPE t_array_source_12 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 71028: , PA_XLA_EXP_HEADER_V h2

71024: ,xet.budgetary_control_flag
71025: , h2.EXPENDITURE_ITEM_ID source_32
71026: , h2.GL_DATE source_88
71027: FROM xla_events_gt xet
71028: , PA_XLA_EXP_HEADER_V h2
71029: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
71030: and xet.event_class_code = C_EVENT_CLASS_CODE
71031: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
71032:

Line 71883: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'

71879: FROM (
71880: SELECT xet.event_id event_id
71881: , 0 line_number
71882: , CASE r
71883: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
71884: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
71885:
71886: ELSE null
71887: END object_name

Line 71884: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'

71880: SELECT xet.event_id event_id
71881: , 0 line_number
71882: , CASE r
71883: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
71884: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
71885:
71886: ELSE null
71887: END object_name
71888: , CASE r

Line 71915: , PA_XLA_EXP_HEADER_V h2

71911: ELSE null
71912: END source_value
71913: , null source_meaning
71914: FROM xla_events_gt xet
71915: , PA_XLA_EXP_HEADER_V h2
71916: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
71917: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
71918: AND xet.event_class_code = C_EVENT_CLASS_CODE
71919: AND h2.event_id = xet.event_id

Line 72249: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;

72245: --
72246: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
72247: --
72248:
72249: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
72250: TYPE t_array_source_88 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
72251:
72252: TYPE t_array_source_4 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
72253: TYPE t_array_source_11 IS TABLE OF PA_XLA_CCDL_LINES_V.DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 72250: TYPE t_array_source_88 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

72246: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
72247: --
72248:
72249: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
72250: TYPE t_array_source_88 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
72251:
72252: TYPE t_array_source_4 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
72253: TYPE t_array_source_11 IS TABLE OF PA_XLA_CCDL_LINES_V.DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
72254: TYPE t_array_source_12 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 72326: , PA_XLA_EXP_HEADER_V h2

72322: ,xet.budgetary_control_flag
72323: , h2.EXPENDITURE_ITEM_ID source_32
72324: , h2.GL_DATE source_88
72325: FROM xla_events_gt xet
72326: , PA_XLA_EXP_HEADER_V h2
72327: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
72328: and xet.event_class_code = C_EVENT_CLASS_CODE
72329: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
72330:

Line 76357: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'

76353: FROM (
76354: SELECT xet.event_id event_id
76355: , 0 line_number
76356: , CASE r
76357: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
76358: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
76359: WHEN 3 THEN 'PA_XLA_EXP_HEADER_V'
76360:
76361: ELSE null

Line 76358: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'

76354: SELECT xet.event_id event_id
76355: , 0 line_number
76356: , CASE r
76357: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
76358: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
76359: WHEN 3 THEN 'PA_XLA_EXP_HEADER_V'
76360:
76361: ELSE null
76362: END object_name

Line 76359: WHEN 3 THEN 'PA_XLA_EXP_HEADER_V'

76355: , 0 line_number
76356: , CASE r
76357: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
76358: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
76359: WHEN 3 THEN 'PA_XLA_EXP_HEADER_V'
76360:
76361: ELSE null
76362: END object_name
76363: , CASE r

Line 76403: , PA_XLA_EXP_HEADER_V h2

76399:
76400: ELSE null
76401: END source_meaning
76402: FROM xla_events_gt xet
76403: , PA_XLA_EXP_HEADER_V h2
76404: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
76405: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
76406: AND xet.event_class_code = C_EVENT_CLASS_CODE
76407: AND h2.event_id = xet.event_id

Line 76737: TYPE t_array_source_21 IS TABLE OF PA_XLA_EXP_HEADER_V.EXCHANGE_RATE_VARIANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;

76733: --
76734: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
76735: --
76736:
76737: TYPE t_array_source_21 IS TABLE OF PA_XLA_EXP_HEADER_V.EXCHANGE_RATE_VARIANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
76738: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
76739: TYPE t_array_source_88 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
76740:
76741: TYPE t_array_source_3 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 76738: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;

76734: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
76735: --
76736:
76737: TYPE t_array_source_21 IS TABLE OF PA_XLA_EXP_HEADER_V.EXCHANGE_RATE_VARIANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
76738: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
76739: TYPE t_array_source_88 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
76740:
76741: TYPE t_array_source_3 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;
76742: TYPE t_array_source_4 IS TABLE OF PA_XLA_CDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 76739: TYPE t_array_source_88 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

76735: --
76736:
76737: TYPE t_array_source_21 IS TABLE OF PA_XLA_EXP_HEADER_V.EXCHANGE_RATE_VARIANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
76738: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
76739: TYPE t_array_source_88 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
76740:
76741: TYPE t_array_source_3 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;
76742: TYPE t_array_source_4 IS TABLE OF PA_XLA_CDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
76743: TYPE t_array_source_5 IS TABLE OF PA_XLA_CDL_LINES_V.ADJ_COST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 76817: , PA_XLA_EXP_HEADER_V h2

76813: , h2.EXCHANGE_RATE_VARIANCE_FLAG source_21
76814: , h2.EXPENDITURE_ITEM_ID source_32
76815: , h2.GL_DATE source_88
76816: FROM xla_events_gt xet
76817: , PA_XLA_EXP_HEADER_V h2
76818: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
76819: and xet.event_class_code = C_EVENT_CLASS_CODE
76820: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
76821:

Line 77752: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'

77748: FROM (
77749: SELECT xet.event_id event_id
77750: , 0 line_number
77751: , CASE r
77752: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
77753: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
77754: WHEN 3 THEN 'PA_XLA_EXP_HEADER_V'
77755:
77756: ELSE null

Line 77753: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'

77749: SELECT xet.event_id event_id
77750: , 0 line_number
77751: , CASE r
77752: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
77753: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
77754: WHEN 3 THEN 'PA_XLA_EXP_HEADER_V'
77755:
77756: ELSE null
77757: END object_name

Line 77754: WHEN 3 THEN 'PA_XLA_EXP_HEADER_V'

77750: , 0 line_number
77751: , CASE r
77752: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
77753: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
77754: WHEN 3 THEN 'PA_XLA_EXP_HEADER_V'
77755:
77756: ELSE null
77757: END object_name
77758: , CASE r

Line 77798: , PA_XLA_EXP_HEADER_V h2

77794:
77795: ELSE null
77796: END source_meaning
77797: FROM xla_events_gt xet
77798: , PA_XLA_EXP_HEADER_V h2
77799: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
77800: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
77801: AND xet.event_class_code = C_EVENT_CLASS_CODE
77802: AND h2.event_id = xet.event_id

Line 78132: TYPE t_array_source_21 IS TABLE OF PA_XLA_EXP_HEADER_V.EXCHANGE_RATE_VARIANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;

78128: --
78129: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
78130: --
78131:
78132: TYPE t_array_source_21 IS TABLE OF PA_XLA_EXP_HEADER_V.EXCHANGE_RATE_VARIANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
78133: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
78134: TYPE t_array_source_88 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
78135:
78136: TYPE t_array_source_3 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 78133: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;

78129: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
78130: --
78131:
78132: TYPE t_array_source_21 IS TABLE OF PA_XLA_EXP_HEADER_V.EXCHANGE_RATE_VARIANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
78133: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
78134: TYPE t_array_source_88 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
78135:
78136: TYPE t_array_source_3 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;
78137: TYPE t_array_source_4 IS TABLE OF PA_XLA_CDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 78134: TYPE t_array_source_88 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

78130: --
78131:
78132: TYPE t_array_source_21 IS TABLE OF PA_XLA_EXP_HEADER_V.EXCHANGE_RATE_VARIANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
78133: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
78134: TYPE t_array_source_88 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
78135:
78136: TYPE t_array_source_3 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;
78137: TYPE t_array_source_4 IS TABLE OF PA_XLA_CDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
78138: TYPE t_array_source_5 IS TABLE OF PA_XLA_CDL_LINES_V.ADJ_COST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 78212: , PA_XLA_EXP_HEADER_V h2

78208: , h2.EXCHANGE_RATE_VARIANCE_FLAG source_21
78209: , h2.EXPENDITURE_ITEM_ID source_32
78210: , h2.GL_DATE source_88
78211: FROM xla_events_gt xet
78212: , PA_XLA_EXP_HEADER_V h2
78213: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
78214: and xet.event_class_code = C_EVENT_CLASS_CODE
78215: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
78216:

Line 79147: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'

79143: FROM (
79144: SELECT xet.event_id event_id
79145: , 0 line_number
79146: , CASE r
79147: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
79148: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
79149: WHEN 3 THEN 'PA_XLA_EXP_HEADER_V'
79150:
79151: ELSE null

Line 79148: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'

79144: SELECT xet.event_id event_id
79145: , 0 line_number
79146: , CASE r
79147: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
79148: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
79149: WHEN 3 THEN 'PA_XLA_EXP_HEADER_V'
79150:
79151: ELSE null
79152: END object_name

Line 79149: WHEN 3 THEN 'PA_XLA_EXP_HEADER_V'

79145: , 0 line_number
79146: , CASE r
79147: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
79148: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
79149: WHEN 3 THEN 'PA_XLA_EXP_HEADER_V'
79150:
79151: ELSE null
79152: END object_name
79153: , CASE r

Line 79184: , PA_XLA_EXP_HEADER_V h2

79180: ELSE null
79181: END source_value
79182: , null source_meaning
79183: FROM xla_events_gt xet
79184: , PA_XLA_EXP_HEADER_V h2
79185: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
79186: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
79187: AND xet.event_class_code = C_EVENT_CLASS_CODE
79188: AND h2.event_id = xet.event_id

Line 79674: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;

79670: --
79671: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
79672: --
79673:
79674: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
79675: TYPE t_array_source_37 IS TABLE OF PA_XLA_EXP_HEADER_V.SYSTEM_LINKAGE_FUNCTION%TYPE INDEX BY BINARY_INTEGER;
79676: TYPE t_array_source_88 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
79677:
79678: TYPE t_array_source_2 IS TABLE OF PA_XLA_CDL_LINES_V.BUDGET_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 79675: TYPE t_array_source_37 IS TABLE OF PA_XLA_EXP_HEADER_V.SYSTEM_LINKAGE_FUNCTION%TYPE INDEX BY BINARY_INTEGER;

79671: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
79672: --
79673:
79674: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
79675: TYPE t_array_source_37 IS TABLE OF PA_XLA_EXP_HEADER_V.SYSTEM_LINKAGE_FUNCTION%TYPE INDEX BY BINARY_INTEGER;
79676: TYPE t_array_source_88 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
79677:
79678: TYPE t_array_source_2 IS TABLE OF PA_XLA_CDL_LINES_V.BUDGET_CCID%TYPE INDEX BY BINARY_INTEGER;
79679: TYPE t_array_source_3 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 79676: TYPE t_array_source_88 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

79672: --
79673:
79674: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
79675: TYPE t_array_source_37 IS TABLE OF PA_XLA_EXP_HEADER_V.SYSTEM_LINKAGE_FUNCTION%TYPE INDEX BY BINARY_INTEGER;
79676: TYPE t_array_source_88 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
79677:
79678: TYPE t_array_source_2 IS TABLE OF PA_XLA_CDL_LINES_V.BUDGET_CCID%TYPE INDEX BY BINARY_INTEGER;
79679: TYPE t_array_source_3 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;
79680: TYPE t_array_source_4 IS TABLE OF PA_XLA_CDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 79815: , PA_XLA_EXP_HEADER_V h2

79811: , h2.EXPENDITURE_ITEM_ID source_32
79812: , h2.SYSTEM_LINKAGE_FUNCTION source_37
79813: , h2.GL_DATE source_88
79814: FROM xla_events_gt xet
79815: , PA_XLA_EXP_HEADER_V h2
79816: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
79817: and xet.event_class_code = C_EVENT_CLASS_CODE
79818: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
79819:

Line 81135: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'

81131: FROM (
81132: SELECT xet.event_id event_id
81133: , 0 line_number
81134: , CASE r
81135: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
81136: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
81137: WHEN 3 THEN 'PA_XLA_EXP_HEADER_V'
81138:
81139: ELSE null

Line 81136: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'

81132: SELECT xet.event_id event_id
81133: , 0 line_number
81134: , CASE r
81135: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
81136: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
81137: WHEN 3 THEN 'PA_XLA_EXP_HEADER_V'
81138:
81139: ELSE null
81140: END object_name

Line 81137: WHEN 3 THEN 'PA_XLA_EXP_HEADER_V'

81133: , 0 line_number
81134: , CASE r
81135: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
81136: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
81137: WHEN 3 THEN 'PA_XLA_EXP_HEADER_V'
81138:
81139: ELSE null
81140: END object_name
81141: , CASE r

Line 81172: , PA_XLA_EXP_HEADER_V h2

81168: ELSE null
81169: END source_value
81170: , null source_meaning
81171: FROM xla_events_gt xet
81172: , PA_XLA_EXP_HEADER_V h2
81173: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
81174: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
81175: AND xet.event_class_code = C_EVENT_CLASS_CODE
81176: AND h2.event_id = xet.event_id

Line 81667: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;

81663: --
81664: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
81665: --
81666:
81667: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
81668: TYPE t_array_source_37 IS TABLE OF PA_XLA_EXP_HEADER_V.SYSTEM_LINKAGE_FUNCTION%TYPE INDEX BY BINARY_INTEGER;
81669: TYPE t_array_source_88 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
81670:
81671: TYPE t_array_source_2 IS TABLE OF PA_XLA_CDL_LINES_V.BUDGET_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 81668: TYPE t_array_source_37 IS TABLE OF PA_XLA_EXP_HEADER_V.SYSTEM_LINKAGE_FUNCTION%TYPE INDEX BY BINARY_INTEGER;

81664: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
81665: --
81666:
81667: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
81668: TYPE t_array_source_37 IS TABLE OF PA_XLA_EXP_HEADER_V.SYSTEM_LINKAGE_FUNCTION%TYPE INDEX BY BINARY_INTEGER;
81669: TYPE t_array_source_88 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
81670:
81671: TYPE t_array_source_2 IS TABLE OF PA_XLA_CDL_LINES_V.BUDGET_CCID%TYPE INDEX BY BINARY_INTEGER;
81672: TYPE t_array_source_3 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 81669: TYPE t_array_source_88 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

81665: --
81666:
81667: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
81668: TYPE t_array_source_37 IS TABLE OF PA_XLA_EXP_HEADER_V.SYSTEM_LINKAGE_FUNCTION%TYPE INDEX BY BINARY_INTEGER;
81669: TYPE t_array_source_88 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
81670:
81671: TYPE t_array_source_2 IS TABLE OF PA_XLA_CDL_LINES_V.BUDGET_CCID%TYPE INDEX BY BINARY_INTEGER;
81672: TYPE t_array_source_3 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;
81673: TYPE t_array_source_4 IS TABLE OF PA_XLA_CDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 81810: , PA_XLA_EXP_HEADER_V h2

81806: , h2.EXPENDITURE_ITEM_ID source_32
81807: , h2.SYSTEM_LINKAGE_FUNCTION source_37
81808: , h2.GL_DATE source_88
81809: FROM xla_events_gt xet
81810: , PA_XLA_EXP_HEADER_V h2
81811: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
81812: and xet.event_class_code = C_EVENT_CLASS_CODE
81813: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
81814:

Line 83158: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'

83154: FROM (
83155: SELECT xet.event_id event_id
83156: , 0 line_number
83157: , CASE r
83158: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
83159: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
83160:
83161: ELSE null
83162: END object_name

Line 83159: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'

83155: SELECT xet.event_id event_id
83156: , 0 line_number
83157: , CASE r
83158: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
83159: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
83160:
83161: ELSE null
83162: END object_name
83163: , CASE r

Line 83190: , PA_XLA_EXP_HEADER_V h2

83186: ELSE null
83187: END source_value
83188: , null source_meaning
83189: FROM xla_events_gt xet
83190: , PA_XLA_EXP_HEADER_V h2
83191: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
83192: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
83193: AND xet.event_class_code = C_EVENT_CLASS_CODE
83194: AND h2.event_id = xet.event_id

Line 83524: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;

83520: --
83521: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
83522: --
83523:
83524: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
83525: TYPE t_array_source_88 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
83526:
83527: TYPE t_array_source_3 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;
83528: TYPE t_array_source_4 IS TABLE OF PA_XLA_CDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 83525: TYPE t_array_source_88 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

83521: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
83522: --
83523:
83524: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
83525: TYPE t_array_source_88 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
83526:
83527: TYPE t_array_source_3 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;
83528: TYPE t_array_source_4 IS TABLE OF PA_XLA_CDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
83529: TYPE t_array_source_5 IS TABLE OF PA_XLA_CDL_LINES_V.ADJ_COST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 83601: , PA_XLA_EXP_HEADER_V h2

83597: ,xet.budgetary_control_flag
83598: , h2.EXPENDITURE_ITEM_ID source_32
83599: , h2.GL_DATE source_88
83600: FROM xla_events_gt xet
83601: , PA_XLA_EXP_HEADER_V h2
83602: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
83603: and xet.event_class_code = C_EVENT_CLASS_CODE
83604: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
83605:

Line 84456: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'

84452: FROM (
84453: SELECT xet.event_id event_id
84454: , 0 line_number
84455: , CASE r
84456: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
84457: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
84458:
84459: ELSE null
84460: END object_name

Line 84457: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'

84453: SELECT xet.event_id event_id
84454: , 0 line_number
84455: , CASE r
84456: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
84457: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
84458:
84459: ELSE null
84460: END object_name
84461: , CASE r

Line 84488: , PA_XLA_EXP_HEADER_V h2

84484: ELSE null
84485: END source_value
84486: , null source_meaning
84487: FROM xla_events_gt xet
84488: , PA_XLA_EXP_HEADER_V h2
84489: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
84490: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
84491: AND xet.event_class_code = C_EVENT_CLASS_CODE
84492: AND h2.event_id = xet.event_id

Line 84822: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;

84818: --
84819: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
84820: --
84821:
84822: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
84823: TYPE t_array_source_88 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
84824:
84825: TYPE t_array_source_3 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;
84826: TYPE t_array_source_4 IS TABLE OF PA_XLA_CDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 84823: TYPE t_array_source_88 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

84819: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
84820: --
84821:
84822: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
84823: TYPE t_array_source_88 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
84824:
84825: TYPE t_array_source_3 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;
84826: TYPE t_array_source_4 IS TABLE OF PA_XLA_CDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
84827: TYPE t_array_source_5 IS TABLE OF PA_XLA_CDL_LINES_V.ADJ_COST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 84899: , PA_XLA_EXP_HEADER_V h2

84895: ,xet.budgetary_control_flag
84896: , h2.EXPENDITURE_ITEM_ID source_32
84897: , h2.GL_DATE source_88
84898: FROM xla_events_gt xet
84899: , PA_XLA_EXP_HEADER_V h2
84900: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
84901: and xet.event_class_code = C_EVENT_CLASS_CODE
84902: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
84903:

Line 85754: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'

85750: FROM (
85751: SELECT xet.event_id event_id
85752: , 0 line_number
85753: , CASE r
85754: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
85755: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
85756:
85757: ELSE null
85758: END object_name

Line 85755: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'

85751: SELECT xet.event_id event_id
85752: , 0 line_number
85753: , CASE r
85754: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
85755: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
85756:
85757: ELSE null
85758: END object_name
85759: , CASE r

Line 85786: , PA_XLA_EXP_HEADER_V h2

85782: ELSE null
85783: END source_value
85784: , null source_meaning
85785: FROM xla_events_gt xet
85786: , PA_XLA_EXP_HEADER_V h2
85787: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
85788: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
85789: AND xet.event_class_code = C_EVENT_CLASS_CODE
85790: AND h2.event_id = xet.event_id

Line 86120: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;

86116: --
86117: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
86118: --
86119:
86120: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
86121: TYPE t_array_source_88 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
86122:
86123: TYPE t_array_source_3 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;
86124: TYPE t_array_source_4 IS TABLE OF PA_XLA_CDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 86121: TYPE t_array_source_88 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

86117: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
86118: --
86119:
86120: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
86121: TYPE t_array_source_88 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
86122:
86123: TYPE t_array_source_3 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;
86124: TYPE t_array_source_4 IS TABLE OF PA_XLA_CDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
86125: TYPE t_array_source_5 IS TABLE OF PA_XLA_CDL_LINES_V.ADJ_COST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 86197: , PA_XLA_EXP_HEADER_V h2

86193: ,xet.budgetary_control_flag
86194: , h2.EXPENDITURE_ITEM_ID source_32
86195: , h2.GL_DATE source_88
86196: FROM xla_events_gt xet
86197: , PA_XLA_EXP_HEADER_V h2
86198: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
86199: and xet.event_class_code = C_EVENT_CLASS_CODE
86200: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
86201:

Line 87052: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'

87048: FROM (
87049: SELECT xet.event_id event_id
87050: , 0 line_number
87051: , CASE r
87052: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
87053: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
87054:
87055: ELSE null
87056: END object_name

Line 87053: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'

87049: SELECT xet.event_id event_id
87050: , 0 line_number
87051: , CASE r
87052: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
87053: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
87054:
87055: ELSE null
87056: END object_name
87057: , CASE r

Line 87084: , PA_XLA_EXP_HEADER_V h2

87080: ELSE null
87081: END source_value
87082: , null source_meaning
87083: FROM xla_events_gt xet
87084: , PA_XLA_EXP_HEADER_V h2
87085: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
87086: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
87087: AND xet.event_class_code = C_EVENT_CLASS_CODE
87088: AND h2.event_id = xet.event_id

Line 87418: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;

87414: --
87415: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
87416: --
87417:
87418: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
87419: TYPE t_array_source_88 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
87420:
87421: TYPE t_array_source_3 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;
87422: TYPE t_array_source_4 IS TABLE OF PA_XLA_CDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 87419: TYPE t_array_source_88 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

87415: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
87416: --
87417:
87418: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
87419: TYPE t_array_source_88 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
87420:
87421: TYPE t_array_source_3 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;
87422: TYPE t_array_source_4 IS TABLE OF PA_XLA_CDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
87423: TYPE t_array_source_5 IS TABLE OF PA_XLA_CDL_LINES_V.ADJ_COST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 87495: , PA_XLA_EXP_HEADER_V h2

87491: ,xet.budgetary_control_flag
87492: , h2.EXPENDITURE_ITEM_ID source_32
87493: , h2.GL_DATE source_88
87494: FROM xla_events_gt xet
87495: , PA_XLA_EXP_HEADER_V h2
87496: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
87497: and xet.event_class_code = C_EVENT_CLASS_CODE
87498: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
87499: