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

Line 55272: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'

55268: FROM (
55269: SELECT xet.event_id event_id
55270: , 0 line_number
55271: , CASE r
55272: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
55273: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
55274: WHEN 3 THEN 'PA_XLA_EXP_HEADER_V'
55275:
55276: ELSE null

Line 55273: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'

55269: SELECT xet.event_id event_id
55270: , 0 line_number
55271: , CASE r
55272: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
55273: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
55274: WHEN 3 THEN 'PA_XLA_EXP_HEADER_V'
55275:
55276: ELSE null
55277: END object_name

Line 55274: WHEN 3 THEN 'PA_XLA_EXP_HEADER_V'

55270: , 0 line_number
55271: , CASE r
55272: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
55273: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
55274: WHEN 3 THEN 'PA_XLA_EXP_HEADER_V'
55275:
55276: ELSE null
55277: END object_name
55278: , CASE r

Line 55313: , PA_XLA_EXP_HEADER_V h2

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

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

55648: --
55649: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
55650: --
55651:
55652: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
55653: TYPE t_array_source_67 IS TABLE OF PA_XLA_EXP_HEADER_V.TP_AMT_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
55654: TYPE t_array_source_87 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
55655:
55656: TYPE t_array_source_4 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;

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

55649: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
55650: --
55651:
55652: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
55653: TYPE t_array_source_67 IS TABLE OF PA_XLA_EXP_HEADER_V.TP_AMT_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
55654: TYPE t_array_source_87 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
55655:
55656: TYPE t_array_source_4 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
55657: TYPE t_array_source_8 IS TABLE OF PA_XLA_CCDL_LINES_V.PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 55654: TYPE t_array_source_87 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

55650: --
55651:
55652: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
55653: TYPE t_array_source_67 IS TABLE OF PA_XLA_EXP_HEADER_V.TP_AMT_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
55654: TYPE t_array_source_87 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
55655:
55656: TYPE t_array_source_4 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
55657: TYPE t_array_source_8 IS TABLE OF PA_XLA_CCDL_LINES_V.PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
55658: TYPE t_array_source_9 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 55734: , PA_XLA_EXP_HEADER_V h2

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

Line 56680: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'

56676: FROM (
56677: SELECT xet.event_id event_id
56678: , 0 line_number
56679: , CASE r
56680: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
56681: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
56682: WHEN 3 THEN 'PA_XLA_EXP_HEADER_V'
56683:
56684: ELSE null

Line 56681: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'

56677: SELECT xet.event_id event_id
56678: , 0 line_number
56679: , CASE r
56680: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
56681: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
56682: WHEN 3 THEN 'PA_XLA_EXP_HEADER_V'
56683:
56684: ELSE null
56685: END object_name

Line 56682: WHEN 3 THEN 'PA_XLA_EXP_HEADER_V'

56678: , 0 line_number
56679: , CASE r
56680: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
56681: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
56682: WHEN 3 THEN 'PA_XLA_EXP_HEADER_V'
56683:
56684: ELSE null
56685: END object_name
56686: , CASE r

Line 56721: , PA_XLA_EXP_HEADER_V h2

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

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

57056: --
57057: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
57058: --
57059:
57060: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
57061: TYPE t_array_source_67 IS TABLE OF PA_XLA_EXP_HEADER_V.TP_AMT_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
57062: TYPE t_array_source_87 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
57063:
57064: TYPE t_array_source_4 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;

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

57057: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
57058: --
57059:
57060: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
57061: TYPE t_array_source_67 IS TABLE OF PA_XLA_EXP_HEADER_V.TP_AMT_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
57062: TYPE t_array_source_87 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
57063:
57064: TYPE t_array_source_4 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
57065: TYPE t_array_source_8 IS TABLE OF PA_XLA_CCDL_LINES_V.PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 57062: TYPE t_array_source_87 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

57058: --
57059:
57060: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
57061: TYPE t_array_source_67 IS TABLE OF PA_XLA_EXP_HEADER_V.TP_AMT_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
57062: TYPE t_array_source_87 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
57063:
57064: TYPE t_array_source_4 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
57065: TYPE t_array_source_8 IS TABLE OF PA_XLA_CCDL_LINES_V.PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
57066: TYPE t_array_source_9 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 57142: , PA_XLA_EXP_HEADER_V h2

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

Line 59212: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'

59208: FROM (
59209: SELECT xet.event_id event_id
59210: , 0 line_number
59211: , CASE r
59212: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
59213: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
59214:
59215: ELSE null
59216: END object_name

Line 59213: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'

59209: SELECT xet.event_id event_id
59210: , 0 line_number
59211: , CASE r
59212: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
59213: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
59214:
59215: ELSE null
59216: END object_name
59217: , CASE r

Line 59244: , PA_XLA_EXP_HEADER_V h2

59240: ELSE null
59241: END source_value
59242: , null source_meaning
59243: FROM xla_events_gt xet
59244: , PA_XLA_EXP_HEADER_V h2
59245: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
59246: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
59247: AND xet.event_class_code = C_EVENT_CLASS_CODE
59248: AND h2.event_id = xet.event_id

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

59639: --
59640: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
59641: --
59642:
59643: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
59644: TYPE t_array_source_87 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
59645:
59646: TYPE t_array_source_2 IS TABLE OF PA_XLA_CDL_LINES_V.BUDGET_CCID%TYPE INDEX BY BINARY_INTEGER;
59647: TYPE t_array_source_3 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 59644: TYPE t_array_source_87 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

59640: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
59641: --
59642:
59643: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
59644: TYPE t_array_source_87 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
59645:
59646: TYPE t_array_source_2 IS TABLE OF PA_XLA_CDL_LINES_V.BUDGET_CCID%TYPE INDEX BY BINARY_INTEGER;
59647: TYPE t_array_source_3 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;
59648: TYPE t_array_source_4 IS TABLE OF PA_XLA_CDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 59746: , PA_XLA_EXP_HEADER_V h2

59742: ,xet.budgetary_control_flag
59743: , h2.EXPENDITURE_ITEM_ID source_32
59744: , h2.GL_DATE source_87
59745: FROM xla_events_gt xet
59746: , PA_XLA_EXP_HEADER_V h2
59747: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
59748: and xet.event_class_code = C_EVENT_CLASS_CODE
59749: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
59750:

Line 60679: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'

60675: FROM (
60676: SELECT xet.event_id event_id
60677: , 0 line_number
60678: , CASE r
60679: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
60680: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
60681: WHEN 3 THEN 'PA_XLA_EXP_HEADER_V'
60682:
60683: ELSE null

Line 60680: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'

60676: SELECT xet.event_id event_id
60677: , 0 line_number
60678: , CASE r
60679: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
60680: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
60681: WHEN 3 THEN 'PA_XLA_EXP_HEADER_V'
60682:
60683: ELSE null
60684: END object_name

Line 60681: WHEN 3 THEN 'PA_XLA_EXP_HEADER_V'

60677: , 0 line_number
60678: , CASE r
60679: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
60680: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
60681: WHEN 3 THEN 'PA_XLA_EXP_HEADER_V'
60682:
60683: ELSE null
60684: END object_name
60685: , CASE r

Line 60716: , PA_XLA_EXP_HEADER_V h2

60712: ELSE null
60713: END source_value
60714: , null source_meaning
60715: FROM xla_events_gt xet
60716: , PA_XLA_EXP_HEADER_V h2
60717: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
60718: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
60719: AND xet.event_class_code = C_EVENT_CLASS_CODE
60720: AND h2.event_id = xet.event_id

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

61207: --
61208: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
61209: --
61210:
61211: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
61212: TYPE t_array_source_37 IS TABLE OF PA_XLA_EXP_HEADER_V.SYSTEM_LINKAGE_FUNCTION%TYPE INDEX BY BINARY_INTEGER;
61213: TYPE t_array_source_87 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
61214:
61215: TYPE t_array_source_2 IS TABLE OF PA_XLA_CDL_LINES_V.BUDGET_CCID%TYPE INDEX BY BINARY_INTEGER;

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

61208: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
61209: --
61210:
61211: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
61212: TYPE t_array_source_37 IS TABLE OF PA_XLA_EXP_HEADER_V.SYSTEM_LINKAGE_FUNCTION%TYPE INDEX BY BINARY_INTEGER;
61213: TYPE t_array_source_87 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
61214:
61215: TYPE t_array_source_2 IS TABLE OF PA_XLA_CDL_LINES_V.BUDGET_CCID%TYPE INDEX BY BINARY_INTEGER;
61216: TYPE t_array_source_3 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 61213: TYPE t_array_source_87 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

61209: --
61210:
61211: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
61212: TYPE t_array_source_37 IS TABLE OF PA_XLA_EXP_HEADER_V.SYSTEM_LINKAGE_FUNCTION%TYPE INDEX BY BINARY_INTEGER;
61213: TYPE t_array_source_87 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
61214:
61215: TYPE t_array_source_2 IS TABLE OF PA_XLA_CDL_LINES_V.BUDGET_CCID%TYPE INDEX BY BINARY_INTEGER;
61216: TYPE t_array_source_3 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;
61217: TYPE t_array_source_4 IS TABLE OF PA_XLA_CDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 61354: , PA_XLA_EXP_HEADER_V h2

61350: , h2.EXPENDITURE_ITEM_ID source_32
61351: , h2.SYSTEM_LINKAGE_FUNCTION source_37
61352: , h2.GL_DATE source_87
61353: FROM xla_events_gt xet
61354: , PA_XLA_EXP_HEADER_V h2
61355: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
61356: and xet.event_class_code = C_EVENT_CLASS_CODE
61357: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
61358:

Line 62689: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'

62685: FROM (
62686: SELECT xet.event_id event_id
62687: , 0 line_number
62688: , CASE r
62689: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
62690: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
62691:
62692: ELSE null
62693: END object_name

Line 62690: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'

62686: SELECT xet.event_id event_id
62687: , 0 line_number
62688: , CASE r
62689: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
62690: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
62691:
62692: ELSE null
62693: END object_name
62694: , CASE r

Line 62721: , PA_XLA_EXP_HEADER_V h2

62717: ELSE null
62718: END source_value
62719: , null source_meaning
62720: FROM xla_events_gt xet
62721: , PA_XLA_EXP_HEADER_V h2
62722: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
62723: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
62724: AND xet.event_class_code = C_EVENT_CLASS_CODE
62725: AND h2.event_id = xet.event_id

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

63051: --
63052: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
63053: --
63054:
63055: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
63056: TYPE t_array_source_87 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
63057:
63058: TYPE t_array_source_3 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;
63059: TYPE t_array_source_4 IS TABLE OF PA_XLA_CDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 63056: TYPE t_array_source_87 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

63052: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
63053: --
63054:
63055: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
63056: TYPE t_array_source_87 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
63057:
63058: TYPE t_array_source_3 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;
63059: TYPE t_array_source_4 IS TABLE OF PA_XLA_CDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
63060: TYPE t_array_source_5 IS TABLE OF PA_XLA_CDL_LINES_V.ADJ_COST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 63132: , PA_XLA_EXP_HEADER_V h2

63128: ,xet.budgetary_control_flag
63129: , h2.EXPENDITURE_ITEM_ID source_32
63130: , h2.GL_DATE source_87
63131: FROM xla_events_gt xet
63132: , PA_XLA_EXP_HEADER_V h2
63133: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
63134: and xet.event_class_code = C_EVENT_CLASS_CODE
63135: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
63136:

Line 63987: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'

63983: FROM (
63984: SELECT xet.event_id event_id
63985: , 0 line_number
63986: , CASE r
63987: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
63988: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
63989:
63990: ELSE null
63991: END object_name

Line 63988: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'

63984: SELECT xet.event_id event_id
63985: , 0 line_number
63986: , CASE r
63987: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
63988: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
63989:
63990: ELSE null
63991: END object_name
63992: , CASE r

Line 64019: , PA_XLA_EXP_HEADER_V h2

64015: ELSE null
64016: END source_value
64017: , null source_meaning
64018: FROM xla_events_gt xet
64019: , PA_XLA_EXP_HEADER_V h2
64020: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
64021: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
64022: AND xet.event_class_code = C_EVENT_CLASS_CODE
64023: AND h2.event_id = xet.event_id

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

64349: --
64350: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
64351: --
64352:
64353: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
64354: TYPE t_array_source_87 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
64355:
64356: TYPE t_array_source_3 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;
64357: TYPE t_array_source_4 IS TABLE OF PA_XLA_CDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 64354: TYPE t_array_source_87 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

64350: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
64351: --
64352:
64353: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
64354: TYPE t_array_source_87 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
64355:
64356: TYPE t_array_source_3 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;
64357: TYPE t_array_source_4 IS TABLE OF PA_XLA_CDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
64358: TYPE t_array_source_5 IS TABLE OF PA_XLA_CDL_LINES_V.ADJ_COST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 64430: , PA_XLA_EXP_HEADER_V h2

64426: ,xet.budgetary_control_flag
64427: , h2.EXPENDITURE_ITEM_ID source_32
64428: , h2.GL_DATE source_87
64429: FROM xla_events_gt xet
64430: , PA_XLA_EXP_HEADER_V h2
64431: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
64432: and xet.event_class_code = C_EVENT_CLASS_CODE
64433: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
64434:

Line 65285: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'

65281: FROM (
65282: SELECT xet.event_id event_id
65283: , 0 line_number
65284: , CASE r
65285: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
65286: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
65287:
65288: ELSE null
65289: END object_name

Line 65286: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'

65282: SELECT xet.event_id event_id
65283: , 0 line_number
65284: , CASE r
65285: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
65286: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
65287:
65288: ELSE null
65289: END object_name
65290: , CASE r

Line 65317: , PA_XLA_EXP_HEADER_V h2

65313: ELSE null
65314: END source_value
65315: , null source_meaning
65316: FROM xla_events_gt xet
65317: , PA_XLA_EXP_HEADER_V h2
65318: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
65319: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
65320: AND xet.event_class_code = C_EVENT_CLASS_CODE
65321: AND h2.event_id = xet.event_id

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

65647: --
65648: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
65649: --
65650:
65651: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
65652: TYPE t_array_source_87 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
65653:
65654: TYPE t_array_source_3 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;
65655: TYPE t_array_source_4 IS TABLE OF PA_XLA_CDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 65652: TYPE t_array_source_87 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

65648: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
65649: --
65650:
65651: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
65652: TYPE t_array_source_87 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
65653:
65654: TYPE t_array_source_3 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;
65655: TYPE t_array_source_4 IS TABLE OF PA_XLA_CDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
65656: TYPE t_array_source_5 IS TABLE OF PA_XLA_CDL_LINES_V.ADJ_COST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 65728: , PA_XLA_EXP_HEADER_V h2

65724: ,xet.budgetary_control_flag
65725: , h2.EXPENDITURE_ITEM_ID source_32
65726: , h2.GL_DATE source_87
65727: FROM xla_events_gt xet
65728: , PA_XLA_EXP_HEADER_V h2
65729: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
65730: and xet.event_class_code = C_EVENT_CLASS_CODE
65731: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
65732:

Line 66583: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'

66579: FROM (
66580: SELECT xet.event_id event_id
66581: , 0 line_number
66582: , CASE r
66583: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
66584: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
66585:
66586: ELSE null
66587: END object_name

Line 66584: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'

66580: SELECT xet.event_id event_id
66581: , 0 line_number
66582: , CASE r
66583: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
66584: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
66585:
66586: ELSE null
66587: END object_name
66588: , CASE r

Line 66615: , PA_XLA_EXP_HEADER_V h2

66611: ELSE null
66612: END source_value
66613: , null source_meaning
66614: FROM xla_events_gt xet
66615: , PA_XLA_EXP_HEADER_V h2
66616: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
66617: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
66618: AND xet.event_class_code = C_EVENT_CLASS_CODE
66619: AND h2.event_id = xet.event_id

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

66945: --
66946: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
66947: --
66948:
66949: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
66950: TYPE t_array_source_87 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
66951:
66952: TYPE t_array_source_3 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;
66953: TYPE t_array_source_4 IS TABLE OF PA_XLA_CDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 66950: TYPE t_array_source_87 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

66946: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
66947: --
66948:
66949: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
66950: TYPE t_array_source_87 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
66951:
66952: TYPE t_array_source_3 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;
66953: TYPE t_array_source_4 IS TABLE OF PA_XLA_CDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
66954: TYPE t_array_source_5 IS TABLE OF PA_XLA_CDL_LINES_V.ADJ_COST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 67026: , PA_XLA_EXP_HEADER_V h2

67022: ,xet.budgetary_control_flag
67023: , h2.EXPENDITURE_ITEM_ID source_32
67024: , h2.GL_DATE source_87
67025: FROM xla_events_gt xet
67026: , PA_XLA_EXP_HEADER_V h2
67027: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
67028: and xet.event_class_code = C_EVENT_CLASS_CODE
67029: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
67030:

Line 67881: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'

67877: FROM (
67878: SELECT xet.event_id event_id
67879: , 0 line_number
67880: , CASE r
67881: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
67882: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
67883:
67884: ELSE null
67885: END object_name

Line 67882: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'

67878: SELECT xet.event_id event_id
67879: , 0 line_number
67880: , CASE r
67881: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
67882: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
67883:
67884: ELSE null
67885: END object_name
67886: , CASE r

Line 67913: , PA_XLA_EXP_HEADER_V h2

67909: ELSE null
67910: END source_value
67911: , null source_meaning
67912: FROM xla_events_gt xet
67913: , PA_XLA_EXP_HEADER_V h2
67914: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
67915: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
67916: AND xet.event_class_code = C_EVENT_CLASS_CODE
67917: AND h2.event_id = xet.event_id

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

68243: --
68244: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
68245: --
68246:
68247: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
68248: TYPE t_array_source_87 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
68249:
68250: TYPE t_array_source_3 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;
68251: TYPE t_array_source_4 IS TABLE OF PA_XLA_CDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 68248: TYPE t_array_source_87 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

68244: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
68245: --
68246:
68247: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
68248: TYPE t_array_source_87 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
68249:
68250: TYPE t_array_source_3 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;
68251: TYPE t_array_source_4 IS TABLE OF PA_XLA_CDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
68252: TYPE t_array_source_5 IS TABLE OF PA_XLA_CDL_LINES_V.ADJ_COST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 68324: , PA_XLA_EXP_HEADER_V h2

68320: ,xet.budgetary_control_flag
68321: , h2.EXPENDITURE_ITEM_ID source_32
68322: , h2.GL_DATE source_87
68323: FROM xla_events_gt xet
68324: , PA_XLA_EXP_HEADER_V h2
68325: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
68326: and xet.event_class_code = C_EVENT_CLASS_CODE
68327: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
68328:

Line 69179: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'

69175: FROM (
69176: SELECT xet.event_id event_id
69177: , 0 line_number
69178: , CASE r
69179: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
69180: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
69181:
69182: ELSE null
69183: END object_name

Line 69180: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'

69176: SELECT xet.event_id event_id
69177: , 0 line_number
69178: , CASE r
69179: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
69180: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
69181:
69182: ELSE null
69183: END object_name
69184: , CASE r

Line 69211: , PA_XLA_EXP_HEADER_V h2

69207: ELSE null
69208: END source_value
69209: , null source_meaning
69210: FROM xla_events_gt xet
69211: , PA_XLA_EXP_HEADER_V h2
69212: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
69213: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
69214: AND xet.event_class_code = C_EVENT_CLASS_CODE
69215: AND h2.event_id = xet.event_id

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

69541: --
69542: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
69543: --
69544:
69545: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
69546: TYPE t_array_source_87 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
69547:
69548: TYPE t_array_source_3 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;
69549: TYPE t_array_source_4 IS TABLE OF PA_XLA_CDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 69546: TYPE t_array_source_87 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

69542: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
69543: --
69544:
69545: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
69546: TYPE t_array_source_87 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
69547:
69548: TYPE t_array_source_3 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;
69549: TYPE t_array_source_4 IS TABLE OF PA_XLA_CDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
69550: TYPE t_array_source_5 IS TABLE OF PA_XLA_CDL_LINES_V.ADJ_COST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 69622: , PA_XLA_EXP_HEADER_V h2

69618: ,xet.budgetary_control_flag
69619: , h2.EXPENDITURE_ITEM_ID source_32
69620: , h2.GL_DATE source_87
69621: FROM xla_events_gt xet
69622: , PA_XLA_EXP_HEADER_V h2
69623: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
69624: and xet.event_class_code = C_EVENT_CLASS_CODE
69625: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
69626:

Line 70477: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'

70473: FROM (
70474: SELECT xet.event_id event_id
70475: , 0 line_number
70476: , CASE r
70477: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
70478: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
70479:
70480: ELSE null
70481: END object_name

Line 70478: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'

70474: SELECT xet.event_id event_id
70475: , 0 line_number
70476: , CASE r
70477: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
70478: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
70479:
70480: ELSE null
70481: END object_name
70482: , CASE r

Line 70509: , PA_XLA_EXP_HEADER_V h2

70505: ELSE null
70506: END source_value
70507: , null source_meaning
70508: FROM xla_events_gt xet
70509: , PA_XLA_EXP_HEADER_V h2
70510: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
70511: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
70512: AND xet.event_class_code = C_EVENT_CLASS_CODE
70513: AND h2.event_id = xet.event_id

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

70839: --
70840: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
70841: --
70842:
70843: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
70844: TYPE t_array_source_87 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
70845:
70846: TYPE t_array_source_4 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
70847: TYPE t_array_source_11 IS TABLE OF PA_XLA_CCDL_LINES_V.DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 70844: TYPE t_array_source_87 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

70840: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
70841: --
70842:
70843: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
70844: TYPE t_array_source_87 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
70845:
70846: TYPE t_array_source_4 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
70847: TYPE t_array_source_11 IS TABLE OF PA_XLA_CCDL_LINES_V.DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
70848: TYPE t_array_source_12 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 70920: , PA_XLA_EXP_HEADER_V h2

70916: ,xet.budgetary_control_flag
70917: , h2.EXPENDITURE_ITEM_ID source_32
70918: , h2.GL_DATE source_87
70919: FROM xla_events_gt xet
70920: , PA_XLA_EXP_HEADER_V h2
70921: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
70922: and xet.event_class_code = C_EVENT_CLASS_CODE
70923: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
70924:

Line 71775: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'

71771: FROM (
71772: SELECT xet.event_id event_id
71773: , 0 line_number
71774: , CASE r
71775: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
71776: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
71777:
71778: ELSE null
71779: END object_name

Line 71776: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'

71772: SELECT xet.event_id event_id
71773: , 0 line_number
71774: , CASE r
71775: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
71776: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
71777:
71778: ELSE null
71779: END object_name
71780: , CASE r

Line 71807: , PA_XLA_EXP_HEADER_V h2

71803: ELSE null
71804: END source_value
71805: , null source_meaning
71806: FROM xla_events_gt xet
71807: , PA_XLA_EXP_HEADER_V h2
71808: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
71809: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
71810: AND xet.event_class_code = C_EVENT_CLASS_CODE
71811: AND h2.event_id = xet.event_id

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

72137: --
72138: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
72139: --
72140:
72141: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
72142: TYPE t_array_source_87 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
72143:
72144: TYPE t_array_source_4 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
72145: TYPE t_array_source_11 IS TABLE OF PA_XLA_CCDL_LINES_V.DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 72142: TYPE t_array_source_87 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

72138: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
72139: --
72140:
72141: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
72142: TYPE t_array_source_87 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
72143:
72144: TYPE t_array_source_4 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
72145: TYPE t_array_source_11 IS TABLE OF PA_XLA_CCDL_LINES_V.DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
72146: TYPE t_array_source_12 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 72218: , PA_XLA_EXP_HEADER_V h2

72214: ,xet.budgetary_control_flag
72215: , h2.EXPENDITURE_ITEM_ID source_32
72216: , h2.GL_DATE source_87
72217: FROM xla_events_gt xet
72218: , PA_XLA_EXP_HEADER_V h2
72219: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
72220: and xet.event_class_code = C_EVENT_CLASS_CODE
72221: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
72222:

Line 76249: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'

76245: FROM (
76246: SELECT xet.event_id event_id
76247: , 0 line_number
76248: , CASE r
76249: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
76250: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
76251: WHEN 3 THEN 'PA_XLA_EXP_HEADER_V'
76252:
76253: ELSE null

Line 76250: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'

76246: SELECT xet.event_id event_id
76247: , 0 line_number
76248: , CASE r
76249: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
76250: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
76251: WHEN 3 THEN 'PA_XLA_EXP_HEADER_V'
76252:
76253: ELSE null
76254: END object_name

Line 76251: WHEN 3 THEN 'PA_XLA_EXP_HEADER_V'

76247: , 0 line_number
76248: , CASE r
76249: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
76250: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
76251: WHEN 3 THEN 'PA_XLA_EXP_HEADER_V'
76252:
76253: ELSE null
76254: END object_name
76255: , CASE r

Line 76295: , PA_XLA_EXP_HEADER_V h2

76291:
76292: ELSE null
76293: END source_meaning
76294: FROM xla_events_gt xet
76295: , PA_XLA_EXP_HEADER_V h2
76296: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
76297: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
76298: AND xet.event_class_code = C_EVENT_CLASS_CODE
76299: AND h2.event_id = xet.event_id

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

76625: --
76626: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
76627: --
76628:
76629: TYPE t_array_source_21 IS TABLE OF PA_XLA_EXP_HEADER_V.EXCHANGE_RATE_VARIANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
76630: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
76631: TYPE t_array_source_87 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
76632:
76633: TYPE t_array_source_3 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;

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

76626: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
76627: --
76628:
76629: TYPE t_array_source_21 IS TABLE OF PA_XLA_EXP_HEADER_V.EXCHANGE_RATE_VARIANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
76630: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
76631: TYPE t_array_source_87 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
76632:
76633: TYPE t_array_source_3 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;
76634: TYPE t_array_source_4 IS TABLE OF PA_XLA_CDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 76631: TYPE t_array_source_87 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

76627: --
76628:
76629: TYPE t_array_source_21 IS TABLE OF PA_XLA_EXP_HEADER_V.EXCHANGE_RATE_VARIANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
76630: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
76631: TYPE t_array_source_87 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
76632:
76633: TYPE t_array_source_3 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;
76634: TYPE t_array_source_4 IS TABLE OF PA_XLA_CDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
76635: TYPE t_array_source_5 IS TABLE OF PA_XLA_CDL_LINES_V.ADJ_COST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 76709: , PA_XLA_EXP_HEADER_V h2

76705: , h2.EXCHANGE_RATE_VARIANCE_FLAG source_21
76706: , h2.EXPENDITURE_ITEM_ID source_32
76707: , h2.GL_DATE source_87
76708: FROM xla_events_gt xet
76709: , PA_XLA_EXP_HEADER_V h2
76710: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
76711: and xet.event_class_code = C_EVENT_CLASS_CODE
76712: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
76713:

Line 77644: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'

77640: FROM (
77641: SELECT xet.event_id event_id
77642: , 0 line_number
77643: , CASE r
77644: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
77645: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
77646: WHEN 3 THEN 'PA_XLA_EXP_HEADER_V'
77647:
77648: ELSE null

Line 77645: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'

77641: SELECT xet.event_id event_id
77642: , 0 line_number
77643: , CASE r
77644: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
77645: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
77646: WHEN 3 THEN 'PA_XLA_EXP_HEADER_V'
77647:
77648: ELSE null
77649: END object_name

Line 77646: WHEN 3 THEN 'PA_XLA_EXP_HEADER_V'

77642: , 0 line_number
77643: , CASE r
77644: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
77645: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
77646: WHEN 3 THEN 'PA_XLA_EXP_HEADER_V'
77647:
77648: ELSE null
77649: END object_name
77650: , CASE r

Line 77690: , PA_XLA_EXP_HEADER_V h2

77686:
77687: ELSE null
77688: END source_meaning
77689: FROM xla_events_gt xet
77690: , PA_XLA_EXP_HEADER_V h2
77691: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
77692: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
77693: AND xet.event_class_code = C_EVENT_CLASS_CODE
77694: AND h2.event_id = xet.event_id

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

78020: --
78021: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
78022: --
78023:
78024: TYPE t_array_source_21 IS TABLE OF PA_XLA_EXP_HEADER_V.EXCHANGE_RATE_VARIANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
78025: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
78026: TYPE t_array_source_87 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
78027:
78028: TYPE t_array_source_3 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;

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

78021: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
78022: --
78023:
78024: TYPE t_array_source_21 IS TABLE OF PA_XLA_EXP_HEADER_V.EXCHANGE_RATE_VARIANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
78025: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
78026: TYPE t_array_source_87 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
78027:
78028: TYPE t_array_source_3 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;
78029: TYPE t_array_source_4 IS TABLE OF PA_XLA_CDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 78026: TYPE t_array_source_87 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

78022: --
78023:
78024: TYPE t_array_source_21 IS TABLE OF PA_XLA_EXP_HEADER_V.EXCHANGE_RATE_VARIANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
78025: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
78026: TYPE t_array_source_87 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
78027:
78028: TYPE t_array_source_3 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;
78029: TYPE t_array_source_4 IS TABLE OF PA_XLA_CDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
78030: TYPE t_array_source_5 IS TABLE OF PA_XLA_CDL_LINES_V.ADJ_COST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 78104: , PA_XLA_EXP_HEADER_V h2

78100: , h2.EXCHANGE_RATE_VARIANCE_FLAG source_21
78101: , h2.EXPENDITURE_ITEM_ID source_32
78102: , h2.GL_DATE source_87
78103: FROM xla_events_gt xet
78104: , PA_XLA_EXP_HEADER_V h2
78105: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
78106: and xet.event_class_code = C_EVENT_CLASS_CODE
78107: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
78108:

Line 79039: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'

79035: FROM (
79036: SELECT xet.event_id event_id
79037: , 0 line_number
79038: , CASE r
79039: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
79040: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
79041: WHEN 3 THEN 'PA_XLA_EXP_HEADER_V'
79042:
79043: ELSE null

Line 79040: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'

79036: SELECT xet.event_id event_id
79037: , 0 line_number
79038: , CASE r
79039: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
79040: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
79041: WHEN 3 THEN 'PA_XLA_EXP_HEADER_V'
79042:
79043: ELSE null
79044: END object_name

Line 79041: WHEN 3 THEN 'PA_XLA_EXP_HEADER_V'

79037: , 0 line_number
79038: , CASE r
79039: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
79040: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
79041: WHEN 3 THEN 'PA_XLA_EXP_HEADER_V'
79042:
79043: ELSE null
79044: END object_name
79045: , CASE r

Line 79076: , PA_XLA_EXP_HEADER_V h2

79072: ELSE null
79073: END source_value
79074: , null source_meaning
79075: FROM xla_events_gt xet
79076: , PA_XLA_EXP_HEADER_V h2
79077: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
79078: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
79079: AND xet.event_class_code = C_EVENT_CLASS_CODE
79080: AND h2.event_id = xet.event_id

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

79562: --
79563: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
79564: --
79565:
79566: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
79567: TYPE t_array_source_37 IS TABLE OF PA_XLA_EXP_HEADER_V.SYSTEM_LINKAGE_FUNCTION%TYPE INDEX BY BINARY_INTEGER;
79568: TYPE t_array_source_87 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
79569:
79570: TYPE t_array_source_2 IS TABLE OF PA_XLA_CDL_LINES_V.BUDGET_CCID%TYPE INDEX BY BINARY_INTEGER;

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

79563: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
79564: --
79565:
79566: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
79567: TYPE t_array_source_37 IS TABLE OF PA_XLA_EXP_HEADER_V.SYSTEM_LINKAGE_FUNCTION%TYPE INDEX BY BINARY_INTEGER;
79568: TYPE t_array_source_87 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
79569:
79570: TYPE t_array_source_2 IS TABLE OF PA_XLA_CDL_LINES_V.BUDGET_CCID%TYPE INDEX BY BINARY_INTEGER;
79571: TYPE t_array_source_3 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 79568: TYPE t_array_source_87 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

79564: --
79565:
79566: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
79567: TYPE t_array_source_37 IS TABLE OF PA_XLA_EXP_HEADER_V.SYSTEM_LINKAGE_FUNCTION%TYPE INDEX BY BINARY_INTEGER;
79568: TYPE t_array_source_87 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
79569:
79570: TYPE t_array_source_2 IS TABLE OF PA_XLA_CDL_LINES_V.BUDGET_CCID%TYPE INDEX BY BINARY_INTEGER;
79571: TYPE t_array_source_3 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;
79572: TYPE t_array_source_4 IS TABLE OF PA_XLA_CDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 79707: , PA_XLA_EXP_HEADER_V h2

79703: , h2.EXPENDITURE_ITEM_ID source_32
79704: , h2.SYSTEM_LINKAGE_FUNCTION source_37
79705: , h2.GL_DATE source_87
79706: FROM xla_events_gt xet
79707: , PA_XLA_EXP_HEADER_V h2
79708: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
79709: and xet.event_class_code = C_EVENT_CLASS_CODE
79710: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
79711:

Line 81027: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'

81023: FROM (
81024: SELECT xet.event_id event_id
81025: , 0 line_number
81026: , CASE r
81027: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
81028: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
81029: WHEN 3 THEN 'PA_XLA_EXP_HEADER_V'
81030:
81031: ELSE null

Line 81028: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'

81024: SELECT xet.event_id event_id
81025: , 0 line_number
81026: , CASE r
81027: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
81028: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
81029: WHEN 3 THEN 'PA_XLA_EXP_HEADER_V'
81030:
81031: ELSE null
81032: END object_name

Line 81029: WHEN 3 THEN 'PA_XLA_EXP_HEADER_V'

81025: , 0 line_number
81026: , CASE r
81027: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
81028: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
81029: WHEN 3 THEN 'PA_XLA_EXP_HEADER_V'
81030:
81031: ELSE null
81032: END object_name
81033: , CASE r

Line 81064: , PA_XLA_EXP_HEADER_V h2

81060: ELSE null
81061: END source_value
81062: , null source_meaning
81063: FROM xla_events_gt xet
81064: , PA_XLA_EXP_HEADER_V h2
81065: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
81066: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
81067: AND xet.event_class_code = C_EVENT_CLASS_CODE
81068: AND h2.event_id = xet.event_id

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

81555: --
81556: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
81557: --
81558:
81559: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
81560: TYPE t_array_source_37 IS TABLE OF PA_XLA_EXP_HEADER_V.SYSTEM_LINKAGE_FUNCTION%TYPE INDEX BY BINARY_INTEGER;
81561: TYPE t_array_source_87 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
81562:
81563: TYPE t_array_source_2 IS TABLE OF PA_XLA_CDL_LINES_V.BUDGET_CCID%TYPE INDEX BY BINARY_INTEGER;

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

81556: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
81557: --
81558:
81559: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
81560: TYPE t_array_source_37 IS TABLE OF PA_XLA_EXP_HEADER_V.SYSTEM_LINKAGE_FUNCTION%TYPE INDEX BY BINARY_INTEGER;
81561: TYPE t_array_source_87 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
81562:
81563: TYPE t_array_source_2 IS TABLE OF PA_XLA_CDL_LINES_V.BUDGET_CCID%TYPE INDEX BY BINARY_INTEGER;
81564: TYPE t_array_source_3 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 81561: TYPE t_array_source_87 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

81557: --
81558:
81559: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
81560: TYPE t_array_source_37 IS TABLE OF PA_XLA_EXP_HEADER_V.SYSTEM_LINKAGE_FUNCTION%TYPE INDEX BY BINARY_INTEGER;
81561: TYPE t_array_source_87 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
81562:
81563: TYPE t_array_source_2 IS TABLE OF PA_XLA_CDL_LINES_V.BUDGET_CCID%TYPE INDEX BY BINARY_INTEGER;
81564: TYPE t_array_source_3 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;
81565: TYPE t_array_source_4 IS TABLE OF PA_XLA_CDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 81702: , PA_XLA_EXP_HEADER_V h2

81698: , h2.EXPENDITURE_ITEM_ID source_32
81699: , h2.SYSTEM_LINKAGE_FUNCTION source_37
81700: , h2.GL_DATE source_87
81701: FROM xla_events_gt xet
81702: , PA_XLA_EXP_HEADER_V h2
81703: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
81704: and xet.event_class_code = C_EVENT_CLASS_CODE
81705: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
81706:

Line 83050: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'

83046: FROM (
83047: SELECT xet.event_id event_id
83048: , 0 line_number
83049: , CASE r
83050: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
83051: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
83052:
83053: ELSE null
83054: END object_name

Line 83051: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'

83047: SELECT xet.event_id event_id
83048: , 0 line_number
83049: , CASE r
83050: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
83051: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
83052:
83053: ELSE null
83054: END object_name
83055: , CASE r

Line 83082: , PA_XLA_EXP_HEADER_V h2

83078: ELSE null
83079: END source_value
83080: , null source_meaning
83081: FROM xla_events_gt xet
83082: , PA_XLA_EXP_HEADER_V h2
83083: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
83084: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
83085: AND xet.event_class_code = C_EVENT_CLASS_CODE
83086: AND h2.event_id = xet.event_id

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

83412: --
83413: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
83414: --
83415:
83416: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
83417: TYPE t_array_source_87 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
83418:
83419: TYPE t_array_source_3 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;
83420: TYPE t_array_source_4 IS TABLE OF PA_XLA_CDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 83417: TYPE t_array_source_87 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

83413: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
83414: --
83415:
83416: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
83417: TYPE t_array_source_87 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
83418:
83419: TYPE t_array_source_3 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;
83420: TYPE t_array_source_4 IS TABLE OF PA_XLA_CDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
83421: TYPE t_array_source_5 IS TABLE OF PA_XLA_CDL_LINES_V.ADJ_COST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 83493: , PA_XLA_EXP_HEADER_V h2

83489: ,xet.budgetary_control_flag
83490: , h2.EXPENDITURE_ITEM_ID source_32
83491: , h2.GL_DATE source_87
83492: FROM xla_events_gt xet
83493: , PA_XLA_EXP_HEADER_V h2
83494: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
83495: and xet.event_class_code = C_EVENT_CLASS_CODE
83496: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
83497:

Line 84348: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'

84344: FROM (
84345: SELECT xet.event_id event_id
84346: , 0 line_number
84347: , CASE r
84348: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
84349: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
84350:
84351: ELSE null
84352: END object_name

Line 84349: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'

84345: SELECT xet.event_id event_id
84346: , 0 line_number
84347: , CASE r
84348: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
84349: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
84350:
84351: ELSE null
84352: END object_name
84353: , CASE r

Line 84380: , PA_XLA_EXP_HEADER_V h2

84376: ELSE null
84377: END source_value
84378: , null source_meaning
84379: FROM xla_events_gt xet
84380: , PA_XLA_EXP_HEADER_V h2
84381: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
84382: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
84383: AND xet.event_class_code = C_EVENT_CLASS_CODE
84384: AND h2.event_id = xet.event_id

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

84710: --
84711: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
84712: --
84713:
84714: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
84715: TYPE t_array_source_87 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
84716:
84717: TYPE t_array_source_3 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;
84718: TYPE t_array_source_4 IS TABLE OF PA_XLA_CDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 84715: TYPE t_array_source_87 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

84711: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
84712: --
84713:
84714: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
84715: TYPE t_array_source_87 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
84716:
84717: TYPE t_array_source_3 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;
84718: TYPE t_array_source_4 IS TABLE OF PA_XLA_CDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
84719: TYPE t_array_source_5 IS TABLE OF PA_XLA_CDL_LINES_V.ADJ_COST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 84791: , PA_XLA_EXP_HEADER_V h2

84787: ,xet.budgetary_control_flag
84788: , h2.EXPENDITURE_ITEM_ID source_32
84789: , h2.GL_DATE source_87
84790: FROM xla_events_gt xet
84791: , PA_XLA_EXP_HEADER_V h2
84792: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
84793: and xet.event_class_code = C_EVENT_CLASS_CODE
84794: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
84795:

Line 85646: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'

85642: FROM (
85643: SELECT xet.event_id event_id
85644: , 0 line_number
85645: , CASE r
85646: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
85647: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
85648:
85649: ELSE null
85650: END object_name

Line 85647: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'

85643: SELECT xet.event_id event_id
85644: , 0 line_number
85645: , CASE r
85646: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
85647: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
85648:
85649: ELSE null
85650: END object_name
85651: , CASE r

Line 85678: , PA_XLA_EXP_HEADER_V h2

85674: ELSE null
85675: END source_value
85676: , null source_meaning
85677: FROM xla_events_gt xet
85678: , PA_XLA_EXP_HEADER_V h2
85679: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
85680: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
85681: AND xet.event_class_code = C_EVENT_CLASS_CODE
85682: AND h2.event_id = xet.event_id

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

86008: --
86009: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
86010: --
86011:
86012: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
86013: TYPE t_array_source_87 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
86014:
86015: TYPE t_array_source_3 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;
86016: TYPE t_array_source_4 IS TABLE OF PA_XLA_CDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 86013: TYPE t_array_source_87 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

86009: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
86010: --
86011:
86012: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
86013: TYPE t_array_source_87 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
86014:
86015: TYPE t_array_source_3 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;
86016: TYPE t_array_source_4 IS TABLE OF PA_XLA_CDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
86017: TYPE t_array_source_5 IS TABLE OF PA_XLA_CDL_LINES_V.ADJ_COST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 86089: , PA_XLA_EXP_HEADER_V h2

86085: ,xet.budgetary_control_flag
86086: , h2.EXPENDITURE_ITEM_ID source_32
86087: , h2.GL_DATE source_87
86088: FROM xla_events_gt xet
86089: , PA_XLA_EXP_HEADER_V h2
86090: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
86091: and xet.event_class_code = C_EVENT_CLASS_CODE
86092: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
86093:

Line 86944: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'

86940: FROM (
86941: SELECT xet.event_id event_id
86942: , 0 line_number
86943: , CASE r
86944: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
86945: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
86946:
86947: ELSE null
86948: END object_name

Line 86945: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'

86941: SELECT xet.event_id event_id
86942: , 0 line_number
86943: , CASE r
86944: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
86945: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
86946:
86947: ELSE null
86948: END object_name
86949: , CASE r

Line 86976: , PA_XLA_EXP_HEADER_V h2

86972: ELSE null
86973: END source_value
86974: , null source_meaning
86975: FROM xla_events_gt xet
86976: , PA_XLA_EXP_HEADER_V h2
86977: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
86978: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
86979: AND xet.event_class_code = C_EVENT_CLASS_CODE
86980: AND h2.event_id = xet.event_id

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

87306: --
87307: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
87308: --
87309:
87310: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
87311: TYPE t_array_source_87 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
87312:
87313: TYPE t_array_source_3 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;
87314: TYPE t_array_source_4 IS TABLE OF PA_XLA_CDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 87311: TYPE t_array_source_87 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

87307: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
87308: --
87309:
87310: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
87311: TYPE t_array_source_87 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
87312:
87313: TYPE t_array_source_3 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;
87314: TYPE t_array_source_4 IS TABLE OF PA_XLA_CDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
87315: TYPE t_array_source_5 IS TABLE OF PA_XLA_CDL_LINES_V.ADJ_COST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 87387: , PA_XLA_EXP_HEADER_V h2

87383: ,xet.budgetary_control_flag
87384: , h2.EXPENDITURE_ITEM_ID source_32
87385: , h2.GL_DATE source_87
87386: FROM xla_events_gt xet
87387: , PA_XLA_EXP_HEADER_V h2
87388: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
87389: and xet.event_class_code = C_EVENT_CLASS_CODE
87390: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
87391: