APPS.PAY_BALANCE_TYPES_DATA_PUMP dependencies on HR_PUMP_BATCH_LINE_USER_KEYS

Line 6: -- Returns an ID value from hr_pump_batch_line_user_keys alone.

2: /* $Header: pybltdpm.pkb 120.0 2005/05/29 03:20:59 appldev noship $ */
3:
4: ------------------------------ user_key_to_id ---------------------------------
5: --
6: -- Returns an ID value from hr_pump_batch_line_user_keys alone.
7: -- Utility function to get _ID functions.
8: --
9: Function user_key_to_id(p_user_key_value in varchar2)
10: return number is

Line 15: from hr_pump_batch_line_user_keys

11: l_id number;
12: Begin
13: select unique_key_id
14: into l_id
15: from hr_pump_batch_line_user_keys
16: where user_key_value = p_user_key_value;
17: return(l_id);
18: End user_key_to_id;
19: --

Line 135: hr_pump_batch_line_user_keys key

131: Begin
132: select blt.object_version_number
133: into l_blt_ovn
134: from pay_balance_types blt,
135: hr_pump_batch_line_user_keys key
136: where key.user_key_value = p_balance_type_user_key
137: and blt.balance_type_id = key.unique_key_id;
138: --
139: return(l_blt_ovn);