APPS.PQH_LENGTH_OF_SERVICE_PKG dependencies on PQH_DE_WRKPLC_VLDTN_VERS

Line 1826: FROM hr_all_positions_f pos, pqh_de_wrkplc_vldtn_vers wkvr

1822: AND effective_end_date >= p_assg_start_date;
1823:
1824: CURSOR c_tariff_contract(p_position_id per_all_assignments_f.position_id%type) IS
1825: SELECT wkvr.tariff_contract_code
1826: FROM hr_all_positions_f pos, pqh_de_wrkplc_vldtn_vers wkvr
1827: WHERE pos.position_id = p_position_id
1828: AND pos.information1='WP'
1829: AND to_char(wkvr.wrkplc_vldtn_ver_id) = decode(pos.information6,'A',pos.information5,pos.information9)
1830: AND p_assg_end_date between pos.effective_start_date and pos.effective_end_date

Line 1842: l_tariff_contract_code pqh_de_wrkplc_vldtn_vers.tariff_contract_code%TYPE;

1838: AND information_type = 'DE_PQH_ASSG_LOS_INFO';
1839:
1840: l_employee_category per_all_assignments_f.employee_category%TYPE;
1841: l_position_id per_all_assignments_f.position_id%TYPE;
1842: l_tariff_contract_code pqh_de_wrkplc_vldtn_vers.tariff_contract_code%TYPE;
1843: l_date_of_birth DATE;
1844: l_dob_21 DATE;
1845: l_dob_31 DATE;
1846: l_dob_35 DATE;