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_ENTRIES_F

Line 1536: from pay_element_entries_f EE, pay_element_links_f EL

1532: p_element_type_id in number,
1533: p_commit_calculation_end_dt in date) is
1534: Select EE.element_entry_id, EE.creator_type,
1535: ee.effective_start_date, ee.effective_end_date
1536: from pay_element_entries_f EE, pay_element_links_f EL
1537: Where EL.element_type_id = p_element_type_id
1538: --AND p_commit_calculation_dt between EL.effective_start_date and EL.effective_end_date
1539: and EL.effective_start_date < p_commit_calculation_end_dt
1540: and EL.effective_end_date > p_commit_calculation_dt

Line 1591: l_entry_effective_end_date pay_element_entries_f.effective_end_date%type;

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;
1595: l_element_creator_type pay_element_entries_f.creator_type%type;

Line 1592: l_entry_effective_start_date pay_element_entries_f.effective_start_date%type;

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;
1595: l_element_creator_type pay_element_entries_f.creator_type%type;
1596: --

Line 1594: l_element_entry_id pay_element_entries_f.element_entry_id%type;

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;
1598: l_adjusted_end_dt pqh_element_commitments.commitment_end_date%type;

Line 1595: l_element_creator_type pay_element_entries_f.creator_type%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;
1598: l_adjusted_end_dt pqh_element_commitments.commitment_end_date%type;
1599: --

Line 1802: , pay_element_entries_f pee

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
1806: and pee.effective_start_date <= p_commit_calculation_end_dt