DBA Data[Home] [Help]

APPS.PQH_COMMITMENT_PKG dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 1556: from pay_element_entry_values_f

1552: p_input_value_id in number,
1553: p_element_entry_id in number,
1554: p_commit_calculation_end_dt in date) is
1555: Select screen_entry_value
1556: from pay_element_entry_values_f
1557: Where input_value_id = p_input_value_id
1558: AND element_entry_id = p_element_entry_id
1559: --AND p_commit_calculation_dt between effective_start_date and effective_end_date;
1560: and effective_start_date < p_commit_calculation_end_dt

Line 1801: from pay_element_entry_values_f pev

1797: p_commit_calculation_dt in date,
1798: p_commit_calculation_end_dt in date) is
1799: Select fnd_number.canonical_to_number(pev.screen_entry_value),
1800: pev.effective_start_date, pev.effective_end_date
1801: from pay_element_entry_values_f pev
1802: , pay_element_entries_f pee
1803: where pee.assignment_id = p_assignment_id
1804: -- and p_commit_calculation_dt
1805: -- between pee.effective_start_date and pee.effective_end_date