APPS.PYSGBUPL dependencies on PAY_BALANCE_TYPES

Line 122: from pay_balance_types

118: --
119: select balance_type_id,
120: balance_uom
121: into l_balance_type_id, l_bal_uom
122: from pay_balance_types
123: where upper(balance_name) = l_baltyp_name
124: and ((business_group_id = p_busgrp_id)
125: or( business_group_id is null
126: and legislation_code = p_leg_code)

Line 230: l_bt_id pay_balance_types.balance_type_id%TYPE;

226: retcode number := 0;
227: i number := 0;
228: l_bg_id per_business_groups.business_group_id%TYPE;
229: l_leg_code per_business_groups.legislation_code%TYPE;
230: l_bt_id pay_balance_types.balance_type_id%TYPE;
231: l_bal_dim_id pay_balance_dimensions.balance_dimension_id%TYPE;
232: --
233: cursor c_each_batch (c_batch_id number) is
234: select balance_name,

Line 281: l_bal_uom pay_balance_types.balance_uom%TYPE;

277: --
278: --
279: l_n_elems number := 0;
280: j number;
281: l_bal_uom pay_balance_types.balance_uom%TYPE;
282: l_element_name pay_element_types.element_name%TYPE;
283: l_element_type_id pay_element_types.element_type_id%TYPE;
284: l_elem_link_id pay_element_links.element_link_id%TYPE;
285: l_input_val_id pay_input_values.input_value_id%TYPE;

Line 286: l_bal_name pay_balance_types.balance_name%TYPE;

282: l_element_name pay_element_types.element_name%TYPE;
283: l_element_type_id pay_element_types.element_type_id%TYPE;
284: l_elem_link_id pay_element_links.element_link_id%TYPE;
285: l_input_val_id pay_input_values.input_value_id%TYPE;
286: l_bal_name pay_balance_types.balance_name%TYPE;
287: l_bal_type_id pay_balance_types.balance_type_id%TYPE;
288: l_bal_feed_id pay_balance_feeds.balance_feed_id%TYPE;
289: l_bg_name hr_organization_units.name%TYPE;
290: l_bg_id hr_organization_units.organization_id%TYPE;

Line 287: l_bal_type_id pay_balance_types.balance_type_id%TYPE;

283: l_element_type_id pay_element_types.element_type_id%TYPE;
284: l_elem_link_id pay_element_links.element_link_id%TYPE;
285: l_input_val_id pay_input_values.input_value_id%TYPE;
286: l_bal_name pay_balance_types.balance_name%TYPE;
287: l_bal_type_id pay_balance_types.balance_type_id%TYPE;
288: l_bal_feed_id pay_balance_feeds.balance_feed_id%TYPE;
289: l_bg_name hr_organization_units.name%TYPE;
290: l_bg_id hr_organization_units.organization_id%TYPE;
291: l_bal_count number;