[Home] [Help]
247: (select min(pa_history_id)
248: from ghr_pa_history
249: where pa_request_id =
250: (select min(pa_request_id)
251: from ghr_pa_requests
252: connect by pa_request_id = prior altered_pa_request_id
253: start with pa_request_id = (select pa_request_id
254: from ghr_pa_history
255: where pa_history_id = hist_1.pa_history_id))
276: min(nature_of_action_id)
277: from ghr_pa_history
278: where pa_request_id =
279: (select min(pa_request_id)
280: from ghr_pa_requests
281: connect by pa_request_id = prior altered_pa_request_id
282: start with pa_request_id = cp_pa_req_id)
283: and nature_of_action_id = cp_noa_id;
284:
423: -- This cursor finds the root pa_request_id
424: cursor c_get_root_req (cp_pa_request_id in number) is
425: select
426: min(pa_request_id)
427: from ghr_pa_requests
428: connect by pa_request_id = prior altered_pa_request_id
429: start with pa_request_id = cp_pa_request_id;
430:
431: --- Bug 6314442 start
439: and pa_history_id > p_save_history_id
440: and information1 = p_hist_data.information1
441: and table_name = p_hist_data.table_name
442: and pa_request_id in (select pa_request_id
443: from ghr_pa_requests
444: where pa_notification_id is not null
445: start with pa_request_id = p_hist_data.pa_request_id
446: connect by prior pa_request_id = altered_pa_request_id);
447:
590: (select min(pa_history_id)
591: from ghr_pa_history
592: where pa_request_id =
593: (select min(pa_request_id)
594: from ghr_pa_requests
595: connect by pa_request_id = prior altered_pa_request_id
596: start with pa_request_id = (select pa_request_id
597: from ghr_pa_history
598: where pa_history_id = hist_1.pa_history_id))
858: and pa_history_id <> nvl(cp_pa_history_id, 0)
859: and table_name = cp_table_name
860: and pa_request_id in
861: (select pa_request_id
862: from ghr_pa_requests
863: start with pa_request_id = cp_pa_request_id
864: connect by prior pa_request_id = altered_pa_request_id)
865: and nature_of_action_id + 0 = cp_noa_id
866: order by pa_history_id desc;
1957: l_proc varchar2(72) := 'fetch_element_info_cor';
1958: l_session ghr_history_api.g_session_var_type;
1959: l_element_entry_id pay_element_entries_f.element_entry_id%type;
1960: l_input_value_id pay_input_values_f.input_value_id%type;
1961: l_pa_request_id ghr_pa_requests.pa_request_id%type;
1962: l_processing_type pay_element_types_f.processing_type%type;
1963: l_element_type_id pay_element_types_f.element_type_id%type;
1964: l_element_entry_value_id pay_element_entry_values.element_entry_value_id%type;
1965: l_element_entry_data pay_element_entry_values_f%rowtype;
2005: and upper(ipv.name) = upper(input_name)
2006: and ele.nature_of_action_id = l_session.noa_id_correct
2007: and ele.pa_request_id in
2008: (select a.pa_request_id
2009: from ghr_pa_requests a
2010: connect by a.pa_request_id = prior a.altered_pa_request_id
2011: start with a.pa_request_id = l_session.altered_pa_request_id
2012: )
2013: -- and NVL(ipv.business_group_id,0)=NVL(eli.business_group_id,0)
2910: l_id_flex_num fnd_id_flex_structures.id_flex_num%type;
2911: l_analysis_criteria_id per_analysis_criteria.analysis_criteria_id%type;
2912: l_session ghr_history_api.g_session_var_type;
2913: l_person_analysis_id per_person_analyses.person_analysis_id%type;
2914: l_pa_request_id ghr_pa_requests.pa_request_id%type;
2915:
2916: Cursor c_flex_num is
2917: select flx.id_flex_num
2918: from fnd_id_flex_structures_tl flx
3088: select min(pa_history_id)
3089: from ghr_pa_history
3090: where pa_request_id =
3091: (select min(pa_request_id)
3092: from ghr_pa_requests
3093: connect by pa_request_id = prior altered_pa_request_id
3094: start with pa_request_id = cp_pa_req_id)
3095: and nature_of_action_id = cp_noa_id;
3096:
3155: select min(pa_history_id)
3156: from ghr_pa_history
3157: where pa_request_id =
3158: (select min(pa_request_id)
3159: from ghr_pa_requests
3160: connect by pa_request_id = prior altered_pa_request_id
3161: start with pa_request_id = cp_pa_req_id)
3162: and nature_of_action_id = cp_noa_id;
3163: