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: pay_accrual_plans_tl papt
149: where (pap.accrual_plan_id = nvl(p_plan_id, -1) OR
150: pap.accrual_category like p_category)

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: pay_accrual_plans_tl papt
149: where (pap.accrual_plan_id = nvl(p_plan_id, -1) OR
150: pap.accrual_category like p_category)
151: and pap.accrual_plan_id = papt.accrual_plan_id