DBA Data[Home] [Help]

APPS.PAY_IP_BAL_UPL_STRUCT dependencies on PAY_INPUT_VALUES

Line 285: l_input_val_id pay_input_values.input_value_id%TYPE;

281: l_bal_uom pay_balance_types.balance_uom%TYPE;
282: l_element_name pay_element_types.element_name%TYPE;
283: l_element_type_id pay_element_types.element_type_id%TYPE;
284: l_elem_link_id pay_element_links.element_link_id%TYPE;
285: l_input_val_id pay_input_values.input_value_id%TYPE;
286: l_bal_name pay_balance_types.balance_name%TYPE;
287: l_bal_type_id pay_balance_types.balance_type_id%TYPE;
288: l_bal_feed_id pay_balance_feeds.balance_feed_id%TYPE;
289: l_bg_name hr_organization_units.name%TYPE;

Line 310: pay_input_values_f IV,

306: p_business_group number)
307: is
308: select balance_feed_id
309: from pay_balance_feeds_f BF,
310: pay_input_values_f IV,
311: pay_element_types_f ET,
312: pay_element_classifications EC
313: where EC.classification_name = 'Balance Initialization'
314: and ET.classification_id = EC.classification_id