APPS.GHR_CPDF_CHECK6 dependencies on GHR_PROCESS_SF52

Line 18: if ghr_process_sf52.g_dual_prior_ws is not null then

14: l_prior_work_schedule ghr_pa_requests.work_schedule%type;
15: begin
16: -- 8267598 added code for global variable comparison for dual actions.
17: l_prior_work_schedule := p_prior_work_schedule;
18: if ghr_process_sf52.g_dual_prior_ws is not null then
19: l_prior_work_schedule := ghr_process_sf52.g_dual_prior_ws;
20: end if;
21:
22: -- 590.02.2

Line 19: l_prior_work_schedule := ghr_process_sf52.g_dual_prior_ws;

15: begin
16: -- 8267598 added code for global variable comparison for dual actions.
17: l_prior_work_schedule := p_prior_work_schedule;
18: if ghr_process_sf52.g_dual_prior_ws is not null then
19: l_prior_work_schedule := ghr_process_sf52.g_dual_prior_ws;
20: end if;
21:
22: -- 590.02.2
23: if p_first_noac_lookup_code = '781' and

Line 1497: if NVL(ghr_process_sf52.g_dual_action_yn,'N') = 'N' then

1493: -- 770.02.2
1494: -- 28-Nov-2002 Madhuri removed NOA Code 430
1495: -- Modified for dual actions
1496:
1497: if NVL(ghr_process_sf52.g_dual_action_yn,'N') = 'N' then
1498: if (p_first_noac_lookup_code ='280') and
1499: -- or p_first_noac_lookup_code ='430')
1500: (NVL(p_work_schedule_code,'G') not in ('G','Q','J','T')) then
1501: hr_utility.set_message(8301, 'GHR_37662_ALL_PROCEDURE_FAIL');

Line 1505: elsif NVL(ghr_process_sf52.g_dual_action_yn,'N') = 'Y' then

1501: hr_utility.set_message(8301, 'GHR_37662_ALL_PROCEDURE_FAIL');
1502: hr_utility.raise_error;
1503: end if;
1504: --8294224 Modified to consider the prior work schedule also for dual correction
1505: elsif NVL(ghr_process_sf52.g_dual_action_yn,'N') = 'Y' then
1506: if (p_first_noac_lookup_code ='280') and
1507: -- or p_first_noac_lookup_code ='430')
1508: (NVL(p_work_schedule_code,'G') not in ('G','Q','J','T')) and
1509: (NVL(ghr_process_sf52.g_dual_prior_ws,'G') not in ('G','Q','J','T')) then

Line 1509: (NVL(ghr_process_sf52.g_dual_prior_ws,'G') not in ('G','Q','J','T')) then

1505: elsif NVL(ghr_process_sf52.g_dual_action_yn,'N') = 'Y' then
1506: if (p_first_noac_lookup_code ='280') and
1507: -- or p_first_noac_lookup_code ='430')
1508: (NVL(p_work_schedule_code,'G') not in ('G','Q','J','T')) and
1509: (NVL(ghr_process_sf52.g_dual_prior_ws,'G') not in ('G','Q','J','T')) then
1510: hr_utility.set_message(8301, 'GHR_37662_ALL_PROCEDURE_FAIL');
1511: hr_utility.raise_error;
1512: end if;
1513: end if;