APPS.JL_BR_SPED_DATA_EXTRACT_PKG dependencies on XLE_HISTORIES

Line 3458: FROM xle_histories his

3454: l_count :=0;
3455:
3456: SELECT count(*)
3457: INTO l_count
3458: FROM xle_histories his
3459: WHERE source_table = 'XLE_REGISTRATIONS'
3460: AND source_id = l_registration_id
3461: AND source_column_name = 'EFFECTIVE_FROM';
3462:

Line 3468: FROM xle_histories his

3464:
3465: BEGIN
3466: SELECT substr(source_column_value,1,11)
3467: INTO l_conversion_date
3468: FROM xle_histories his
3469: WHERE source_table = 'XLE_REGISTRATIONS'
3470: AND source_id = l_registration_id
3471: AND source_column_name = 'EFFECTIVE_FROM'
3472: AND effective_to IS NULL;

Line 3618: FROM xle_histories his

3614: l_count :=0;
3615:
3616: SELECT count(*)
3617: INTO l_count
3618: FROM xle_histories his
3619: WHERE source_table = 'XLE_REGISTRATIONS'
3620: AND source_id = l_registration_id
3621: AND source_column_name = 'EFFECTIVE_FROM';
3622:

Line 3628: FROM xle_histories his

3624:
3625: BEGIN
3626: SELECT substr(source_column_value,1,11)
3627: INTO l_conversion_date
3628: FROM xle_histories his
3629: WHERE source_table = 'XLE_REGISTRATIONS'
3630: AND source_id = l_registration_id
3631: AND source_column_name = 'EFFECTIVE_FROM'
3632: AND effective_to IS NULL;