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