APPS.FV_AP_CASH_POS_DTL_PKG dependencies on GL_LEDGERS_PUBLIC_V

Line 12: g_set_of_books_id gl_ledgers_public_v.ledger_id %TYPE;

8: g_acct_segment_num NUMBER(15);
9: g_bal_segment_name VARCHAR2(30);
10: g_acct_segment_name VARCHAR2(30);
11: g_check_date DATE;
12: g_set_of_books_id gl_ledgers_public_v.ledger_id %TYPE;
13: g_set_of_books_name gl_ledgers_public_v.name%type;
14: g_flex_num gl_code_combinations.chart_of_accounts_id%TYPE;
15: g_segment_value gl_code_combinations.segment1%TYPE;
16: g_error_code NUMBER(15);

Line 13: g_set_of_books_name gl_ledgers_public_v.name%type;

9: g_bal_segment_name VARCHAR2(30);
10: g_acct_segment_name VARCHAR2(30);
11: g_check_date DATE;
12: g_set_of_books_id gl_ledgers_public_v.ledger_id %TYPE;
13: g_set_of_books_name gl_ledgers_public_v.name%type;
14: g_flex_num gl_code_combinations.chart_of_accounts_id%TYPE;
15: g_segment_value gl_code_combinations.segment1%TYPE;
16: g_error_code NUMBER(15);
17: g_error_buf VARCHAR2(500);

Line 350: FROM gl_period_statuses gps ,gl_ledgers_public_v glpv

346: CURSOR period_detail_cur(p_checkrun_date DATE,
347: p_apps_id NUMBER,
348: p_set_of_books_id NUMBER) IS
349: SELECT gps.period_num,gps.period_year,glpv.currency_CODE
350: FROM gl_period_statuses gps ,gl_ledgers_public_v glpv
351: WHERE Start_date <= p_checkrun_date
352: AND end_date >= p_checkrun_date
353: AND gps.application_id = p_apps_id
354: AND gps.set_of_books_id =p_set_of_books_id

Line 619: FROM gl_ledgers_public_v

615: l_module_name VARCHAR2(200) ;
616:
617: CURSOR chart_acct_id_cur(p_set_of_books_id NUMBER) IS
618: SELECT chart_of_accounts_id
619: FROM gl_ledgers_public_v
620: WHERE ledger_id = p_set_of_books_id;
621:
622: l_num_boolean boolean;
623: l_seg_number Number ;