APPS.PAY_IP_RUN_BALANCE_UPGRADE dependencies on PAY_BALANCE_TYPES

Line 38: TYPE character_data_table IS TABLE OF pay_balance_types.balance_name%type

34: */
35:
36: gv_package_name VARCHAR2(100);
37:
38: TYPE character_data_table IS TABLE OF pay_balance_types.balance_name%type
39: INDEX BY BINARY_INTEGER;
40:
41: gtt_updated_balances character_data_table;
42:

Line 63: pay_balance_types pbt,

59:
60: cursor c_primary_balance(cp_element_type_id in number) is
61: select distinct 'Y'
62: from pay_element_types_f pet,
63: pay_balance_types pbt,
64: pay_input_values_f piv
65: where pbt.input_value_id = piv.input_value_id
66: and piv.element_type_id = pet.element_type_id
67: and pbt.legislation_code is null

Line 115: pay_balance_types pbt,

111: pet.effective_start_date,
112: pbt.business_group_id
113: from pay_element_types_f pet,
114: pay_input_values_f piv,
115: pay_balance_types pbt,
116: pay_element_classifications pec
117: where pet.element_type_id = cp_element_type_id
118: and pet.element_type_id = piv.element_type_id
119: and pbt.input_value_id = piv.input_value_id

Line 128: pay_balance_types pbt,

124: ,cp_legislation_code in varchar2
125: ,cp_bal_dim in varchar2) is
126: select pdb.defined_balance_id
127: from pay_defined_balances pdb,
128: pay_balance_types pbt,
129: pay_balance_dimensions pbd
130: where pbt.balance_type_id = cp_bal_type_id
131: and pbd.database_item_suffix = cp_bal_dim
132: and pbd.legislation_code = cp_legislation_code

Line 197: update pay_balance_types

193: ,'Taxable Benefits'
194: ,'Employer Charges'
195: ,'Direct Payment') THEN
196:
197: update pay_balance_types
198: set balance_category_id = (SELECT BALANCE_CATEGORY_ID
199: FROM PAY_BALANCE_CATEGORIES_F
200: WHERE CATEGORY_NAME = 'Earnings'
201: AND legislation_code = lv_legislation_code)

Line 211: update pay_balance_types

207: ,'Pre-Tax Deductions'
208: ,'Involuntary Deductions'
209: ,'Voluntary Deductions') THEN
210:
211: update pay_balance_types
212: set balance_category_id = (SELECT BALANCE_CATEGORY_ID
213: FROM PAY_BALANCE_CATEGORIES_F
214: WHERE CATEGORY_NAME = 'Deductions'
215: AND legislation_code = lv_legislation_code)