APPS.PAYBALUP dependencies on PAY_BALANCE_TYPES

Line 171: from pay_balance_types

167: select balance_type_id,
168: nvl(jurisdiction_level, 999),
169: balance_uom
170: into l_balance_type_id, l_jurisdiction_level, l_bal_uom
171: from pay_balance_types
172: where upper(balance_name) = l_baltyp_name
173: and ((business_group_id = p_busgrp_id)
174: or( business_group_id is null
175: and legislation_code = p_leg_code)

Line 281: l_bt_id pay_balance_types.balance_type_id%TYPE;

277: retcode number := 0;
278: i number := 0;
279: l_bg_id per_business_groups.business_group_id%TYPE;
280: l_leg_code per_business_groups.legislation_code%TYPE;
281: l_bt_id pay_balance_types.balance_type_id%TYPE;
282: l_bal_dim_id pay_balance_dimensions.balance_dimension_id%TYPE;
283: --
284: cursor c_each_batch (c_batch_id number) is
285: select balance_name,

Line 331: l_bal_uom pay_balance_types.balance_uom%TYPE;

327: -- retcode = 0 means no error and retcode = 2 means an error occurred.
328: --
329: l_n_elems number := 0;
330: j number;
331: l_bal_uom pay_balance_types.balance_uom%TYPE;
332: l_element_name pay_element_types.element_name%TYPE;
333: l_element_type_id pay_element_types.element_type_id%TYPE;
334: l_elem_link_id pay_element_links.element_link_id%TYPE;
335: l_input_val_id pay_input_values.input_value_id%TYPE;

Line 336: l_bal_name pay_balance_types.balance_name%TYPE;

332: l_element_name pay_element_types.element_name%TYPE;
333: l_element_type_id pay_element_types.element_type_id%TYPE;
334: l_elem_link_id pay_element_links.element_link_id%TYPE;
335: l_input_val_id pay_input_values.input_value_id%TYPE;
336: l_bal_name pay_balance_types.balance_name%TYPE;
337: l_bal_type_id pay_balance_types.balance_type_id%TYPE;
338: l_bal_feed_id pay_balance_feeds.balance_feed_id%TYPE;
339: l_bg_name hr_organization_units.name%TYPE;
340: l_bg_id hr_organization_units.organization_id%TYPE;

Line 337: l_bal_type_id pay_balance_types.balance_type_id%TYPE;

333: l_element_type_id pay_element_types.element_type_id%TYPE;
334: l_elem_link_id pay_element_links.element_link_id%TYPE;
335: l_input_val_id pay_input_values.input_value_id%TYPE;
336: l_bal_name pay_balance_types.balance_name%TYPE;
337: l_bal_type_id pay_balance_types.balance_type_id%TYPE;
338: l_bal_feed_id pay_balance_feeds.balance_feed_id%TYPE;
339: l_bg_name hr_organization_units.name%TYPE;
340: l_bg_id hr_organization_units.organization_id%TYPE;
341: l_jur_level number;