DBA Data[Home] [Help]

APPS.PAY_IP_RUN_BALANCE_UPGRADE dependencies on PAY_INPUT_VALUES_F

Line 64: pay_input_values_f piv

60: cursor c_primary_balance(cp_element_type_id in number) is
61: select distinct 'Y'
62: from pay_element_types_f pet,
63: pay_balance_types pbt,
64: pay_input_values_f piv
65: where pbt.input_value_id = piv.input_value_id
66: and piv.element_type_id = pet.element_type_id
67: and pbt.legislation_code is null
68: and pet.business_group_id = pbt.business_group_id

Line 114: pay_input_values_f piv,

110: pec.classification_name,
111: pet.effective_start_date,
112: pbt.business_group_id
113: from pay_element_types_f pet,
114: pay_input_values_f piv,
115: pay_balance_types pbt,
116: pay_element_classifications pec
117: where pet.element_type_id = cp_element_type_id
118: and pet.element_type_id = piv.element_type_id