APPS.QRM_PA_AGGREGATION_P dependencies on GL_SETS_OF_BOOKS

Line 613: v_prev_ccy gl_sets_of_books.currency_code%TYPE;

609: p_md_set_code VARCHAR2,
610: p_ref_date DATE)
611: IS
612:
613: v_prev_ccy gl_sets_of_books.currency_code%TYPE;
614: v_ccy gl_sets_of_books.currency_code%TYPE;
615: v_fx_rate NUMBER;
616:
617: CURSOR get_sob_ccy (p_company_code VARCHAR2) IS

Line 614: v_ccy gl_sets_of_books.currency_code%TYPE;

610: p_ref_date DATE)
611: IS
612:
613: v_prev_ccy gl_sets_of_books.currency_code%TYPE;
614: v_ccy gl_sets_of_books.currency_code%TYPE;
615: v_fx_rate NUMBER;
616:
617: CURSOR get_sob_ccy (p_company_code VARCHAR2) IS
618: SELECT sob.currency_code

Line 619: FROM gl_sets_of_books sob, xtr_party_info pinfo

615: v_fx_rate NUMBER;
616:
617: CURSOR get_sob_ccy (p_company_code VARCHAR2) IS
618: SELECT sob.currency_code
619: FROM gl_sets_of_books sob, xtr_party_info pinfo
620: WHERE pinfo.party_code = p_company_code AND
621: pinfo.set_of_books_id = sob.set_of_books_id;
622:
623: BEGIN