APPS.GHR_SS_VIEWS_PKG dependencies on GHR_PA_REQUESTS

Line 137: from ghr_pa_requests par1

133:
134:
135: cursor c_notification_id is
136: select max(par1.pa_notification_id) notification_id
137: from ghr_pa_requests par1
138: where par1.person_id = p_person_id
139: and par1.pa_notification_id is NOT Null
140: and par1.noa_family_code NOT in ('CORRECT', 'CANCEL')
141: and nvl(par1.first_noa_cancel_or_correct, 'normal') <> 'CANCEL'

Line 143: from ghr_pa_requests par2

139: and par1.pa_notification_id is NOT Null
140: and par1.noa_family_code NOT in ('CORRECT', 'CANCEL')
141: and nvl(par1.first_noa_cancel_or_correct, 'normal') <> 'CANCEL'
142: and par1.effective_date = ( select max(par2.effective_date) maxdate
143: from ghr_pa_requests par2
144: where par2.person_id = p_person_id
145: and par2.pa_notification_id is NOT Null
146: and par2.effective_date <= p_effective_date
147: and par2.noa_family_code NOT in ('CORRECT', 'CANCEL')

Line 153: from ghr_pa_requests g

149:
150:
151: cursor c_request_id (c_notification_id number) is
152: select pa_request_id
153: from ghr_pa_requests g
154: where g.pa_notification_id = c_notification_id ;
155:
156: l_notification_id ghr_pa_requests.pa_notification_id%type;
157: l_pa_request_id ghr_pa_requests.pa_request_id%type;

Line 156: l_notification_id ghr_pa_requests.pa_notification_id%type;

152: select pa_request_id
153: from ghr_pa_requests g
154: where g.pa_notification_id = c_notification_id ;
155:
156: l_notification_id ghr_pa_requests.pa_notification_id%type;
157: l_pa_request_id ghr_pa_requests.pa_request_id%type;
158: l_proc varchar2(72);
159:
160:

Line 157: l_pa_request_id ghr_pa_requests.pa_request_id%type;

153: from ghr_pa_requests g
154: where g.pa_notification_id = c_notification_id ;
155:
156: l_notification_id ghr_pa_requests.pa_notification_id%type;
157: l_pa_request_id ghr_pa_requests.pa_request_id%type;
158: l_proc varchar2(72);
159:
160:
161: BEGIN