APPS.PAY_PUMP_GET dependencies on HR_PUMP_BATCH_LINE_USER_KEYS

Line 8: Returns an ID value from hr_pump_batch_line_user_keys alone.

4: /*
5: NAME
6: user_key_to_id
7: DESCRIPTION
8: Returns an ID value from hr_pump_batch_line_user_keys alone.
9: NOTES
10: Utility function to get _ID functions.
11: */
12: function user_key_to_id

Line 20: from hr_pump_batch_line_user_keys

16: l_id number;
17: begin
18: select unique_key_id
19: into l_id
20: from hr_pump_batch_line_user_keys
21: where user_key_value = p_user_key_value;
22: return(l_id);
23: exception
24: when others then

Line 49: , hr_pump_batch_line_user_keys key

45: begin
46: select rt.object_version_number
47: into l_ovn
48: from pay_run_types_f rt
49: , hr_pump_batch_line_user_keys key
50: where key.user_key_value = p_run_type_user_key
51: and rt.run_type_id = key.unique_key_id
52: and p_effective_date between
53: rt.effective_start_date and rt.effective_end_date;