APPS.PAY_BALANCE_TYPES_DATA_PUMP dependencies on PAY_BALANCE_TYPES

Line 1: PACKAGE BODY pay_balance_types_data_pump AS

1: PACKAGE BODY pay_balance_types_data_pump AS
2: /* $Header: pybltdpm.pkb 120.0 2005/05/29 03:20:59 appldev noship $ */
3:
4: ------------------------------ user_key_to_id ---------------------------------
5: --

Line 31: l_balance_category_id pay_balance_types.balance_category_id%type;

27: ,p_business_group_id in number
28: ,p_category_name in varchar2
29: ) return number is
30: --
31: l_balance_category_id pay_balance_types.balance_category_id%type;
32: --
33: Begin
34: select balance_category_id
35: into l_balance_category_id

Line 69: from pay_balance_types

65: Begin
66:
67: select balance_type_id
68: into l_balance_type_id
69: from pay_balance_types
70: where base_balance_type_id is null
71: and balance_name = p_base_balance_name
72: and nvl(business_group_id, nvl(p_business_group_id,-1))
73: = nvl(p_business_group_id,-1)

Line 134: from pay_balance_types blt,

130: --
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: --

Line 167: END pay_balance_types_data_pump ;

163: hr_data_pump.fail('get_balance_type_id', sqlerrm, p_balance_type_user_key);
164: raise;
165: end get_balance_type_id;
166: --
167: END pay_balance_types_data_pump ;