DBA Data[Home] [Help]

APPS.XLA_00206_AAD_S_000004_BC_PKG dependencies on FND_LOOKUP_VALUES

Line 5950: , fnd_lookup_values fvl1

5946: ELSE null
5947: END source_meaning
5948: FROM xla_events_gt xet
5949: , LNS_LOAN_HEADERS_EXT_V h2
5950: , fnd_lookup_values fvl1
5951: , fnd_lookup_values fvl15
5952: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
5953: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
5954: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 5951: , fnd_lookup_values fvl15

5947: END source_meaning
5948: FROM xla_events_gt xet
5949: , LNS_LOAN_HEADERS_EXT_V h2
5950: , fnd_lookup_values fvl1
5951: , fnd_lookup_values fvl15
5952: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
5953: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
5954: AND xet.event_type_code = C_EVENT_TYPE_CODE
5955: AND h2.event_id = xet.event_id

Line 6109: , fnd_lookup_values fvl4

6105: ELSE null
6106: END source_meaning
6107: FROM xla_events_gt xet
6108: , LNS_LOAN_DETAILS_EXT_V l1
6109: , fnd_lookup_values fvl4
6110: , fnd_lookup_values fvl8
6111: , fnd_lookup_values fvl9
6112: , fnd_lookup_values fvl13
6113: ,(select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)

Line 6110: , fnd_lookup_values fvl8

6106: END source_meaning
6107: FROM xla_events_gt xet
6108: , LNS_LOAN_DETAILS_EXT_V l1
6109: , fnd_lookup_values fvl4
6110: , fnd_lookup_values fvl8
6111: , fnd_lookup_values fvl9
6112: , fnd_lookup_values fvl13
6113: ,(select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
6114: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 6111: , fnd_lookup_values fvl9

6107: FROM xla_events_gt xet
6108: , LNS_LOAN_DETAILS_EXT_V l1
6109: , fnd_lookup_values fvl4
6110: , fnd_lookup_values fvl8
6111: , fnd_lookup_values fvl9
6112: , fnd_lookup_values fvl13
6113: ,(select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
6114: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
6115: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 6112: , fnd_lookup_values fvl13

6108: , LNS_LOAN_DETAILS_EXT_V l1
6109: , fnd_lookup_values fvl4
6110: , fnd_lookup_values fvl8
6111: , fnd_lookup_values fvl9
6112: , fnd_lookup_values fvl13
6113: ,(select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
6114: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
6115: AND xet.event_type_code = C_EVENT_TYPE_CODE
6116: AND l1.event_id = xet.event_id

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

6257: l_balance_type_code VARCHAR2(1) :=NULL;
6258: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
6259:
6260: --
6261: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
6262: --
6263:
6264: TYPE t_array_source_1 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
6265: TYPE t_array_source_2 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 6355: , fnd_lookup_values fvl1

6351: , h2.EXCHANGE_RATE_TYPE source_18
6352: , h2.GL_DATE source_20
6353: FROM xla_events_gt xet
6354: , LNS_LOAN_HEADERS_EXT_V h2
6355: , fnd_lookup_values fvl1
6356: , fnd_lookup_values fvl15
6357: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
6358: and xet.event_type_code = C_EVENT_TYPE_CODE
6359: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id

Line 6356: , fnd_lookup_values fvl15

6352: , h2.GL_DATE source_20
6353: FROM xla_events_gt xet
6354: , LNS_LOAN_HEADERS_EXT_V h2
6355: , fnd_lookup_values fvl1
6356: , fnd_lookup_values fvl15
6357: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
6358: and xet.event_type_code = C_EVENT_TYPE_CODE
6359: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
6360: AND fvl1.lookup_type(+) = 'LOAN_CLASS'

Line 6419: , fnd_lookup_values fvl4

6415: , fvl13.meaning source_13_meaning
6416: , l1.DISTRIBUTION_AMOUNT source_14
6417: FROM xla_events_gt xet
6418: , LNS_LOAN_DETAILS_EXT_V l1
6419: , fnd_lookup_values fvl4
6420: , fnd_lookup_values fvl8
6421: , fnd_lookup_values fvl9
6422: , fnd_lookup_values fvl13
6423: WHERE xet.event_id between x_first_event_id and x_last_event_id

Line 6420: , fnd_lookup_values fvl8

6416: , l1.DISTRIBUTION_AMOUNT source_14
6417: FROM xla_events_gt xet
6418: , LNS_LOAN_DETAILS_EXT_V l1
6419: , fnd_lookup_values fvl4
6420: , fnd_lookup_values fvl8
6421: , fnd_lookup_values fvl9
6422: , fnd_lookup_values fvl13
6423: WHERE xet.event_id between x_first_event_id and x_last_event_id
6424: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 6421: , fnd_lookup_values fvl9

6417: FROM xla_events_gt xet
6418: , LNS_LOAN_DETAILS_EXT_V l1
6419: , fnd_lookup_values fvl4
6420: , fnd_lookup_values fvl8
6421: , fnd_lookup_values fvl9
6422: , fnd_lookup_values fvl13
6423: WHERE xet.event_id between x_first_event_id and x_last_event_id
6424: and xet.event_date between p_pad_start_date and p_pad_end_date
6425: and xet.event_type_code = C_EVENT_TYPE_CODE

Line 6422: , fnd_lookup_values fvl13

6418: , LNS_LOAN_DETAILS_EXT_V l1
6419: , fnd_lookup_values fvl4
6420: , fnd_lookup_values fvl8
6421: , fnd_lookup_values fvl9
6422: , fnd_lookup_values fvl13
6423: WHERE xet.event_id between x_first_event_id and x_last_event_id
6424: and xet.event_date between p_pad_start_date and p_pad_end_date
6425: and xet.event_type_code = C_EVENT_TYPE_CODE
6426: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 7355: , fnd_lookup_values fvl1

7351: ELSE null
7352: END source_meaning
7353: FROM xla_events_gt xet
7354: , LNS_LOAN_HEADERS_EXT_V h2
7355: , fnd_lookup_values fvl1
7356: , fnd_lookup_values fvl15
7357: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
7358: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
7359: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 7356: , fnd_lookup_values fvl15

7352: END source_meaning
7353: FROM xla_events_gt xet
7354: , LNS_LOAN_HEADERS_EXT_V h2
7355: , fnd_lookup_values fvl1
7356: , fnd_lookup_values fvl15
7357: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
7358: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
7359: AND xet.event_type_code = C_EVENT_TYPE_CODE
7360: AND h2.event_id = xet.event_id

Line 7509: , fnd_lookup_values fvl4

7505: ELSE null
7506: END source_meaning
7507: FROM xla_events_gt xet
7508: , LNS_LOAN_DETAILS_EXT_V l1
7509: , fnd_lookup_values fvl4
7510: , fnd_lookup_values fvl8
7511: , fnd_lookup_values fvl9
7512: , fnd_lookup_values fvl13
7513: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)

Line 7510: , fnd_lookup_values fvl8

7506: END source_meaning
7507: FROM xla_events_gt xet
7508: , LNS_LOAN_DETAILS_EXT_V l1
7509: , fnd_lookup_values fvl4
7510: , fnd_lookup_values fvl8
7511: , fnd_lookup_values fvl9
7512: , fnd_lookup_values fvl13
7513: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
7514: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 7511: , fnd_lookup_values fvl9

7507: FROM xla_events_gt xet
7508: , LNS_LOAN_DETAILS_EXT_V l1
7509: , fnd_lookup_values fvl4
7510: , fnd_lookup_values fvl8
7511: , fnd_lookup_values fvl9
7512: , fnd_lookup_values fvl13
7513: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
7514: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
7515: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 7512: , fnd_lookup_values fvl13

7508: , LNS_LOAN_DETAILS_EXT_V l1
7509: , fnd_lookup_values fvl4
7510: , fnd_lookup_values fvl8
7511: , fnd_lookup_values fvl9
7512: , fnd_lookup_values fvl13
7513: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
7514: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
7515: AND xet.event_type_code = C_EVENT_TYPE_CODE
7516: AND l1.event_id = xet.event_id

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

7657: l_balance_type_code VARCHAR2(1) :=NULL;
7658: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
7659:
7660: --
7661: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
7662: --
7663:
7664: TYPE t_array_source_1 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
7665: TYPE t_array_source_2 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 7753: , fnd_lookup_values fvl1

7749: , h2.SUBSIDY_COST source_19
7750: , h2.GL_DATE source_20
7751: FROM xla_events_gt xet
7752: , LNS_LOAN_HEADERS_EXT_V h2
7753: , fnd_lookup_values fvl1
7754: , fnd_lookup_values fvl15
7755: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
7756: and xet.event_type_code = C_EVENT_TYPE_CODE
7757: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id

Line 7754: , fnd_lookup_values fvl15

7750: , h2.GL_DATE source_20
7751: FROM xla_events_gt xet
7752: , LNS_LOAN_HEADERS_EXT_V h2
7753: , fnd_lookup_values fvl1
7754: , fnd_lookup_values fvl15
7755: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
7756: and xet.event_type_code = C_EVENT_TYPE_CODE
7757: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
7758: AND fvl1.lookup_type(+) = 'LOAN_CLASS'

Line 7816: , fnd_lookup_values fvl4

7812: , fvl13.meaning source_13_meaning
7813: , l1.DISTRIBUTION_AMOUNT source_14
7814: FROM xla_events_gt xet
7815: , LNS_LOAN_DETAILS_EXT_V l1
7816: , fnd_lookup_values fvl4
7817: , fnd_lookup_values fvl8
7818: , fnd_lookup_values fvl9
7819: , fnd_lookup_values fvl13
7820: WHERE xet.event_id between x_first_event_id and x_last_event_id

Line 7817: , fnd_lookup_values fvl8

7813: , l1.DISTRIBUTION_AMOUNT source_14
7814: FROM xla_events_gt xet
7815: , LNS_LOAN_DETAILS_EXT_V l1
7816: , fnd_lookup_values fvl4
7817: , fnd_lookup_values fvl8
7818: , fnd_lookup_values fvl9
7819: , fnd_lookup_values fvl13
7820: WHERE xet.event_id between x_first_event_id and x_last_event_id
7821: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 7818: , fnd_lookup_values fvl9

7814: FROM xla_events_gt xet
7815: , LNS_LOAN_DETAILS_EXT_V l1
7816: , fnd_lookup_values fvl4
7817: , fnd_lookup_values fvl8
7818: , fnd_lookup_values fvl9
7819: , fnd_lookup_values fvl13
7820: WHERE xet.event_id between x_first_event_id and x_last_event_id
7821: and xet.event_date between p_pad_start_date and p_pad_end_date
7822: and xet.event_type_code = C_EVENT_TYPE_CODE

Line 7819: , fnd_lookup_values fvl13

7815: , LNS_LOAN_DETAILS_EXT_V l1
7816: , fnd_lookup_values fvl4
7817: , fnd_lookup_values fvl8
7818: , fnd_lookup_values fvl9
7819: , fnd_lookup_values fvl13
7820: WHERE xet.event_id between x_first_event_id and x_last_event_id
7821: and xet.event_date between p_pad_start_date and p_pad_end_date
7822: and xet.event_type_code = C_EVENT_TYPE_CODE
7823: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id