DBA Data[Home] [Help]

APPS.XLA_00200_AAD_S_000010_BC_PKG dependencies on PA_XLA_TASK_REF_V

Line 73899: WHEN 3 THEN 'PA_XLA_TASK_REF_V'

73895: , l1.line_number line_number
73896: , CASE r
73897: WHEN 1 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
73898: WHEN 2 THEN 'PA_XLA_PROJECT_REF_V'
73899: WHEN 3 THEN 'PA_XLA_TASK_REF_V'
73900: WHEN 4 THEN 'PA_XLA_EXP_ORG_REF_V'
73901: WHEN 5 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
73902: WHEN 6 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
73903: WHEN 7 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'

Line 74187: , PA_XLA_TASK_REF_V l4

74183: FROM xla_events_gt xet
74184: , PA_XLA_BC_PKT_AP_DETAIL_V l1
74185: , PA_XLA_EXP_ORG_REF_V l2
74186: , PA_XLA_PROJECT_REF_V l3
74187: , PA_XLA_TASK_REF_V l4
74188: , fnd_lookup_values fvl108
74189: , (select rownum r from all_objects where rownum <= 51 and owner = p_apps_owner)
74190: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
74191: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 74333: TYPE t_array_source_4 IS TABLE OF PA_XLA_TASK_REF_V.TASK_NUMBER%TYPE INDEX BY BINARY_INTEGER;

74329:
74330:
74331: TYPE t_array_source_2 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.DOCUMENT_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
74332: TYPE t_array_source_3 IS TABLE OF PA_XLA_PROJECT_REF_V.PROJECT_NAME%TYPE INDEX BY BINARY_INTEGER;
74333: TYPE t_array_source_4 IS TABLE OF PA_XLA_TASK_REF_V.TASK_NUMBER%TYPE INDEX BY BINARY_INTEGER;
74334: TYPE t_array_source_5 IS TABLE OF PA_XLA_EXP_ORG_REF_V.EXPENDITURE_ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
74335: TYPE t_array_source_14 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.BUDGET_CCID%TYPE INDEX BY BINARY_INTEGER;
74336: TYPE t_array_source_21 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
74337: TYPE t_array_source_30 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_INVOICE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 74560: , PA_XLA_TASK_REF_V l4

74556: FROM xla_events_gt xet
74557: , PA_XLA_BC_PKT_AP_DETAIL_V l1
74558: , PA_XLA_EXP_ORG_REF_V l2
74559: , PA_XLA_PROJECT_REF_V l3
74560: , PA_XLA_TASK_REF_V l4
74561: , fnd_lookup_values fvl108
74562: WHERE xet.event_id between x_first_event_id and x_last_event_id
74563: and xet.event_date between p_pad_start_date and p_pad_end_date
74564: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 80229: WHEN 3 THEN 'PA_XLA_TASK_REF_V'

80225: , l1.line_number line_number
80226: , CASE r
80227: WHEN 1 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
80228: WHEN 2 THEN 'PA_XLA_PROJECT_REF_V'
80229: WHEN 3 THEN 'PA_XLA_TASK_REF_V'
80230: WHEN 4 THEN 'PA_XLA_EXP_ORG_REF_V'
80231: WHEN 5 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
80232: WHEN 6 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
80233: WHEN 7 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'

Line 80487: , PA_XLA_TASK_REF_V l4

80483: FROM xla_events_gt xet
80484: , PA_XLA_BC_PKT_AP_DETAIL_V l1
80485: , PA_XLA_EXP_ORG_REF_V l2
80486: , PA_XLA_PROJECT_REF_V l3
80487: , PA_XLA_TASK_REF_V l4
80488: , fnd_lookup_values fvl108
80489: , (select rownum r from all_objects where rownum <= 45 and owner = p_apps_owner)
80490: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
80491: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 80633: TYPE t_array_source_4 IS TABLE OF PA_XLA_TASK_REF_V.TASK_NUMBER%TYPE INDEX BY BINARY_INTEGER;

80629:
80630:
80631: TYPE t_array_source_2 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.DOCUMENT_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
80632: TYPE t_array_source_3 IS TABLE OF PA_XLA_PROJECT_REF_V.PROJECT_NAME%TYPE INDEX BY BINARY_INTEGER;
80633: TYPE t_array_source_4 IS TABLE OF PA_XLA_TASK_REF_V.TASK_NUMBER%TYPE INDEX BY BINARY_INTEGER;
80634: TYPE t_array_source_5 IS TABLE OF PA_XLA_EXP_ORG_REF_V.EXPENDITURE_ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
80635: TYPE t_array_source_11 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
80636: TYPE t_array_source_14 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.BUDGET_CCID%TYPE INDEX BY BINARY_INTEGER;
80637: TYPE t_array_source_21 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 80842: , PA_XLA_TASK_REF_V l4

80838: FROM xla_events_gt xet
80839: , PA_XLA_BC_PKT_AP_DETAIL_V l1
80840: , PA_XLA_EXP_ORG_REF_V l2
80841: , PA_XLA_PROJECT_REF_V l3
80842: , PA_XLA_TASK_REF_V l4
80843: , fnd_lookup_values fvl108
80844: WHERE xet.event_id between x_first_event_id and x_last_event_id
80845: and xet.event_date between p_pad_start_date and p_pad_end_date
80846: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 81894: WHEN 3 THEN 'PA_XLA_TASK_REF_V'

81890: , l1.line_number line_number
81891: , CASE r
81892: WHEN 1 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
81893: WHEN 2 THEN 'PA_XLA_PROJECT_REF_V'
81894: WHEN 3 THEN 'PA_XLA_TASK_REF_V'
81895: WHEN 4 THEN 'PA_XLA_EXP_ORG_REF_V'
81896: WHEN 5 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
81897: WHEN 6 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
81898: WHEN 7 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'

Line 82137: , PA_XLA_TASK_REF_V l4

82133: FROM xla_events_gt xet
82134: , PA_XLA_BC_PKT_AP_DETAIL_V l1
82135: , PA_XLA_EXP_ORG_REF_V l2
82136: , PA_XLA_PROJECT_REF_V l3
82137: , PA_XLA_TASK_REF_V l4
82138: , fnd_lookup_values fvl108
82139: , (select rownum r from all_objects where rownum <= 42 and owner = p_apps_owner)
82140: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
82141: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 82283: TYPE t_array_source_4 IS TABLE OF PA_XLA_TASK_REF_V.TASK_NUMBER%TYPE INDEX BY BINARY_INTEGER;

82279:
82280:
82281: TYPE t_array_source_2 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.DOCUMENT_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
82282: TYPE t_array_source_3 IS TABLE OF PA_XLA_PROJECT_REF_V.PROJECT_NAME%TYPE INDEX BY BINARY_INTEGER;
82283: TYPE t_array_source_4 IS TABLE OF PA_XLA_TASK_REF_V.TASK_NUMBER%TYPE INDEX BY BINARY_INTEGER;
82284: TYPE t_array_source_5 IS TABLE OF PA_XLA_EXP_ORG_REF_V.EXPENDITURE_ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
82285: TYPE t_array_source_11 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
82286: TYPE t_array_source_14 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.BUDGET_CCID%TYPE INDEX BY BINARY_INTEGER;
82287: TYPE t_array_source_21 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 82483: , PA_XLA_TASK_REF_V l4

82479: FROM xla_events_gt xet
82480: , PA_XLA_BC_PKT_AP_DETAIL_V l1
82481: , PA_XLA_EXP_ORG_REF_V l2
82482: , PA_XLA_PROJECT_REF_V l3
82483: , PA_XLA_TASK_REF_V l4
82484: , fnd_lookup_values fvl108
82485: WHERE xet.event_id between x_first_event_id and x_last_event_id
82486: and xet.event_date between p_pad_start_date and p_pad_end_date
82487: and xet.event_class_code = C_EVENT_CLASS_CODE