DBA Data[Home] [Help]

APPS.HXC_SUPERVISOR_DASHBOARD dependencies on HXC_PREFERENCE_EVALUATION

Line 88: pref_table hxc_preference_evaluation.t_pref_table;

84:
85:
86: l_temp number;
87:
88: pref_table hxc_preference_evaluation.t_pref_table;
89:
90: l_direct_sql VARCHAR2(32000) :=
91: 'SELECT
92: asg.person_id,

Line 2751: hxc_preference_evaluation.resource_preferences(p_resource_id => l_person_det(l_index).person_id,

2747:
2748: FOR l_index in l_person_det.First..l_person_det.Last
2749: LOOP
2750:
2751: hxc_preference_evaluation.resource_preferences(p_resource_id => l_person_det(l_index).person_id,
2752: p_start_evaluation_date => l_person_det(l_index).start_date,
2753: p_end_evaluation_date => l_person_det(l_index).end_date,
2754: p_pref_table => pref_table);
2755: IF pref_table.COUNT > 0