APPS.HXC_HPH_UPLOAD_PKG dependencies on HXC_PREF_DEFINITIONS

Line 72: FROM hxc_pref_definitions pd

68: l_pref_definition_id hxc_pref_hierarchies.pref_definition_id%TYPE;
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

Line 415: , hxc_pref_definitions pd

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'
419: AND df.descriptive_flex_context_code = pd.code;