APPS.PQP_FEDHR_USPAY_INTG_PKG dependencies on GHR_GENERAL

Line 1963: WHERE ghr_general.return_number(pcv_information2) = p_ele_type_id

1959: object_version_number ovn,
1960: pcv_information1 ele_name,
1961: pcv_information3 pay_basis
1962: FROM pqp_configuration_values
1963: WHERE ghr_general.return_number(pcv_information2) = p_ele_type_id
1964: AND business_group_id = p_business_group_id
1965: AND pcv_information_category='PQP_FEDHR_ELEMENT';
1966:
1967: l_agn_conf_val_id NUMBER;

Line 2074: ghr_general.return_number(l_new_ele_type_id))

2070: l_eff_date := new_ele_rec.eff_date;
2071: END LOOP;
2072: --**********************************************************************
2073: FOR agency_ele_exists IN c_ele_type_id_exists_pcv(p_business_group_id,
2074: ghr_general.return_number(l_new_ele_type_id))
2075: LOOP
2076: l_agn_conf_val_id := agency_ele_exists.confg_val_id;
2077: l_agn_ovn := agency_ele_exists.ovn;
2078: -- using object version number

Line 2132: l_map_ele_type_id := ghr_general.return_NUMBER(pcv_ele_rec.ele_type_id);

2128: --
2129: FOR pcv_ele_rec IN c_ele_mapped
2130: LOOP
2131: l_map_old_ele := pcv_ele_rec.ele_name;
2132: l_map_ele_type_id := ghr_general.return_NUMBER(pcv_ele_rec.ele_type_id);
2133: l_pay_basis := pcv_ele_rec.pay_basis;
2134:
2135: IF NOT l_rows_exists THEN
2136:

Line 2218: l_map_ele_type_id := ghr_general.return_NUMBER(pcv_ele_rec.ele_type_id);

2214: l_map_ele_type_id := NULL;
2215: l_pay_basis := NULL;
2216: ELSE
2217: l_map_old_ele := pcv_ele_rec.ele_name;
2218: l_map_ele_type_id := ghr_general.return_NUMBER(pcv_ele_rec.ele_type_id);
2219: l_pay_basis := pcv_ele_rec.pay_basis;
2220: END IF;
2221:
2222: FOR pet_ele_rec IN c_new_ele_name_mapped(p_business_group_id,