DBA Data[Home] [Help]

APPS.FV_FACTS_TBAL_TRX dependencies on GL_LEDGERS

Line 3404: FROM gl_ledgers_public_v

3400: -- Getting the Chart of Accounts Id
3401: BEGIN
3402: SELECT chart_of_accounts_id
3403: INTO v_chart_of_accounts_id
3404: FROM gl_ledgers_public_v
3405: WHERE ledger_id = vp_set_of_books_id;
3406:
3407: fv_utility.log_mesg('v_chart_of_accounts_id :: '||v_chart_of_accounts_id);
3408: EXCEPTION

Line 3564: l_sob_name gl_ledgers.name%TYPE;

3560: AND flex_value between vp_fund_low and vp_fund_high
3561: AND summary_flag = 'N';
3562:
3563: vl_req_id number;
3564: l_sob_name gl_ledgers.name%TYPE;
3565:
3566:
3567: BEGIN
3568:

Line 3665: FROM gl_ledgers

3661: --Added to get sob name since
3662: --profile was getting the inappropriate name
3663: SELECT name
3664: INTO l_sob_name
3665: FROM gl_ledgers
3666: WHERE ledger_id = vp_set_of_books_id
3667: AND currency_code = 'USD';
3668:
3669: