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.JL_BR_SPED_DATA_EXTRACT_PKG dependencies on JL_BR_CINFOS_BOOKS

Line 829: FROM jl_br_cinfos_books

825: BEGIN
826:
827: SELECT COUNT(*)
828: INTO g_ap_ar_auxbook_exist
829: FROM jl_br_cinfos_books
830: WHERE legal_entity_id = g_legal_entity_id
831: AND ((l_estb_acts_as_company='N' AND establishment_id is null)
832: OR (l_estb_acts_as_company='Y' AND establishment_id = g_establishment_id))
833: AND bookkeeping_type = 'A'

Line 3170: FROM jl_br_cinfos_books

3166: ,g_creation_date
3167: ,g_last_updated_by
3168: ,g_last_update_date
3169: ,g_last_update_login
3170: FROM jl_br_cinfos_books
3171: WHERE legal_entity_id = g_legal_entity_id
3172: AND ((l_estb_acts_as_company ='N' AND establishment_id is null)
3173: OR (l_estb_acts_as_company = 'Y' AND establishment_id=g_establishment_id)) --establishment acts as company
3174: AND bookkeeping_type = DECODE(g_bookkeeping_type,'R','A','B','A'

Line 3306: l_book_number jl_br_cinfos_books.book_number%TYPE;

3302: END register_I015;
3303:
3304: PROCEDURE register_I030 AS
3305: l_api_name CONSTANT VARCHAR2(30) :='REGISTER_I030';
3306: l_book_number jl_br_cinfos_books.book_number%TYPE;
3307: l_book_name jl_br_cinfos_books.book_name%TYPE;
3308: l_nire NUMBER(11);
3309: l_cnpj xle_registrations.registration_number%TYPE;
3310: l_registration_id xle_registrations.registration_id%TYPE;

Line 3307: l_book_name jl_br_cinfos_books.book_name%TYPE;

3303:
3304: PROCEDURE register_I030 AS
3305: l_api_name CONSTANT VARCHAR2(30) :='REGISTER_I030';
3306: l_book_number jl_br_cinfos_books.book_number%TYPE;
3307: l_book_name jl_br_cinfos_books.book_name%TYPE;
3308: l_nire NUMBER(11);
3309: l_cnpj xle_registrations.registration_number%TYPE;
3310: l_registration_id xle_registrations.registration_id%TYPE;
3311: l_effective_from DATE;

Line 3330: jl_br_cinfos_books bk

3326: --retreiving book info
3327: SELECT le.effective_from,bk.book_number,bk.book_name
3328: INTO l_effective_from,l_book_number,l_book_name
3329: FROM xle_entity_profiles le,
3330: jl_br_cinfos_books bk
3331: WHERE le.legal_entity_id = g_legal_entity_id
3332: AND bk.legal_entity_id = le.legal_entity_id
3333: AND bk.establishment_id IS NULL -- need to retrive the book info of LE.
3334: AND bookkeeping_type = substrb(g_bookkeeping_type,1,1)

Line 3493: jl_br_cinfos_books bk

3489: --retreiving book info
3490: SELECT etb.effective_from,bk.book_number,bk.book_name
3491: INTO l_effective_from,l_book_number,l_book_name
3492: FROM xle_etb_profiles etb,
3493: jl_br_cinfos_books bk
3494: WHERE etb.legal_entity_id = g_legal_entity_id
3495: AND etb.establishment_id = g_establishment_id
3496: AND bk.legal_entity_id = etb.legal_entity_id
3497: AND bk.establishment_id = etb.establishment_id -- need to retrive the book info of ETB.

Line 6514: FROM jl_br_cinfos_books

6510: BEGIN
6511:
6512: SELECT book_number
6513: INTO l_book_number
6514: FROM jl_br_cinfos_books
6515: WHERE ((upper(g_accounting_type) = 'DECENTRALIZED' AND legal_entity_id = g_legal_entity_id AND establishment_id IS NULL)
6516: OR (upper(g_accounting_type) = 'CENTRALIZED' AND g_establishment_id IS NULL AND legal_entity_id = g_legal_entity_id)
6517: OR (upper(g_accounting_type) = 'CENTRALIZED' AND g_establishment_id IS NOT NULL AND legal_entity_id = g_legal_entity_id AND establishment_id=g_establishment_id))
6518: AND bookkeeping_type = substrb(g_bookkeeping_type,1,1)