DBA Data[Home] [Help]

APPS.XLA_08901_AAD_S_000002_PKG dependencies on FND_LOOKUP_VALUES

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

6019: l_balance_type_code VARCHAR2(1) :=NULL;
6020: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
6021:
6022: --
6023: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
6024: --
6025:
6026: TYPE t_array_source_25 IS TABLE OF FV_BE_BA_FD_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
6027:

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

6908: l_balance_type_code VARCHAR2(1) :=NULL;
6909: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
6910:
6911: --
6912: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
6913: --
6914:
6915: TYPE t_array_source_25 IS TABLE OF FV_BE_RPR_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
6916:

Line 7681: , fnd_lookup_values fvl9

7677: END source_meaning
7678: FROM xla_events_gt xet
7679: , AP_SYSTEM_PARAMETERS_EXTRACT_V h1
7680: , FV_TREASURY_EXTRACT_HEADER_V h3
7681: , fnd_lookup_values fvl9
7682: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
7683: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
7684: AND xet.event_class_code = C_EVENT_CLASS_CODE
7685: AND h3.event_id = xet.event_id

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

8007: l_balance_type_code VARCHAR2(1) :=NULL;
8008: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
8009:
8010: --
8011: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
8012: --
8013:
8014: TYPE t_array_source_5 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
8015: TYPE t_array_source_9 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 8101: , fnd_lookup_values fvl9

8097: , h3.TREASURY_CONFIRMATION_ID source_13
8098: FROM xla_events_gt xet
8099: , AP_SYSTEM_PARAMETERS_EXTRACT_V h1
8100: , FV_TREASURY_EXTRACT_HEADER_V h3
8101: , fnd_lookup_values fvl9
8102: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
8103: and xet.event_class_code = C_EVENT_CLASS_CODE
8104: and xet.event_status_code <> 'N' AND h3.event_id = xet.event_id
8105: AND h3.org_id = h1.asp_org_id AND fvl9.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'