DBA Data[Home] [Help]

APPS.PAY_US_PTO_CO_PKG dependencies on PAY_INPUT_VALUES_F

Line 146: pay_input_values_f piv1,

142: pap.residual_date_input_value_id residual_date_input_value_id,
143: piv1.element_type_id co_element_type_id,
144: piv2.element_type_id residual_element_type_id
145: from pay_accrual_plans pap,
146: pay_input_values_f piv1,
147: pay_input_values_f piv2
148: where (pap.accrual_plan_id = nvl(p_plan_id, -1) OR
149: pap.accrual_category like p_category)
150: and pap.business_group_id = p_business_group_id

Line 147: pay_input_values_f piv2

143: piv1.element_type_id co_element_type_id,
144: piv2.element_type_id residual_element_type_id
145: from pay_accrual_plans pap,
146: pay_input_values_f piv1,
147: pay_input_values_f piv2
148: where (pap.accrual_plan_id = nvl(p_plan_id, -1) OR
149: pap.accrual_category like p_category)
150: and pap.business_group_id = p_business_group_id
151: and piv1.input_value_id = pap.CO_INPUT_VALUE_ID