[Home] [Help]
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;
286: l_bal_name pay_balance_types.balance_name%TYPE;
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;
286: l_bal_name pay_balance_types.balance_name%TYPE;
287: l_bal_type_id pay_balance_types.balance_type_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;
292: l_dummy_id number;
293: l_bg_currency_code pay_element_types.output_currency_code%TYPE;
294: --
295: cursor csr_is_balance_fed (p_balance_type_id number,
296: p_business_group number)
297: is
297: is
298: select balance_feed_id
299: from pay_balance_feeds_f BF,
300: pay_input_values_f IV,
301: pay_element_types_f ET,
302: pay_element_classifications EC
303: where EC.classification_name = 'Balance Initialization'
304: and ET.classification_id = EC.classification_id
305: and IV.element_type_id = ET.element_type_id
381: p_business_group_name => l_bg_name,
382: p_processing_priority => 0,
383: p_post_termination_rule => 'Final Close');
384: --
385: update pay_element_types_f ELEM
386: set ELEM.element_information1 = 'B'
387: where element_type_id = l_element_type_id;
388: /*
389: create an element link for each element type created.