APPS.PAY_IN_BAL_UPL_STRUCT dependencies on PAY_ELEMENT_TYPES

Line 383: l_element_name pay_element_types.element_name%TYPE;

379:
380: l_n_elems number := 0;
381: j number;
382: l_bal_uom pay_balance_types.balance_uom%TYPE;
383: l_element_name pay_element_types.element_name%TYPE;
384: l_element_type_id pay_element_types.element_type_id%TYPE;
385: l_elem_link_id pay_element_links.element_link_id%TYPE;
386: l_input_val_id pay_input_values.input_value_id%TYPE;
387: l_bal_name pay_balance_types.balance_name%TYPE;

Line 384: l_element_type_id pay_element_types.element_type_id%TYPE;

380: l_n_elems number := 0;
381: j number;
382: l_bal_uom pay_balance_types.balance_uom%TYPE;
383: l_element_name pay_element_types.element_name%TYPE;
384: l_element_type_id pay_element_types.element_type_id%TYPE;
385: l_elem_link_id pay_element_links.element_link_id%TYPE;
386: l_input_val_id pay_input_values.input_value_id%TYPE;
387: l_bal_name pay_balance_types.balance_name%TYPE;
388: l_bal_type_id pay_balance_types.balance_type_id%TYPE;

Line 419: pay_element_types_f ET,

415: is
416: select balance_feed_id
417: from pay_balance_feeds_f BF,
418: pay_input_values_f IV,
419: pay_element_types_f ET,
420: pay_element_classifications EC
421: where EC.classification_name = 'Balance Initialization'
422: and ET.classification_id = EC.classification_id
423: and IV.element_type_id = ET.element_type_id

Line 625: update pay_element_types_f ELEM

621:
622: pay_in_utils.trace (
623: 'Element name after is:' || l_element_name, l_procedure);
624:
625: update pay_element_types_f ELEM
626: set ELEM.element_information1 = 'B'
627: where element_type_id = l_element_type_id;
628: /*
629: create an element link for each element type created.