DBA Data[Home] [Help]

APPS.XLA_00201_AAD_S_000005_BC_PKG dependencies on PA_XLA_TASK_REF_V

Line 48574: WHEN 2 THEN 'PA_XLA_TASK_REF_V'

48570: SELECT xet.event_id event_id
48571: , l1.line_number line_number
48572: , CASE r
48573: WHEN 1 THEN 'PA_XLA_PROJECT_REF_V'
48574: WHEN 2 THEN 'PA_XLA_TASK_REF_V'
48575: WHEN 3 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
48576: WHEN 4 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
48577: WHEN 5 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
48578: WHEN 6 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'

Line 48837: , PA_XLA_TASK_REF_V l4

48833: END source_meaning
48834: FROM xla_events_gt xet
48835: , PA_XLA_BC_PKT_PO_DETAIL_V l1
48836: , PA_XLA_PROJECT_REF_V l3
48837: , PA_XLA_TASK_REF_V l4
48838: , fnd_lookup_values fvl14
48839: , (select rownum r from all_objects where rownum <= 46 and owner = p_apps_owner)
48840: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
48841: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 48981: TYPE t_array_source_4 IS TABLE OF PA_XLA_TASK_REF_V.TASK_NAME%TYPE INDEX BY BINARY_INTEGER;

48977:
48978: TYPE t_array_source_79 IS TABLE OF PA_XLA_BC_PKT_PO_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
48979:
48980: TYPE t_array_source_3 IS TABLE OF PA_XLA_PROJECT_REF_V.PROJECT_NAME%TYPE INDEX BY BINARY_INTEGER;
48981: TYPE t_array_source_4 IS TABLE OF PA_XLA_TASK_REF_V.TASK_NAME%TYPE INDEX BY BINARY_INTEGER;
48982: TYPE t_array_source_5 IS TABLE OF PA_XLA_BC_PKT_PO_DETAIL_V.EXPENDITURE_ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
48983: TYPE t_array_source_6 IS TABLE OF PA_XLA_BC_PKT_PO_DETAIL_V.EXPENDITURE_TYPE%TYPE INDEX BY BINARY_INTEGER;
48984: TYPE t_array_source_9 IS TABLE OF PA_XLA_BC_PKT_PO_DETAIL_V.DOCUMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
48985: TYPE t_array_source_11 IS TABLE OF PA_XLA_BC_PKT_PO_DETAIL_V.BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 49197: , PA_XLA_TASK_REF_V l4

49193: , l1.PA_SECOND_DIST_ID source_73
49194: FROM xla_events_gt xet
49195: , PA_XLA_BC_PKT_PO_DETAIL_V l1
49196: , PA_XLA_PROJECT_REF_V l3
49197: , PA_XLA_TASK_REF_V l4
49198: , fnd_lookup_values fvl14
49199: WHERE xet.event_id between x_first_event_id and x_last_event_id
49200: and xet.event_date between p_pad_start_date and p_pad_end_date
49201: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 54518: WHEN 2 THEN 'PA_XLA_TASK_REF_V'

54514: SELECT xet.event_id event_id
54515: , l1.line_number line_number
54516: , CASE r
54517: WHEN 1 THEN 'PA_XLA_PROJECT_REF_V'
54518: WHEN 2 THEN 'PA_XLA_TASK_REF_V'
54519: WHEN 3 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
54520: WHEN 4 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
54521: WHEN 5 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
54522: WHEN 6 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'

Line 54781: , PA_XLA_TASK_REF_V l4

54777: END source_meaning
54778: FROM xla_events_gt xet
54779: , PA_XLA_BC_PKT_PO_DETAIL_V l1
54780: , PA_XLA_PROJECT_REF_V l3
54781: , PA_XLA_TASK_REF_V l4
54782: , fnd_lookup_values fvl14
54783: , (select rownum r from all_objects where rownum <= 46 and owner = p_apps_owner)
54784: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
54785: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 54925: TYPE t_array_source_4 IS TABLE OF PA_XLA_TASK_REF_V.TASK_NAME%TYPE INDEX BY BINARY_INTEGER;

54921:
54922: TYPE t_array_source_79 IS TABLE OF PA_XLA_BC_PKT_PO_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
54923:
54924: TYPE t_array_source_3 IS TABLE OF PA_XLA_PROJECT_REF_V.PROJECT_NAME%TYPE INDEX BY BINARY_INTEGER;
54925: TYPE t_array_source_4 IS TABLE OF PA_XLA_TASK_REF_V.TASK_NAME%TYPE INDEX BY BINARY_INTEGER;
54926: TYPE t_array_source_5 IS TABLE OF PA_XLA_BC_PKT_PO_DETAIL_V.EXPENDITURE_ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
54927: TYPE t_array_source_6 IS TABLE OF PA_XLA_BC_PKT_PO_DETAIL_V.EXPENDITURE_TYPE%TYPE INDEX BY BINARY_INTEGER;
54928: TYPE t_array_source_9 IS TABLE OF PA_XLA_BC_PKT_PO_DETAIL_V.DOCUMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
54929: TYPE t_array_source_11 IS TABLE OF PA_XLA_BC_PKT_PO_DETAIL_V.BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 55141: , PA_XLA_TASK_REF_V l4

55137: , l1.PA_SECOND_DIST_ID source_73
55138: FROM xla_events_gt xet
55139: , PA_XLA_BC_PKT_PO_DETAIL_V l1
55140: , PA_XLA_PROJECT_REF_V l3
55141: , PA_XLA_TASK_REF_V l4
55142: , fnd_lookup_values fvl14
55143: WHERE xet.event_id between x_first_event_id and x_last_event_id
55144: and xet.event_date between p_pad_start_date and p_pad_end_date
55145: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 58485: WHEN 2 THEN 'PA_XLA_TASK_REF_V'

58481: SELECT xet.event_id event_id
58482: , l1.line_number line_number
58483: , CASE r
58484: WHEN 1 THEN 'PA_XLA_PROJECT_REF_V'
58485: WHEN 2 THEN 'PA_XLA_TASK_REF_V'
58486: WHEN 3 THEN 'PA_XLA_BC_PKT_REQ_DETAIL_V'
58487: WHEN 4 THEN 'PA_XLA_BC_PKT_REQ_DETAIL_V'
58488: WHEN 5 THEN 'PA_XLA_BC_PKT_REQ_DETAIL_V'
58489: WHEN 6 THEN 'PA_XLA_BC_PKT_REQ_DETAIL_V'

Line 58718: , PA_XLA_TASK_REF_V l4

58714: END source_meaning
58715: FROM xla_events_gt xet
58716: , PA_XLA_BC_PKT_REQ_DETAIL_V l1
58717: , PA_XLA_PROJECT_REF_V l3
58718: , PA_XLA_TASK_REF_V l4
58719: , fnd_lookup_values fvl14
58720: , (select rownum r from all_objects where rownum <= 40 and owner = p_apps_owner)
58721: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
58722: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 58862: TYPE t_array_source_4 IS TABLE OF PA_XLA_TASK_REF_V.TASK_NAME%TYPE INDEX BY BINARY_INTEGER;

58858:
58859: TYPE t_array_source_79 IS TABLE OF PA_XLA_BC_PKT_REQ_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
58860:
58861: TYPE t_array_source_3 IS TABLE OF PA_XLA_PROJECT_REF_V.PROJECT_NAME%TYPE INDEX BY BINARY_INTEGER;
58862: TYPE t_array_source_4 IS TABLE OF PA_XLA_TASK_REF_V.TASK_NAME%TYPE INDEX BY BINARY_INTEGER;
58863: TYPE t_array_source_5 IS TABLE OF PA_XLA_BC_PKT_REQ_DETAIL_V.EXPENDITURE_ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
58864: TYPE t_array_source_6 IS TABLE OF PA_XLA_BC_PKT_REQ_DETAIL_V.EXPENDITURE_TYPE%TYPE INDEX BY BINARY_INTEGER;
58865: TYPE t_array_source_11 IS TABLE OF PA_XLA_BC_PKT_REQ_DETAIL_V.BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
58866: TYPE t_array_source_13 IS TABLE OF PA_XLA_BC_PKT_REQ_DETAIL_V.MAIN_OR_BACKING_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 59060: , PA_XLA_TASK_REF_V l4

59056: , l1.DOCUMENT_DISTRIBUTION_TYPE source_74
59057: FROM xla_events_gt xet
59058: , PA_XLA_BC_PKT_REQ_DETAIL_V l1
59059: , PA_XLA_PROJECT_REF_V l3
59060: , PA_XLA_TASK_REF_V l4
59061: , fnd_lookup_values fvl14
59062: WHERE xet.event_id between x_first_event_id and x_last_event_id
59063: and xet.event_date between p_pad_start_date and p_pad_end_date
59064: and xet.event_class_code = C_EVENT_CLASS_CODE