APPS.HXC_HPH_UPLOAD_PKG dependencies on FND_DESCR_FLEX_CONTEXTS_VL

Line 73: , fnd_descr_flex_contexts_vl df

69:
70: CURSOR csr_get_pref_def_id IS
71: SELECT pd.pref_definition_id
72: FROM hxc_pref_definitions pd
73: , fnd_descr_flex_contexts_vl df
74: WHERE df.application_id = 809
75: AND df.descriptive_flexfield_name = 'OTC PREFERENCES'
76: AND df.descriptive_flex_context_name = p_pref_def_name
77: AND df.descriptive_flex_context_code = pd.code;

Line 410: l_name fnd_descr_flex_contexts_vl.descriptive_flex_context_name%TYPE;

406: END load_hph_row;
407:
408: FUNCTION get_pref_def_name ( p_pref_definition_id NUMBER ) RETURN VARCHAR2 IS
409:
410: l_name fnd_descr_flex_contexts_vl.descriptive_flex_context_name%TYPE;
411:
412: CURSOR csr_get_name IS
413: SELECT df.descriptive_flex_context_name
414: FROM fnd_descr_flex_contexts_vl df

Line 414: FROM fnd_descr_flex_contexts_vl df

410: l_name fnd_descr_flex_contexts_vl.descriptive_flex_context_name%TYPE;
411:
412: CURSOR csr_get_name IS
413: SELECT df.descriptive_flex_context_name
414: FROM fnd_descr_flex_contexts_vl df
415: , hxc_pref_definitions pd
416: WHERE pd.pref_definition_id = p_pref_definition_id
417: AND df.application_id =809
418: AND df.descriptive_flexfield_name = 'OTC PREFERENCES'