APPS.PAY_CN_BAL_UPL_STRUCT dependencies on PAY_ELEMENT_TYPES

Line 463: l_element_name pay_element_types.element_name%TYPE;

459:
460: l_n_elems NUMBER := 0;
461: j NUMBER;
462: l_bal_uom pay_balance_types.balance_uom%TYPE;
463: l_element_name pay_element_types.element_name%TYPE;
464: l_element_type_id pay_element_types.element_type_id%TYPE;
465: l_elem_link_id pay_element_links.element_link_id%TYPE;
466: l_input_val_id pay_input_values.input_value_id%TYPE;
467: l_bal_name pay_balance_types.balance_name%TYPE;

Line 464: l_element_type_id pay_element_types.element_type_id%TYPE;

460: l_n_elems NUMBER := 0;
461: j NUMBER;
462: l_bal_uom pay_balance_types.balance_uom%TYPE;
463: l_element_name pay_element_types.element_name%TYPE;
464: l_element_type_id pay_element_types.element_type_id%TYPE;
465: l_elem_link_id pay_element_links.element_link_id%TYPE;
466: l_input_val_id pay_input_values.input_value_id%TYPE;
467: l_bal_name pay_balance_types.balance_name%TYPE;
468: l_bal_type_id pay_balance_types.balance_type_id%TYPE;

Line 501: pay_element_types_f ET,

497: IS
498: SELECT balance_feed_id
499: FROM pay_balance_feeds_f BF,
500: pay_input_values_f IV,
501: pay_element_types_f ET,
502: pay_element_classifications EC
503: WHERE EC.classification_name = 'Balance Initialization'
504: AND ET.classification_id = EC.classification_id
505: AND IV.element_type_id = ET.element_type_id

Line 682: UPDATE pay_element_types_f ELEM

678: p_post_termination_rule => 'Final Close');
679:
680: hr_utility.trace ('Element name after IS:' || l_element_name);
681:
682: UPDATE pay_element_types_f ELEM
683: SET ELEM.element_information1 = 'B'
684: WHERE element_type_id = l_element_type_id;
685: --
686: -- create an element link for each element type created.