APPS.PAYBALUP dependencies on PAY_ELEMENT_TYPES

Line 332: l_element_name pay_element_types.element_name%TYPE;

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;
336: l_bal_name pay_balance_types.balance_name%TYPE;

Line 333: l_element_type_id pay_element_types.element_type_id%TYPE;

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;
336: l_bal_name pay_balance_types.balance_name%TYPE;
337: l_bal_type_id pay_balance_types.balance_type_id%TYPE;

Line 354: pay_element_types_f ET,

350: is
351: select balance_feed_id
352: from pay_balance_feeds_f BF,
353: pay_input_values_f IV,
354: pay_element_types_f ET,
355: pay_element_classifications EC
356: where EC.balance_initialization_flag = 'Y'
357: and ET.classification_id = EC.classification_id
358: and ET.effective_start_date = to_date('0001/01/01','YYYY/MM/DD')

Line 465: update pay_element_types_f ELEM

461: --
462: hr_utility.trace (
463: 'Element name after is:' || l_element_name);
464: --
465: update pay_element_types_f ELEM
466: set ELEM.element_information1 = 'B'
467: where element_type_id = l_element_type_id;
468: /*
469: create an element link for each element type created.