APPS.PAY_HR_OTC_RETRIEVAL_INTERFACE dependencies on HR_GENERAL

Line 274: hr_general.decode_lookup ('UNITS',

270: hr_utility.trace(dbms_utility.format_error_backtrace);
271: hr_utility.set_message ('PAY', 'PAY_6306_INPUT_VALUE_FORMAT');
272: hr_utility.set_message_token
273: ('UNIT_OF_MEASURE',
274: hr_general.decode_lookup ('UNITS',
275: rec_iv_info.uom
276: )
277: );
278: hr_utility.raise_error;

Line 2794: AND paf.effective_end_date = hr_general.end_of_time

2790: per_all_assignments_f paf,
2791: per_assignment_status_types pas
2792: WHERE resource_id = person_id
2793: AND batch_source = 'OTM'
2794: AND paf.effective_end_date = hr_general.end_of_time
2795: AND paf.effective_start_date <= date_earned
2796: AND paf.primary_flag = 'Y'
2797: AND paf.assignment_status_type_id =
2798: pas.assignment_status_type_id

Line 2801: AND effective_end_date = hr_general.end_of_time;

2797: AND paf.assignment_status_type_id =
2798: pas.assignment_status_type_id
2799: AND pas.per_system_status = 'ACTIVE_ASSIGN')
2800: AND pay_status <> 'C'
2801: AND effective_end_date = hr_general.end_of_time;
2802: EXCEPTION
2803: WHEN NO_DATA_FOUND THEN
2804: null;
2805: END;