DBA Data[Home] [Help]

APPS.XLA_00201_AAD_S_000005_BC_PKG dependencies on FND_LOOKUP_VALUES

Line 48838: , fnd_lookup_values fvl14

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
48842: AND l1.event_id = xet.event_id

Line 48975: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

48971: l_balance_type_code VARCHAR2(1) :=NULL;
48972: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
48973:
48974: --
48975: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
48976: --
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:

Line 49198: , fnd_lookup_values fvl14

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
49202: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 51366: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

51362: l_balance_type_code VARCHAR2(1) :=NULL;
51363: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
51364:
51365: --
51366: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
51367: --
51368:
51369: TYPE t_array_source_1 IS TABLE OF PO_EXTRACT_HEADER_V.PO_TYPE%TYPE INDEX BY BINARY_INTEGER;
51370: TYPE t_array_source_2 IS TABLE OF PO_EXTRACT_HEADER_V.PO_NUMBER%TYPE INDEX BY BINARY_INTEGER;

Line 53155: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

53151: l_balance_type_code VARCHAR2(1) :=NULL;
53152: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
53153:
53154: --
53155: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
53156: --
53157:
53158: TYPE t_array_source_1 IS TABLE OF PO_EXTRACT_HEADER_V.PO_TYPE%TYPE INDEX BY BINARY_INTEGER;
53159: TYPE t_array_source_2 IS TABLE OF PO_EXTRACT_HEADER_V.PO_NUMBER%TYPE INDEX BY BINARY_INTEGER;

Line 54782: , fnd_lookup_values fvl14

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
54786: AND l1.event_id = xet.event_id

Line 54919: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

54915: l_balance_type_code VARCHAR2(1) :=NULL;
54916: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
54917:
54918: --
54919: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
54920: --
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:

Line 55142: , fnd_lookup_values fvl14

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
55146: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 57400: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

57396: l_balance_type_code VARCHAR2(1) :=NULL;
57397: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
57398:
57399: --
57400: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
57401: --
57402:
57403: TYPE t_array_source_9 IS TABLE OF PO_REQ_EXTRACT_HEADER_V.DOCUMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
57404: TYPE t_array_source_10 IS TABLE OF PO_REQ_EXTRACT_HEADER_V.REQ_NUMBER%TYPE INDEX BY BINARY_INTEGER;

Line 58719: , fnd_lookup_values fvl14

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
58723: AND l1.event_id = xet.event_id

Line 58856: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

58852: l_balance_type_code VARCHAR2(1) :=NULL;
58853: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
58854:
58855: --
58856: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
58857: --
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:

Line 59061: , fnd_lookup_values fvl14

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
59065: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id