APPS.HXC_PREFERENCE_EVALUATION dependencies on HXC_PREF_DEFINITIONS

Line 16: ( code hxc_pref_definitions.code%TYPE,

12: org_version_id per_org_structure_versions.org_structure_version_id%type,
13: time_info date);
14:
15: TYPE t_requested_pref IS RECORD
16: ( code hxc_pref_definitions.code%TYPE,
17: attr_list VARCHAR2(90) );
18:
19: TYPE t_dated_pref_row IS RECORD
20: ( start_date DATE,

Line 22: code hxc_pref_definitions.code%TYPE,

18:
19: TYPE t_dated_pref_row IS RECORD
20: ( start_date DATE,
21: end_date DATE,
22: code hxc_pref_definitions.code%TYPE,
23: rule_evaluation_order NUMBER,
24: pref_ref NUMBER,
25: edit_allowed hxc_pref_hierarchies.edit_allowed%TYPE);
26:

Line 41: hxc_pref_definitions.code%TYPE

37: t_requested_pref
38: INDEX BY BINARY_INTEGER;
39:
40: TYPE t_pref_trans IS TABLE OF
41: hxc_pref_definitions.code%TYPE
42: INDEX BY BINARY_INTEGER;
43:
44: TYPE t_hierarchy_list IS TABLE OF
45: t_hierarchy_list_row

Line 369: FROM hxc_pref_definitions;*/

365: /*CURSOR c_pref_codes
366: IS
367: SELECT
368: pref_definition_id, code
369: FROM hxc_pref_definitions;*/
370:
371: l_user_id NUMBER;
372:
373: /* Mikarthi Terminated CWK Enhancement */

Line 1777: FROM hxc_pref_definitions;

1773: CURSOR c_pref_codes
1774: IS
1775: SELECT
1776: pref_definition_id, code
1777: FROM hxc_pref_definitions;
1778:
1779: --VARIABLES ADDED by Mithun for Perst Resp enhancement
1780: l_find_resp_required BOOLEAN DEFAULT FALSE;
1781: l_resp_id NUMBER;

Line 2647: hxc_pref_definitions hpd

2643: p_value VARCHAR2)
2644: IS
2645: SELECT count(*)
2646: FROM hxc_pref_hierarchies hph,
2647: hxc_pref_definitions hpd
2648: WHERE hph.pref_definition_id = hpd.pref_definition_id
2649: AND hpd.code = p_preference_code
2650: AND decode (p_attributen, 1, hph.attribute1, 2, hph.attribute2, 3, hph.attribute3,
2651: 4, hph.attribute4, 5, hph.attribute5, 6, hph.attribute6,