APPS.PSA_MFAR_UTILS dependencies on GL_SETS_OF_BOOKS

Line 368: FROM gl_sets_of_books

364: IF g_chart_of_accounts_id IS NULL THEN
365:
366: SELECT chart_of_accounts_id
367: INTO g_chart_of_accounts_id
368: FROM gl_sets_of_books
369: WHERE set_of_books_id = p_set_of_books_id;
370:
371: -- ========================= FND LOG ===========================
372: psa_utils.debug_other_string(g_state_level,l_full_path,' g_chart_of_accounts_id --> ' || g_chart_of_accounts_id);

Line 786: FROM gl_sets_of_books b,

782:
783:
784: CURSOR c_account_code IS
785: SELECT SUBSTR(v.compiled_value_attributes,5,1) account_code
786: FROM gl_sets_of_books b,
787: fnd_flex_values v,
788: fnd_id_flex_segments s
789: WHERE v.flex_value_set_id = s.flex_value_set_id
790: AND v.flex_value = p_natural_account

Line 1023: FROM gl_sets_of_books

1019: -- ========================= FND LOG ===========================
1020:
1021: SELECT chart_of_accounts_id
1022: INTO l_ret_coa_id
1023: FROM gl_sets_of_books
1024: WHERE set_of_books_id = sob_id;
1025:
1026: -- ========================= FND LOG ===========================
1027: psa_utils.debug_other_string(g_state_level,l_full_path,' RETURN l_ret_coa_id --> ' || l_ret_coa_id);