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.PER_PYP_BUS dependencies on HR_ALL_POSITIONS_F

Line 1720: l_pyp_working_hours hr_all_positions_f.working_hours%TYPE;

1716: l_org_working_hours NUMBER;
1717: l_org_working_hours_frequency per_organization_units.frequency%TYPE;
1718: l_bus_working_hours NUMBER;
1719: l_bus_working_hours_frequency per_business_groups.frequency%TYPE;
1720: l_pyp_working_hours hr_all_positions_f.working_hours%TYPE;
1721: l_pyp_working_hours_frequency hr_all_positions_f.frequency%TYPE;
1722: l_minimum NUMBER;
1723: l_maximum NUMBER;
1724: l_ele_w_or_e pay_input_values_f.warning_or_error%TYPE;

Line 1721: l_pyp_working_hours_frequency hr_all_positions_f.frequency%TYPE;

1717: l_org_working_hours_frequency per_organization_units.frequency%TYPE;
1718: l_bus_working_hours NUMBER;
1719: l_bus_working_hours_frequency per_business_groups.frequency%TYPE;
1720: l_pyp_working_hours hr_all_positions_f.working_hours%TYPE;
1721: l_pyp_working_hours_frequency hr_all_positions_f.frequency%TYPE;
1722: l_minimum NUMBER;
1723: l_maximum NUMBER;
1724: l_ele_w_or_e pay_input_values_f.warning_or_error%TYPE;
1725: l_ele_min_value pay_input_values_f.min_value%TYPE;

Line 1811: from hr_all_positions_f pos

1807: --
1808: Cursor csr_get_pos_min_max_values is
1809: select pos.working_hours,
1810: pos.frequency
1811: from hr_all_positions_f pos
1812: where p_position_id = pos.position_id
1813: and p_change_date
1814: BETWEEN pos.effective_start_date AND pos.effective_end_date;
1815: --