DBA Data[Home] [Help]

APPS.PAY_CN_BAL_UPL_STRUCT dependencies on PAY_INPUT_VALUES

Line 466: l_input_val_id pay_input_values.input_value_id%TYPE;

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

Line 500: pay_input_values_f IV,

496: p_business_group NUMBER)
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