DBA Data[Home] [Help]

APPS.PSA_MFAR_UTILS dependencies on FND_FLEX_VALUES

Line 787: fnd_flex_values v,

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
791: AND b.set_of_books_id = p_set_of_books_id

Line 819: l_account_code fnd_flex_values.compiled_value_attributes%TYPE;

815: AND b.source_account = c_source_account
816: AND trunc(sysdate) >= trunc(b.start_date_active)
817: AND trunc(sysdate) <= trunc(nvl(b.end_date_active,sysdate));
818:
819: l_account_code fnd_flex_values.compiled_value_attributes%TYPE;
820: l_mapped_account PSA_MF_ACCOUNT_MAPPING_ALL.target_account%TYPE;
821:
822: -- ========================= FND LOG ===========================
823: l_full_path VARCHAR2(100) := g_path || 'get_mapped_account';