APPS.HXT_HXT007A_XMLP_PKG dependencies on HR_LOOKUPS

Line 135: l_meaning HR_LOOKUPS.MEANING%TYPE;

131: lookup12 PAY_INPUT_VALUES_F.LOOKUP_TYPE%TYPE := NULL;
132: lookup13 PAY_INPUT_VALUES_F.LOOKUP_TYPE%TYPE := NULL;
133: lookup14 PAY_INPUT_VALUES_F.LOOKUP_TYPE%TYPE := NULL;
134: lookup15 PAY_INPUT_VALUES_F.LOOKUP_TYPE%TYPE := NULL;
135: l_meaning HR_LOOKUPS.MEANING%TYPE;
136: l_value PAY_BATCH_LINES.VALUE_1%TYPE;
137: l_hours HXT_DET_HOURS_WORKED_F.HOURS%TYPE := 0;
138: l_amount VARCHAR2(80) := NULL;
139: l_dummy NUMBER;

Line 143: FROM hr_lookups

139: l_dummy NUMBER;
140:
141: CURSOR hours_value(p_meaning VARCHAR2, p_date DATE) IS
142: SELECT 1
143: FROM hr_lookups
144: WHERE lookup_code = 'HOURS'
145: AND meaning = p_meaning
146: AND lookup_type = 'NAME_TRANSLATIONS'
147: AND enabled_flag = 'Y'

Line 152: FROM hr_lookups

148: AND p_date BETWEEN nvl(start_date_active, p_date) AND nvl(end_date_active, p_date);
149:
150: CURSOR amount_value(p_meaning VARCHAR2, p_date DATE) IS
151: SELECT 1
152: FROM hr_lookups
153: WHERE lookup_code = 'PAY VALUE'
154: AND meaning = p_meaning
155: AND lookup_type = 'NAME_TRANSLATIONS'
156: AND enabled_flag = 'Y'