DBA Data[Home] [Help]

APPS.FV_FACTS1_GL_PKG dependencies on GL_LEDGERS_PUBLIC_V

Line 10: gbl_currency_code gl_ledgers_public_v.currency_code%TYPE;

6: gbl_acc_segment VARCHAR2(10);
7: gbl_jrnl_attribute VARCHAR2(15);
8: gbl_vend_attribute VARCHAR2(15);
9: gbl_cust_attribute VARCHAR2(15);
10: gbl_currency_code gl_ledgers_public_v.currency_code%TYPE;
11: gbl_period_name gl_period_statuses.period_name%TYPE;
12: gbl_sob_id gl_ledgers_public_v.ledger_id%TYPE;
13: gbl_coa_id gl_ledgers_public_v.chart_of_accounts_id%TYPE;
14: gbl_err_code NUMBER := 0;

Line 12: gbl_sob_id gl_ledgers_public_v.ledger_id%TYPE;

8: gbl_vend_attribute VARCHAR2(15);
9: gbl_cust_attribute VARCHAR2(15);
10: gbl_currency_code gl_ledgers_public_v.currency_code%TYPE;
11: gbl_period_name gl_period_statuses.period_name%TYPE;
12: gbl_sob_id gl_ledgers_public_v.ledger_id%TYPE;
13: gbl_coa_id gl_ledgers_public_v.chart_of_accounts_id%TYPE;
14: gbl_err_code NUMBER := 0;
15: gbl_err_buff VARCHAR2(250);
16: gbl_period_num_low gl_period_statuses.period_num%TYPE;

Line 13: gbl_coa_id gl_ledgers_public_v.chart_of_accounts_id%TYPE;

9: gbl_cust_attribute VARCHAR2(15);
10: gbl_currency_code gl_ledgers_public_v.currency_code%TYPE;
11: gbl_period_name gl_period_statuses.period_name%TYPE;
12: gbl_sob_id gl_ledgers_public_v.ledger_id%TYPE;
13: gbl_coa_id gl_ledgers_public_v.chart_of_accounts_id%TYPE;
14: gbl_err_code NUMBER := 0;
15: gbl_err_buff VARCHAR2(250);
16: gbl_period_num_low gl_period_statuses.period_num%TYPE;
17: gbl_period_num_high gl_period_statuses.period_num%TYPE;

Line 319: FROM gl_ledgers_public_v

315: SELECT currency_code,
316: chart_of_accounts_id
317: INTO gbl_currency_code,
318: gbl_coa_id
319: FROM gl_ledgers_public_v
320: WHERE ledger_id = gbl_sob_id;
321:
322: FV_UTILITY.LOG_MESG('Journal Attribute: '||gbl_jrnl_attribute);
323: FV_UTILITY.LOG_MESG('Vendor Attribute: '||gbl_vend_attribute);