DBA Data[Home] [Help]

APPS.PER_PYP_BUS dependencies on HR_ALL_POSITIONS_F

Line 1610: l_pyp_working_hours hr_all_positions_f.working_hours%TYPE;

1606: l_org_working_hours NUMBER;
1607: l_org_working_hours_frequency per_organization_units.frequency%TYPE;
1608: l_bus_working_hours NUMBER;
1609: l_bus_working_hours_frequency per_business_groups.frequency%TYPE;
1610: l_pyp_working_hours hr_all_positions_f.working_hours%TYPE;
1611: l_pyp_working_hours_frequency hr_all_positions_f.frequency%TYPE;
1612: l_minimum NUMBER;
1613: l_maximum NUMBER;
1614: l_ele_w_or_e pay_input_values_f.warning_or_error%TYPE;

Line 1611: l_pyp_working_hours_frequency hr_all_positions_f.frequency%TYPE;

1607: l_org_working_hours_frequency per_organization_units.frequency%TYPE;
1608: l_bus_working_hours NUMBER;
1609: l_bus_working_hours_frequency per_business_groups.frequency%TYPE;
1610: l_pyp_working_hours hr_all_positions_f.working_hours%TYPE;
1611: l_pyp_working_hours_frequency hr_all_positions_f.frequency%TYPE;
1612: l_minimum NUMBER;
1613: l_maximum NUMBER;
1614: l_ele_w_or_e pay_input_values_f.warning_or_error%TYPE;
1615: l_ele_min_value pay_input_values_f.min_value%TYPE;

Line 1700: from hr_all_positions_f pos

1696: --
1697: Cursor csr_get_pos_min_max_values is
1698: select pos.working_hours,
1699: pos.frequency
1700: from hr_all_positions_f pos
1701: where p_position_id = pos.position_id
1702: and p_change_date
1703: BETWEEN pos.effective_start_date AND pos.effective_end_date;
1704: --