APPS.HR_US_REPORTS dependencies on HR_LOOKUPS

Line 258: hr_lookups hl

254: pay_element_entries_f pee,
255: per_pay_bases ppb,
256: hr_soft_coding_keyflex hscf,
257: per_assignments_f asg,
258: hr_lookups hl
259: Where
260: hl.application_id = 800
261: And hl.lookup_type = 'PAY_BASIS'
262: And hl.lookup_code = ppb.pay_basis

Line 1155: v_qualifying_event_meaning hr_lookups.meaning%type;

1151: --
1152: FUNCTION get_cobra_qualifying_event
1153: ( p_qualifying_event VARCHAR2 ) return VARCHAR2 IS
1154: --
1155: v_qualifying_event_meaning hr_lookups.meaning%type;
1156: --
1157: BEGIN
1158: hr_utility.trace('Entered hr_reports.get_cobra_qualifying_event');
1159: --

Line 1169: FROM hr_lookups

1165: BEGIN
1166: hr_utility.set_location('hr_reports.get_cobra_qualifying_event',10);
1167: SELECT meaning
1168: INTO v_qualifying_event_meaning
1169: FROM hr_lookups
1170: WHERE lookup_type = 'US_COBRA_EVENT'
1171: AND lookup_code = p_qualifying_event;
1172: EXCEPTION
1173: WHEN no_data_found THEN RETURN NULL;

Line 1187: v_cobra_status_meaning hr_lookups.meaning%type;

1183: --
1184: FUNCTION get_cobra_status
1185: ( p_cobra_status VARCHAR2 ) return VARCHAR2 IS
1186: --
1187: v_cobra_status_meaning hr_lookups.meaning%type;
1188: --
1189: BEGIN
1190: hr_utility.trace('Entered hr_reports.get_cobra_status');
1191: --

Line 1201: FROM hr_lookups

1197: BEGIN
1198: hr_utility.set_location('hr_reports.get_cobra_status',10);
1199: SELECT meaning
1200: INTO v_cobra_status_meaning
1201: FROM hr_lookups
1202: WHERE lookup_type = 'US_COBRA_STATUS'
1203: AND lookup_code = p_cobra_status;
1204: EXCEPTION
1205: WHEN no_data_found THEN RETURN NULL;