DBA Data[Home] [Help]

APPS.GHR_NON_SF52_EXTRA_INFO dependencies on GHR_PA_REQUESTS_PKG

Line 1294: l_second_noa_family_code := ghr_pa_requests_pkg.get_noa_pm_family (l_second_noa_id,p_effective_date);

1290: l_person_id := pa_rec.person_id;
1291: l_second_noa_code := pa_rec.second_noa_code;
1292: --8793163
1293: l_second_noa_id := pa_rec.second_noa_id;
1294: l_second_noa_family_code := ghr_pa_requests_pkg.get_noa_pm_family (l_second_noa_id,p_effective_date);
1295: --8793163
1296: END LOOP;
1297:
1298: l_fehb_exists := FALSE;

Line 3434: l_second_noa_family_code := ghr_pa_requests_pkg.get_noa_pm_family (l_second_noa_id,p_effective_date);

3430: --Begin Bug# 14001082
3431: l_retirement_plan := pa_rec.retirement_plan;
3432: l_family_code := pa_rec.noa_family_code;
3433: l_second_noa_id := pa_rec.second_noa_id;
3434: l_second_noa_family_code := ghr_pa_requests_pkg.get_noa_pm_family (l_second_noa_id,p_effective_date);
3435: --End Bug# 14001082
3436: END LOOP;
3437:
3438: IF substr(l_first_noa_code,1,1) ='1' THEN

Line 3989: l_psi := ghr_pa_requests_pkg.get_personnel_system_indicator

3985: -- would not want to see the existing data.
3986: -- Bug#4089400 Added condition to skip the DLEI Processing for Correction Actions.
3987: IF l_information_type = 'GHR_US_PAR_SALARY_CHG' THEN
3988: IF NVL(l_noa_family_code,'C') <> 'CORRECT' THEN
3989: l_psi := ghr_pa_requests_pkg.get_personnel_system_indicator
3990: (p_position_id,
3991: p_effective_date);
3992:
3993: IF l_psi <> '00' THEN