eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_COMMITMENT_PKG dependencies on PAY_ELEMENT_ENTRY_VALUES

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 1590: l_entry_value pay_element_entry_values.screen_entry_value%type;

1586: --
1587: -- DECLARE all local variables.
1588: --
1589: --
1590: l_entry_value pay_element_entry_values.screen_entry_value%type;
1591: l_entry_effective_end_date pay_element_entries_f.effective_end_date%type;
1592: l_entry_effective_start_date pay_element_entries_f.effective_start_date%type;
1593: l_element_frequency pay_element_entry_values.screen_entry_value%type;
1594: l_element_entry_id pay_element_entries_f.element_entry_id%type;

Line 1593: l_element_frequency pay_element_entry_values.screen_entry_value%type;

1589: --
1590: l_entry_value pay_element_entry_values.screen_entry_value%type;
1591: l_entry_effective_end_date pay_element_entries_f.effective_end_date%type;
1592: l_entry_effective_start_date pay_element_entries_f.effective_start_date%type;
1593: l_element_frequency pay_element_entry_values.screen_entry_value%type;
1594: l_element_entry_id pay_element_entries_f.element_entry_id%type;
1595: l_element_creator_type pay_element_entries_f.creator_type%type;
1596: --
1597: l_adjusted_start_dt pqh_element_commitments.commitment_start_date%type;

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