DBA Data[Home] [Help]

APPS.PAY_IN_BAL_UPL_STRUCT dependencies on PAY_INPUT_VALUES

Line 386: l_input_val_id pay_input_values.input_value_id%TYPE;

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;
389: l_bal_feed_id pay_balance_feeds.balance_feed_id%TYPE;
390: l_bg_name hr_organization_units.name%TYPE;

Line 418: pay_input_values_f IV,

414: p_business_group number)
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