eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XLA_00206_AAD_S_000004_PKG dependencies on LNS_LOAN_HEADERS_EXT_V

Line 2879: WHEN 1 THEN 'LNS_LOAN_HEADERS_EXT_V'

2875: FROM (
2876: SELECT xet.event_id event_id
2877: , 0 line_number
2878: , CASE r
2879: WHEN 1 THEN 'LNS_LOAN_HEADERS_EXT_V'
2880: WHEN 2 THEN 'LNS_LOAN_HEADERS_EXT_V'
2881: WHEN 3 THEN 'LNS_LOAN_HEADERS_EXT_V'
2882: WHEN 4 THEN 'LNS_LOAN_HEADERS_EXT_V'
2883:

Line 2880: WHEN 2 THEN 'LNS_LOAN_HEADERS_EXT_V'

2876: SELECT xet.event_id event_id
2877: , 0 line_number
2878: , CASE r
2879: WHEN 1 THEN 'LNS_LOAN_HEADERS_EXT_V'
2880: WHEN 2 THEN 'LNS_LOAN_HEADERS_EXT_V'
2881: WHEN 3 THEN 'LNS_LOAN_HEADERS_EXT_V'
2882: WHEN 4 THEN 'LNS_LOAN_HEADERS_EXT_V'
2883:
2884: ELSE null

Line 2881: WHEN 3 THEN 'LNS_LOAN_HEADERS_EXT_V'

2877: , 0 line_number
2878: , CASE r
2879: WHEN 1 THEN 'LNS_LOAN_HEADERS_EXT_V'
2880: WHEN 2 THEN 'LNS_LOAN_HEADERS_EXT_V'
2881: WHEN 3 THEN 'LNS_LOAN_HEADERS_EXT_V'
2882: WHEN 4 THEN 'LNS_LOAN_HEADERS_EXT_V'
2883:
2884: ELSE null
2885: END object_name

Line 2882: WHEN 4 THEN 'LNS_LOAN_HEADERS_EXT_V'

2878: , CASE r
2879: WHEN 1 THEN 'LNS_LOAN_HEADERS_EXT_V'
2880: WHEN 2 THEN 'LNS_LOAN_HEADERS_EXT_V'
2881: WHEN 3 THEN 'LNS_LOAN_HEADERS_EXT_V'
2882: WHEN 4 THEN 'LNS_LOAN_HEADERS_EXT_V'
2883:
2884: ELSE null
2885: END object_name
2886: , CASE r

Line 2925: , LNS_LOAN_HEADERS_EXT_V h1

2921:
2922: ELSE null
2923: END source_meaning
2924: FROM xla_events_gt xet
2925: , LNS_LOAN_HEADERS_EXT_V h1
2926: , fnd_lookup_values fvl1
2927: ,(select rownum r from all_objects where rownum <= 4 and owner = p_apps_owner)
2928: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
2929: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 3068: TYPE t_array_source_1 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;

3064: --
3065: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
3066: --
3067:
3068: TYPE t_array_source_1 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
3069: TYPE t_array_source_2 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_TYPE%TYPE INDEX BY BINARY_INTEGER;
3070: TYPE t_array_source_3 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_NUMBER%TYPE INDEX BY BINARY_INTEGER;
3071: TYPE t_array_source_18 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
3072:

Line 3069: TYPE t_array_source_2 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_TYPE%TYPE INDEX BY BINARY_INTEGER;

3065: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
3066: --
3067:
3068: TYPE t_array_source_1 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
3069: TYPE t_array_source_2 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_TYPE%TYPE INDEX BY BINARY_INTEGER;
3070: TYPE t_array_source_3 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_NUMBER%TYPE INDEX BY BINARY_INTEGER;
3071: TYPE t_array_source_18 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
3072:
3073:

Line 3070: TYPE t_array_source_3 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_NUMBER%TYPE INDEX BY BINARY_INTEGER;

3066: --
3067:
3068: TYPE t_array_source_1 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
3069: TYPE t_array_source_2 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_TYPE%TYPE INDEX BY BINARY_INTEGER;
3070: TYPE t_array_source_3 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_NUMBER%TYPE INDEX BY BINARY_INTEGER;
3071: TYPE t_array_source_18 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
3072:
3073:
3074: l_array_source_1 t_array_source_1;

Line 3071: TYPE t_array_source_18 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

3067:
3068: TYPE t_array_source_1 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
3069: TYPE t_array_source_2 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_TYPE%TYPE INDEX BY BINARY_INTEGER;
3070: TYPE t_array_source_3 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_NUMBER%TYPE INDEX BY BINARY_INTEGER;
3071: TYPE t_array_source_18 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
3072:
3073:
3074: l_array_source_1 t_array_source_1;
3075: l_array_source_1_meaning t_array_lookup_meaning;

Line 3117: , LNS_LOAN_HEADERS_EXT_V h1

3113: , h1.LOAN_TYPE source_2
3114: , h1.LOAN_NUMBER source_3
3115: , h1.GL_DATE source_18
3116: FROM xla_events_gt xet
3117: , LNS_LOAN_HEADERS_EXT_V h1
3118: , fnd_lookup_values fvl1
3119: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
3120: and xet.event_type_code = C_EVENT_TYPE_CODE
3121: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 3828: WHEN 1 THEN 'LNS_LOAN_HEADERS_EXT_V'

3824: FROM (
3825: SELECT xet.event_id event_id
3826: , 0 line_number
3827: , CASE r
3828: WHEN 1 THEN 'LNS_LOAN_HEADERS_EXT_V'
3829: WHEN 2 THEN 'LNS_LOAN_HEADERS_EXT_V'
3830: WHEN 3 THEN 'LNS_LOAN_HEADERS_EXT_V'
3831: WHEN 4 THEN 'LNS_LOAN_HEADERS_EXT_V'
3832: WHEN 5 THEN 'LNS_LOAN_HEADERS_EXT_V'

Line 3829: WHEN 2 THEN 'LNS_LOAN_HEADERS_EXT_V'

3825: SELECT xet.event_id event_id
3826: , 0 line_number
3827: , CASE r
3828: WHEN 1 THEN 'LNS_LOAN_HEADERS_EXT_V'
3829: WHEN 2 THEN 'LNS_LOAN_HEADERS_EXT_V'
3830: WHEN 3 THEN 'LNS_LOAN_HEADERS_EXT_V'
3831: WHEN 4 THEN 'LNS_LOAN_HEADERS_EXT_V'
3832: WHEN 5 THEN 'LNS_LOAN_HEADERS_EXT_V'
3833: WHEN 6 THEN 'LNS_LOAN_HEADERS_EXT_V'

Line 3830: WHEN 3 THEN 'LNS_LOAN_HEADERS_EXT_V'

3826: , 0 line_number
3827: , CASE r
3828: WHEN 1 THEN 'LNS_LOAN_HEADERS_EXT_V'
3829: WHEN 2 THEN 'LNS_LOAN_HEADERS_EXT_V'
3830: WHEN 3 THEN 'LNS_LOAN_HEADERS_EXT_V'
3831: WHEN 4 THEN 'LNS_LOAN_HEADERS_EXT_V'
3832: WHEN 5 THEN 'LNS_LOAN_HEADERS_EXT_V'
3833: WHEN 6 THEN 'LNS_LOAN_HEADERS_EXT_V'
3834: WHEN 7 THEN 'LNS_LOAN_HEADERS_EXT_V'

Line 3831: WHEN 4 THEN 'LNS_LOAN_HEADERS_EXT_V'

3827: , CASE r
3828: WHEN 1 THEN 'LNS_LOAN_HEADERS_EXT_V'
3829: WHEN 2 THEN 'LNS_LOAN_HEADERS_EXT_V'
3830: WHEN 3 THEN 'LNS_LOAN_HEADERS_EXT_V'
3831: WHEN 4 THEN 'LNS_LOAN_HEADERS_EXT_V'
3832: WHEN 5 THEN 'LNS_LOAN_HEADERS_EXT_V'
3833: WHEN 6 THEN 'LNS_LOAN_HEADERS_EXT_V'
3834: WHEN 7 THEN 'LNS_LOAN_HEADERS_EXT_V'
3835: WHEN 8 THEN 'LNS_LOAN_HEADERS_EXT_V'

Line 3832: WHEN 5 THEN 'LNS_LOAN_HEADERS_EXT_V'

3828: WHEN 1 THEN 'LNS_LOAN_HEADERS_EXT_V'
3829: WHEN 2 THEN 'LNS_LOAN_HEADERS_EXT_V'
3830: WHEN 3 THEN 'LNS_LOAN_HEADERS_EXT_V'
3831: WHEN 4 THEN 'LNS_LOAN_HEADERS_EXT_V'
3832: WHEN 5 THEN 'LNS_LOAN_HEADERS_EXT_V'
3833: WHEN 6 THEN 'LNS_LOAN_HEADERS_EXT_V'
3834: WHEN 7 THEN 'LNS_LOAN_HEADERS_EXT_V'
3835: WHEN 8 THEN 'LNS_LOAN_HEADERS_EXT_V'
3836: WHEN 9 THEN 'LNS_LOAN_HEADERS_EXT_V'

Line 3833: WHEN 6 THEN 'LNS_LOAN_HEADERS_EXT_V'

3829: WHEN 2 THEN 'LNS_LOAN_HEADERS_EXT_V'
3830: WHEN 3 THEN 'LNS_LOAN_HEADERS_EXT_V'
3831: WHEN 4 THEN 'LNS_LOAN_HEADERS_EXT_V'
3832: WHEN 5 THEN 'LNS_LOAN_HEADERS_EXT_V'
3833: WHEN 6 THEN 'LNS_LOAN_HEADERS_EXT_V'
3834: WHEN 7 THEN 'LNS_LOAN_HEADERS_EXT_V'
3835: WHEN 8 THEN 'LNS_LOAN_HEADERS_EXT_V'
3836: WHEN 9 THEN 'LNS_LOAN_HEADERS_EXT_V'
3837:

Line 3834: WHEN 7 THEN 'LNS_LOAN_HEADERS_EXT_V'

3830: WHEN 3 THEN 'LNS_LOAN_HEADERS_EXT_V'
3831: WHEN 4 THEN 'LNS_LOAN_HEADERS_EXT_V'
3832: WHEN 5 THEN 'LNS_LOAN_HEADERS_EXT_V'
3833: WHEN 6 THEN 'LNS_LOAN_HEADERS_EXT_V'
3834: WHEN 7 THEN 'LNS_LOAN_HEADERS_EXT_V'
3835: WHEN 8 THEN 'LNS_LOAN_HEADERS_EXT_V'
3836: WHEN 9 THEN 'LNS_LOAN_HEADERS_EXT_V'
3837:
3838: ELSE null

Line 3835: WHEN 8 THEN 'LNS_LOAN_HEADERS_EXT_V'

3831: WHEN 4 THEN 'LNS_LOAN_HEADERS_EXT_V'
3832: WHEN 5 THEN 'LNS_LOAN_HEADERS_EXT_V'
3833: WHEN 6 THEN 'LNS_LOAN_HEADERS_EXT_V'
3834: WHEN 7 THEN 'LNS_LOAN_HEADERS_EXT_V'
3835: WHEN 8 THEN 'LNS_LOAN_HEADERS_EXT_V'
3836: WHEN 9 THEN 'LNS_LOAN_HEADERS_EXT_V'
3837:
3838: ELSE null
3839: END object_name

Line 3836: WHEN 9 THEN 'LNS_LOAN_HEADERS_EXT_V'

3832: WHEN 5 THEN 'LNS_LOAN_HEADERS_EXT_V'
3833: WHEN 6 THEN 'LNS_LOAN_HEADERS_EXT_V'
3834: WHEN 7 THEN 'LNS_LOAN_HEADERS_EXT_V'
3835: WHEN 8 THEN 'LNS_LOAN_HEADERS_EXT_V'
3836: WHEN 9 THEN 'LNS_LOAN_HEADERS_EXT_V'
3837:
3838: ELSE null
3839: END object_name
3840: , CASE r

Line 3901: , LNS_LOAN_HEADERS_EXT_V h2

3897:
3898: ELSE null
3899: END source_meaning
3900: FROM xla_events_gt xet
3901: , LNS_LOAN_HEADERS_EXT_V h2
3902: , fnd_lookup_values fvl1
3903: , fnd_lookup_values fvl10
3904: , fnd_lookup_values fvl14
3905: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)

Line 4216: TYPE t_array_source_1 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;

4212: --
4213: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
4214: --
4215:
4216: TYPE t_array_source_1 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
4217: TYPE t_array_source_2 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_TYPE%TYPE INDEX BY BINARY_INTEGER;
4218: TYPE t_array_source_3 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_NUMBER%TYPE INDEX BY BINARY_INTEGER;
4219: TYPE t_array_source_10 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_STATUS%TYPE INDEX BY BINARY_INTEGER;
4220: TYPE t_array_source_14 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CURRENCY%TYPE INDEX BY BINARY_INTEGER;

Line 4217: TYPE t_array_source_2 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_TYPE%TYPE INDEX BY BINARY_INTEGER;

4213: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
4214: --
4215:
4216: TYPE t_array_source_1 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
4217: TYPE t_array_source_2 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_TYPE%TYPE INDEX BY BINARY_INTEGER;
4218: TYPE t_array_source_3 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_NUMBER%TYPE INDEX BY BINARY_INTEGER;
4219: TYPE t_array_source_10 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_STATUS%TYPE INDEX BY BINARY_INTEGER;
4220: TYPE t_array_source_14 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
4221: TYPE t_array_source_15 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 4218: TYPE t_array_source_3 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_NUMBER%TYPE INDEX BY BINARY_INTEGER;

4214: --
4215:
4216: TYPE t_array_source_1 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
4217: TYPE t_array_source_2 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_TYPE%TYPE INDEX BY BINARY_INTEGER;
4218: TYPE t_array_source_3 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_NUMBER%TYPE INDEX BY BINARY_INTEGER;
4219: TYPE t_array_source_10 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_STATUS%TYPE INDEX BY BINARY_INTEGER;
4220: TYPE t_array_source_14 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
4221: TYPE t_array_source_15 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
4222: TYPE t_array_source_16 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 4219: TYPE t_array_source_10 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_STATUS%TYPE INDEX BY BINARY_INTEGER;

4215:
4216: TYPE t_array_source_1 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
4217: TYPE t_array_source_2 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_TYPE%TYPE INDEX BY BINARY_INTEGER;
4218: TYPE t_array_source_3 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_NUMBER%TYPE INDEX BY BINARY_INTEGER;
4219: TYPE t_array_source_10 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_STATUS%TYPE INDEX BY BINARY_INTEGER;
4220: TYPE t_array_source_14 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
4221: TYPE t_array_source_15 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
4222: TYPE t_array_source_16 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
4223: TYPE t_array_source_17 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 4220: TYPE t_array_source_14 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CURRENCY%TYPE INDEX BY BINARY_INTEGER;

4216: TYPE t_array_source_1 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
4217: TYPE t_array_source_2 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_TYPE%TYPE INDEX BY BINARY_INTEGER;
4218: TYPE t_array_source_3 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_NUMBER%TYPE INDEX BY BINARY_INTEGER;
4219: TYPE t_array_source_10 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_STATUS%TYPE INDEX BY BINARY_INTEGER;
4220: TYPE t_array_source_14 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
4221: TYPE t_array_source_15 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
4222: TYPE t_array_source_16 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
4223: TYPE t_array_source_17 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
4224: TYPE t_array_source_18 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 4221: TYPE t_array_source_15 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

4217: TYPE t_array_source_2 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_TYPE%TYPE INDEX BY BINARY_INTEGER;
4218: TYPE t_array_source_3 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_NUMBER%TYPE INDEX BY BINARY_INTEGER;
4219: TYPE t_array_source_10 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_STATUS%TYPE INDEX BY BINARY_INTEGER;
4220: TYPE t_array_source_14 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
4221: TYPE t_array_source_15 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
4222: TYPE t_array_source_16 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
4223: TYPE t_array_source_17 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
4224: TYPE t_array_source_18 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
4225:

Line 4222: TYPE t_array_source_16 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

4218: TYPE t_array_source_3 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_NUMBER%TYPE INDEX BY BINARY_INTEGER;
4219: TYPE t_array_source_10 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_STATUS%TYPE INDEX BY BINARY_INTEGER;
4220: TYPE t_array_source_14 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
4221: TYPE t_array_source_15 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
4222: TYPE t_array_source_16 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
4223: TYPE t_array_source_17 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
4224: TYPE t_array_source_18 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
4225:
4226: TYPE t_array_source_4 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;

Line 4223: TYPE t_array_source_17 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

4219: TYPE t_array_source_10 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_STATUS%TYPE INDEX BY BINARY_INTEGER;
4220: TYPE t_array_source_14 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
4221: TYPE t_array_source_15 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
4222: TYPE t_array_source_16 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
4223: TYPE t_array_source_17 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
4224: TYPE t_array_source_18 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
4225:
4226: TYPE t_array_source_4 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
4227: TYPE t_array_source_5 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 4224: TYPE t_array_source_18 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

4220: TYPE t_array_source_14 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
4221: TYPE t_array_source_15 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
4222: TYPE t_array_source_16 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
4223: TYPE t_array_source_17 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
4224: TYPE t_array_source_18 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
4225:
4226: TYPE t_array_source_4 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
4227: TYPE t_array_source_5 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
4228: TYPE t_array_source_6 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.ACCOUNT_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 4306: , LNS_LOAN_HEADERS_EXT_V h2

4302: , h2.EXCHANGE_RATE source_16
4303: , h2.EXCHANGE_RATE_TYPE source_17
4304: , h2.GL_DATE source_18
4305: FROM xla_events_gt xet
4306: , LNS_LOAN_HEADERS_EXT_V h2
4307: , fnd_lookup_values fvl1
4308: , fnd_lookup_values fvl10
4309: , fnd_lookup_values fvl14
4310: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 5165: WHEN 1 THEN 'LNS_LOAN_HEADERS_EXT_V'

5161: FROM (
5162: SELECT xet.event_id event_id
5163: , 0 line_number
5164: , CASE r
5165: WHEN 1 THEN 'LNS_LOAN_HEADERS_EXT_V'
5166: WHEN 2 THEN 'LNS_LOAN_HEADERS_EXT_V'
5167: WHEN 3 THEN 'LNS_LOAN_HEADERS_EXT_V'
5168: WHEN 4 THEN 'LNS_LOAN_HEADERS_EXT_V'
5169: WHEN 5 THEN 'LNS_LOAN_HEADERS_EXT_V'

Line 5166: WHEN 2 THEN 'LNS_LOAN_HEADERS_EXT_V'

5162: SELECT xet.event_id event_id
5163: , 0 line_number
5164: , CASE r
5165: WHEN 1 THEN 'LNS_LOAN_HEADERS_EXT_V'
5166: WHEN 2 THEN 'LNS_LOAN_HEADERS_EXT_V'
5167: WHEN 3 THEN 'LNS_LOAN_HEADERS_EXT_V'
5168: WHEN 4 THEN 'LNS_LOAN_HEADERS_EXT_V'
5169: WHEN 5 THEN 'LNS_LOAN_HEADERS_EXT_V'
5170: WHEN 6 THEN 'LNS_LOAN_HEADERS_EXT_V'

Line 5167: WHEN 3 THEN 'LNS_LOAN_HEADERS_EXT_V'

5163: , 0 line_number
5164: , CASE r
5165: WHEN 1 THEN 'LNS_LOAN_HEADERS_EXT_V'
5166: WHEN 2 THEN 'LNS_LOAN_HEADERS_EXT_V'
5167: WHEN 3 THEN 'LNS_LOAN_HEADERS_EXT_V'
5168: WHEN 4 THEN 'LNS_LOAN_HEADERS_EXT_V'
5169: WHEN 5 THEN 'LNS_LOAN_HEADERS_EXT_V'
5170: WHEN 6 THEN 'LNS_LOAN_HEADERS_EXT_V'
5171: WHEN 7 THEN 'LNS_LOAN_HEADERS_EXT_V'

Line 5168: WHEN 4 THEN 'LNS_LOAN_HEADERS_EXT_V'

5164: , CASE r
5165: WHEN 1 THEN 'LNS_LOAN_HEADERS_EXT_V'
5166: WHEN 2 THEN 'LNS_LOAN_HEADERS_EXT_V'
5167: WHEN 3 THEN 'LNS_LOAN_HEADERS_EXT_V'
5168: WHEN 4 THEN 'LNS_LOAN_HEADERS_EXT_V'
5169: WHEN 5 THEN 'LNS_LOAN_HEADERS_EXT_V'
5170: WHEN 6 THEN 'LNS_LOAN_HEADERS_EXT_V'
5171: WHEN 7 THEN 'LNS_LOAN_HEADERS_EXT_V'
5172: WHEN 8 THEN 'LNS_LOAN_HEADERS_EXT_V'

Line 5169: WHEN 5 THEN 'LNS_LOAN_HEADERS_EXT_V'

5165: WHEN 1 THEN 'LNS_LOAN_HEADERS_EXT_V'
5166: WHEN 2 THEN 'LNS_LOAN_HEADERS_EXT_V'
5167: WHEN 3 THEN 'LNS_LOAN_HEADERS_EXT_V'
5168: WHEN 4 THEN 'LNS_LOAN_HEADERS_EXT_V'
5169: WHEN 5 THEN 'LNS_LOAN_HEADERS_EXT_V'
5170: WHEN 6 THEN 'LNS_LOAN_HEADERS_EXT_V'
5171: WHEN 7 THEN 'LNS_LOAN_HEADERS_EXT_V'
5172: WHEN 8 THEN 'LNS_LOAN_HEADERS_EXT_V'
5173: WHEN 9 THEN 'LNS_LOAN_HEADERS_EXT_V'

Line 5170: WHEN 6 THEN 'LNS_LOAN_HEADERS_EXT_V'

5166: WHEN 2 THEN 'LNS_LOAN_HEADERS_EXT_V'
5167: WHEN 3 THEN 'LNS_LOAN_HEADERS_EXT_V'
5168: WHEN 4 THEN 'LNS_LOAN_HEADERS_EXT_V'
5169: WHEN 5 THEN 'LNS_LOAN_HEADERS_EXT_V'
5170: WHEN 6 THEN 'LNS_LOAN_HEADERS_EXT_V'
5171: WHEN 7 THEN 'LNS_LOAN_HEADERS_EXT_V'
5172: WHEN 8 THEN 'LNS_LOAN_HEADERS_EXT_V'
5173: WHEN 9 THEN 'LNS_LOAN_HEADERS_EXT_V'
5174:

Line 5171: WHEN 7 THEN 'LNS_LOAN_HEADERS_EXT_V'

5167: WHEN 3 THEN 'LNS_LOAN_HEADERS_EXT_V'
5168: WHEN 4 THEN 'LNS_LOAN_HEADERS_EXT_V'
5169: WHEN 5 THEN 'LNS_LOAN_HEADERS_EXT_V'
5170: WHEN 6 THEN 'LNS_LOAN_HEADERS_EXT_V'
5171: WHEN 7 THEN 'LNS_LOAN_HEADERS_EXT_V'
5172: WHEN 8 THEN 'LNS_LOAN_HEADERS_EXT_V'
5173: WHEN 9 THEN 'LNS_LOAN_HEADERS_EXT_V'
5174:
5175: ELSE null

Line 5172: WHEN 8 THEN 'LNS_LOAN_HEADERS_EXT_V'

5168: WHEN 4 THEN 'LNS_LOAN_HEADERS_EXT_V'
5169: WHEN 5 THEN 'LNS_LOAN_HEADERS_EXT_V'
5170: WHEN 6 THEN 'LNS_LOAN_HEADERS_EXT_V'
5171: WHEN 7 THEN 'LNS_LOAN_HEADERS_EXT_V'
5172: WHEN 8 THEN 'LNS_LOAN_HEADERS_EXT_V'
5173: WHEN 9 THEN 'LNS_LOAN_HEADERS_EXT_V'
5174:
5175: ELSE null
5176: END object_name

Line 5173: WHEN 9 THEN 'LNS_LOAN_HEADERS_EXT_V'

5169: WHEN 5 THEN 'LNS_LOAN_HEADERS_EXT_V'
5170: WHEN 6 THEN 'LNS_LOAN_HEADERS_EXT_V'
5171: WHEN 7 THEN 'LNS_LOAN_HEADERS_EXT_V'
5172: WHEN 8 THEN 'LNS_LOAN_HEADERS_EXT_V'
5173: WHEN 9 THEN 'LNS_LOAN_HEADERS_EXT_V'
5174:
5175: ELSE null
5176: END object_name
5177: , CASE r

Line 5238: , LNS_LOAN_HEADERS_EXT_V h2

5234:
5235: ELSE null
5236: END source_meaning
5237: FROM xla_events_gt xet
5238: , LNS_LOAN_HEADERS_EXT_V h2
5239: , fnd_lookup_values fvl1
5240: , fnd_lookup_values fvl10
5241: , fnd_lookup_values fvl14
5242: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)

Line 5527: TYPE t_array_source_1 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;

5523: --
5524: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
5525: --
5526:
5527: TYPE t_array_source_1 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
5528: TYPE t_array_source_2 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_TYPE%TYPE INDEX BY BINARY_INTEGER;
5529: TYPE t_array_source_3 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_NUMBER%TYPE INDEX BY BINARY_INTEGER;
5530: TYPE t_array_source_10 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_STATUS%TYPE INDEX BY BINARY_INTEGER;
5531: TYPE t_array_source_14 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CURRENCY%TYPE INDEX BY BINARY_INTEGER;

Line 5528: TYPE t_array_source_2 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_TYPE%TYPE INDEX BY BINARY_INTEGER;

5524: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
5525: --
5526:
5527: TYPE t_array_source_1 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
5528: TYPE t_array_source_2 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_TYPE%TYPE INDEX BY BINARY_INTEGER;
5529: TYPE t_array_source_3 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_NUMBER%TYPE INDEX BY BINARY_INTEGER;
5530: TYPE t_array_source_10 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_STATUS%TYPE INDEX BY BINARY_INTEGER;
5531: TYPE t_array_source_14 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
5532: TYPE t_array_source_15 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 5529: TYPE t_array_source_3 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_NUMBER%TYPE INDEX BY BINARY_INTEGER;

5525: --
5526:
5527: TYPE t_array_source_1 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
5528: TYPE t_array_source_2 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_TYPE%TYPE INDEX BY BINARY_INTEGER;
5529: TYPE t_array_source_3 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_NUMBER%TYPE INDEX BY BINARY_INTEGER;
5530: TYPE t_array_source_10 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_STATUS%TYPE INDEX BY BINARY_INTEGER;
5531: TYPE t_array_source_14 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
5532: TYPE t_array_source_15 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
5533: TYPE t_array_source_16 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 5530: TYPE t_array_source_10 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_STATUS%TYPE INDEX BY BINARY_INTEGER;

5526:
5527: TYPE t_array_source_1 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
5528: TYPE t_array_source_2 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_TYPE%TYPE INDEX BY BINARY_INTEGER;
5529: TYPE t_array_source_3 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_NUMBER%TYPE INDEX BY BINARY_INTEGER;
5530: TYPE t_array_source_10 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_STATUS%TYPE INDEX BY BINARY_INTEGER;
5531: TYPE t_array_source_14 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
5532: TYPE t_array_source_15 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
5533: TYPE t_array_source_16 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
5534: TYPE t_array_source_17 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 5531: TYPE t_array_source_14 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CURRENCY%TYPE INDEX BY BINARY_INTEGER;

5527: TYPE t_array_source_1 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
5528: TYPE t_array_source_2 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_TYPE%TYPE INDEX BY BINARY_INTEGER;
5529: TYPE t_array_source_3 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_NUMBER%TYPE INDEX BY BINARY_INTEGER;
5530: TYPE t_array_source_10 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_STATUS%TYPE INDEX BY BINARY_INTEGER;
5531: TYPE t_array_source_14 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
5532: TYPE t_array_source_15 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
5533: TYPE t_array_source_16 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
5534: TYPE t_array_source_17 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
5535: TYPE t_array_source_18 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 5532: TYPE t_array_source_15 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

5528: TYPE t_array_source_2 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_TYPE%TYPE INDEX BY BINARY_INTEGER;
5529: TYPE t_array_source_3 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_NUMBER%TYPE INDEX BY BINARY_INTEGER;
5530: TYPE t_array_source_10 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_STATUS%TYPE INDEX BY BINARY_INTEGER;
5531: TYPE t_array_source_14 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
5532: TYPE t_array_source_15 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
5533: TYPE t_array_source_16 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
5534: TYPE t_array_source_17 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
5535: TYPE t_array_source_18 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
5536:

Line 5533: TYPE t_array_source_16 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

5529: TYPE t_array_source_3 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_NUMBER%TYPE INDEX BY BINARY_INTEGER;
5530: TYPE t_array_source_10 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_STATUS%TYPE INDEX BY BINARY_INTEGER;
5531: TYPE t_array_source_14 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
5532: TYPE t_array_source_15 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
5533: TYPE t_array_source_16 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
5534: TYPE t_array_source_17 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
5535: TYPE t_array_source_18 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
5536:
5537: TYPE t_array_source_4 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;

Line 5534: TYPE t_array_source_17 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

5530: TYPE t_array_source_10 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_STATUS%TYPE INDEX BY BINARY_INTEGER;
5531: TYPE t_array_source_14 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
5532: TYPE t_array_source_15 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
5533: TYPE t_array_source_16 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
5534: TYPE t_array_source_17 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
5535: TYPE t_array_source_18 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
5536:
5537: TYPE t_array_source_4 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
5538: TYPE t_array_source_5 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 5535: TYPE t_array_source_18 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

5531: TYPE t_array_source_14 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
5532: TYPE t_array_source_15 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
5533: TYPE t_array_source_16 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
5534: TYPE t_array_source_17 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
5535: TYPE t_array_source_18 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
5536:
5537: TYPE t_array_source_4 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
5538: TYPE t_array_source_5 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
5539: TYPE t_array_source_6 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.ACCOUNT_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 5608: , LNS_LOAN_HEADERS_EXT_V h2

5604: , h2.EXCHANGE_RATE source_16
5605: , h2.EXCHANGE_RATE_TYPE source_17
5606: , h2.GL_DATE source_18
5607: FROM xla_events_gt xet
5608: , LNS_LOAN_HEADERS_EXT_V h2
5609: , fnd_lookup_values fvl1
5610: , fnd_lookup_values fvl10
5611: , fnd_lookup_values fvl14
5612: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 6437: WHEN 1 THEN 'LNS_LOAN_HEADERS_EXT_V'

6433: FROM (
6434: SELECT xet.event_id event_id
6435: , 0 line_number
6436: , CASE r
6437: WHEN 1 THEN 'LNS_LOAN_HEADERS_EXT_V'
6438: WHEN 2 THEN 'LNS_LOAN_HEADERS_EXT_V'
6439: WHEN 3 THEN 'LNS_LOAN_HEADERS_EXT_V'
6440: WHEN 4 THEN 'LNS_LOAN_HEADERS_EXT_V'
6441:

Line 6438: WHEN 2 THEN 'LNS_LOAN_HEADERS_EXT_V'

6434: SELECT xet.event_id event_id
6435: , 0 line_number
6436: , CASE r
6437: WHEN 1 THEN 'LNS_LOAN_HEADERS_EXT_V'
6438: WHEN 2 THEN 'LNS_LOAN_HEADERS_EXT_V'
6439: WHEN 3 THEN 'LNS_LOAN_HEADERS_EXT_V'
6440: WHEN 4 THEN 'LNS_LOAN_HEADERS_EXT_V'
6441:
6442: ELSE null

Line 6439: WHEN 3 THEN 'LNS_LOAN_HEADERS_EXT_V'

6435: , 0 line_number
6436: , CASE r
6437: WHEN 1 THEN 'LNS_LOAN_HEADERS_EXT_V'
6438: WHEN 2 THEN 'LNS_LOAN_HEADERS_EXT_V'
6439: WHEN 3 THEN 'LNS_LOAN_HEADERS_EXT_V'
6440: WHEN 4 THEN 'LNS_LOAN_HEADERS_EXT_V'
6441:
6442: ELSE null
6443: END object_name

Line 6440: WHEN 4 THEN 'LNS_LOAN_HEADERS_EXT_V'

6436: , CASE r
6437: WHEN 1 THEN 'LNS_LOAN_HEADERS_EXT_V'
6438: WHEN 2 THEN 'LNS_LOAN_HEADERS_EXT_V'
6439: WHEN 3 THEN 'LNS_LOAN_HEADERS_EXT_V'
6440: WHEN 4 THEN 'LNS_LOAN_HEADERS_EXT_V'
6441:
6442: ELSE null
6443: END object_name
6444: , CASE r

Line 6483: , LNS_LOAN_HEADERS_EXT_V h1

6479:
6480: ELSE null
6481: END source_meaning
6482: FROM xla_events_gt xet
6483: , LNS_LOAN_HEADERS_EXT_V h1
6484: , fnd_lookup_values fvl1
6485: ,(select rownum r from all_objects where rownum <= 4 and owner = p_apps_owner)
6486: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
6487: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 6626: TYPE t_array_source_1 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;

6622: --
6623: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
6624: --
6625:
6626: TYPE t_array_source_1 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
6627: TYPE t_array_source_2 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_TYPE%TYPE INDEX BY BINARY_INTEGER;
6628: TYPE t_array_source_3 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_NUMBER%TYPE INDEX BY BINARY_INTEGER;
6629: TYPE t_array_source_18 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
6630:

Line 6627: TYPE t_array_source_2 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_TYPE%TYPE INDEX BY BINARY_INTEGER;

6623: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
6624: --
6625:
6626: TYPE t_array_source_1 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
6627: TYPE t_array_source_2 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_TYPE%TYPE INDEX BY BINARY_INTEGER;
6628: TYPE t_array_source_3 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_NUMBER%TYPE INDEX BY BINARY_INTEGER;
6629: TYPE t_array_source_18 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
6630:
6631:

Line 6628: TYPE t_array_source_3 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_NUMBER%TYPE INDEX BY BINARY_INTEGER;

6624: --
6625:
6626: TYPE t_array_source_1 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
6627: TYPE t_array_source_2 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_TYPE%TYPE INDEX BY BINARY_INTEGER;
6628: TYPE t_array_source_3 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_NUMBER%TYPE INDEX BY BINARY_INTEGER;
6629: TYPE t_array_source_18 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
6630:
6631:
6632: l_array_source_1 t_array_source_1;

Line 6629: TYPE t_array_source_18 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

6625:
6626: TYPE t_array_source_1 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
6627: TYPE t_array_source_2 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_TYPE%TYPE INDEX BY BINARY_INTEGER;
6628: TYPE t_array_source_3 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_NUMBER%TYPE INDEX BY BINARY_INTEGER;
6629: TYPE t_array_source_18 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
6630:
6631:
6632: l_array_source_1 t_array_source_1;
6633: l_array_source_1_meaning t_array_lookup_meaning;

Line 6675: , LNS_LOAN_HEADERS_EXT_V h1

6671: , h1.LOAN_TYPE source_2
6672: , h1.LOAN_NUMBER source_3
6673: , h1.GL_DATE source_18
6674: FROM xla_events_gt xet
6675: , LNS_LOAN_HEADERS_EXT_V h1
6676: , fnd_lookup_values fvl1
6677: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
6678: and xet.event_type_code = C_EVENT_TYPE_CODE
6679: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id