APPS.HR_US_REPORTS dependencies on HR_LOOKUPS

Line 266: hr_lookups hl

262: pay_element_entries_f pee,
263: per_pay_bases ppb,
264: hr_soft_coding_keyflex hscf,
265: per_assignments_f asg,
266: hr_lookups hl
267: Where
268: hl.application_id = 800
269: And hl.lookup_type = 'PAY_BASIS'
270: And hl.lookup_code = ppb.pay_basis

Line 1173: v_qualifying_event_meaning hr_lookups.meaning%type;

1169: --
1170: FUNCTION get_cobra_qualifying_event
1171: ( p_qualifying_event VARCHAR2 ) return VARCHAR2 IS
1172: --
1173: v_qualifying_event_meaning hr_lookups.meaning%type;
1174: --
1175: BEGIN
1176: hr_utility.trace('Entered hr_reports.get_cobra_qualifying_event');
1177: --

Line 1187: FROM hr_lookups

1183: BEGIN
1184: hr_utility.set_location('hr_reports.get_cobra_qualifying_event',10);
1185: SELECT meaning
1186: INTO v_qualifying_event_meaning
1187: FROM hr_lookups
1188: WHERE lookup_type = 'US_COBRA_EVENT'
1189: AND lookup_code = p_qualifying_event;
1190: EXCEPTION
1191: WHEN no_data_found THEN RETURN NULL;

Line 1205: v_cobra_status_meaning hr_lookups.meaning%type;

1201: --
1202: FUNCTION get_cobra_status
1203: ( p_cobra_status VARCHAR2 ) return VARCHAR2 IS
1204: --
1205: v_cobra_status_meaning hr_lookups.meaning%type;
1206: --
1207: BEGIN
1208: hr_utility.trace('Entered hr_reports.get_cobra_status');
1209: --

Line 1219: FROM hr_lookups

1215: BEGIN
1216: hr_utility.set_location('hr_reports.get_cobra_status',10);
1217: SELECT meaning
1218: INTO v_cobra_status_meaning
1219: FROM hr_lookups
1220: WHERE lookup_type = 'US_COBRA_STATUS'
1221: AND lookup_code = p_cobra_status;
1222: EXCEPTION
1223: WHEN no_data_found THEN RETURN NULL;