DBA Data[Home] [Help]

APPS.PER_DIF_STMT_REPORT dependencies on PAY_INPUT_VALUES_F

Line 444: pay_input_values_f iv,

440: from pay_accrual_plans pap,
441: pay_net_calculation_rules ncr,
442: pay_element_entries_f pee,
443: pay_element_entry_values_f pev,
444: pay_input_values_f iv,
445: pay_element_types_f ele
446: where pap.accrual_plan_id = p_accrual_plan_id
447: and pee.assignment_id = c_assignment_id
448: and pee.element_entry_id = pev.element_entry_id

Line 463: pay_input_values_f piv2

459: and pee.element_type_id = iv.element_type_id
460: and exists
461: (select null
462: from pay_element_entry_values_f pev1,
463: pay_input_values_f piv2
464: where pev1.element_entry_id = pev.element_entry_id
465: and pev1.input_value_id = ncr.date_input_value_id
466: and pev1.effective_start_date = pev.effective_start_date
467: and pev1.effective_end_date = pev.effective_end_date