[Home] [Help]
21: SELECT 'Request Number:'||par.request_number||
22: ', 1st NOA Code:'||par.first_noa_code||
23: DECODE(par.second_noa_code,NULL,NULL, ', 2nd NOA Code:'||par.second_noa_code)||
24: ------ ', Effective Date:'||TO_CHAR(par.effective_date,'DD-MON-YYYY')||
25: ', Effective Date:'||fnd_date.date_to_chardate(par.effective_date)||
26: DECODE(prh.action_taken,'FUTURE_ACTION', ', APPROVED',
27: ', Routed To '||DECODE(gbx.name,null, 'User:'||prh.user_name, 'Groupbox:'||gbx.name)) list_info
28: FROM ghr_groupboxes gbx
29: ,ghr_pa_routing_history prh
70: DECODE(par.first_noa_cancel_or_correct,'CANCEL','(CANCELED)')||
71: DECODE(par.second_noa_code,NULL,NULL, ', 2nd NOA Code:'||par.second_noa_code)||
72: DECODE(par.second_noa_cancel_or_correct,'CANCEL','(CANCELED)')||
73: --- ', Effective Date:'||TO_CHAR(par.effective_date,'DD-MON-YYYY') list_info
74: ', Effective Date:'||fnd_date.date_to_chardate(par.effective_date) list_info
75: FROM ghr_pa_routing_history prh
76: ,ghr_pa_requests par
77: WHERE par.person_id = p_person_id
78: AND par.effective_date >= p_effective_date
477: l_expire_date := l_pos_ei_data.POEI_INFORMATION3;
478: l_obligate_type := l_pos_ei_data.POEI_INFORMATION4;
479: if (l_expire_date IS NULL
480: -- OR to_date(l_expire_date,'DD-MON-YYYY') >= p_date )
481: OR fnd_date.canonical_to_date(l_expire_date) >= p_date )
482: and NVL(l_obligate_type,'U') <> 'U' then
483: l_chk_position_obligated :=true;
484: else
485: l_chk_position_obligated :=false;