APPS.PAY_HR_OTC_RETRIEVAL_INTERFACE dependencies on HR_GENERAL

Line 179: hr_general.decode_lookup ('UNITS',

175: THEN
176: hr_utility.set_message ('PAY', 'PAY_6306_INPUT_VALUE_FORMAT');
177: hr_utility.set_message_token
178: ('UNIT_OF_MEASURE',
179: hr_general.decode_lookup ('UNITS',
180: rec_iv_info.uom
181: )
182: );
183: hr_utility.raise_error;

Line 2054: AND paf.effective_end_date = hr_general.end_of_time

2050: per_all_assignments_f paf,
2051: per_assignment_status_types pas
2052: WHERE resource_id = person_id
2053: AND batch_source = 'OTM'
2054: AND paf.effective_end_date = hr_general.end_of_time
2055: AND paf.effective_start_date <= date_earned
2056: AND paf.primary_flag = 'Y'
2057: AND paf.assignment_status_type_id =
2058: pas.assignment_status_type_id

Line 2061: AND effective_end_date = hr_general.end_of_time;

2057: AND paf.assignment_status_type_id =
2058: pas.assignment_status_type_id
2059: AND pas.per_system_status = 'ACTIVE_ASSIGN')
2060: AND pay_status <> 'C'
2061: AND effective_end_date = hr_general.end_of_time;
2062: EXCEPTION
2063: WHEN NO_DATA_FOUND THEN
2064: null;
2065: END;