[Home] [Help]
248: (select min(pa_history_id)
249: from ghr_pa_history
250: where pa_request_id =
251: (select min(pa_request_id)
252: from ghr_pa_requests
253: connect by pa_request_id = prior altered_pa_request_id
254: start with pa_request_id = (select pa_request_id
255: from ghr_pa_history
256: where pa_history_id = hist_1.pa_history_id))
277: min(nature_of_action_id)
278: from ghr_pa_history
279: where pa_request_id =
280: (select min(pa_request_id)
281: from ghr_pa_requests
282: connect by pa_request_id = prior altered_pa_request_id
283: start with pa_request_id = cp_pa_req_id)
284: and nature_of_action_id = cp_noa_id;
285:
424: -- This cursor finds the root pa_request_id
425: cursor c_get_root_req (cp_pa_request_id in number) is
426: select
427: min(pa_request_id)
428: from ghr_pa_requests
429: connect by pa_request_id = prior altered_pa_request_id
430: start with pa_request_id = cp_pa_request_id;
431:
432: --- Bug 6314442 start
440: and pa_history_id > p_save_history_id
441: and information1 = p_hist_data.information1
442: and table_name = p_hist_data.table_name
443: and pa_request_id in (select pa_request_id
444: from ghr_pa_requests
445: where pa_notification_id is not null
446: start with pa_request_id = p_hist_data.pa_request_id
447: connect by prior pa_request_id = altered_pa_request_id);
448:
599: (select min(pa_history_id)
600: from ghr_pa_history
601: where pa_request_id =
602: (select min(pa_request_id)
603: from ghr_pa_requests
604: connect by pa_request_id = prior altered_pa_request_id
605: start with pa_request_id = (select pa_request_id
606: from ghr_pa_history
607: where pa_history_id = hist_1.pa_history_id))
867: and pa_history_id <> nvl(cp_pa_history_id, 0)
868: and table_name = cp_table_name
869: and pa_request_id in
870: (select pa_request_id
871: from ghr_pa_requests
872: start with pa_request_id = cp_pa_request_id
873: connect by prior pa_request_id = altered_pa_request_id)
874: and nature_of_action_id + 0 = cp_noa_id
875: order by pa_history_id desc;
2057: l_proc varchar2(72) := 'fetch_element_info_cor';
2058: l_session ghr_history_api.g_session_var_type;
2059: l_element_entry_id pay_element_entries_f.element_entry_id%type;
2060: l_input_value_id pay_input_values_f.input_value_id%type;
2061: l_pa_request_id ghr_pa_requests.pa_request_id%type;
2062: l_processing_type pay_element_types_f.processing_type%type;
2063: l_element_type_id pay_element_types_f.element_type_id%type;
2064: l_element_entry_value_id pay_element_entry_values.element_entry_value_id%type;
2065: l_element_entry_data pay_element_entry_values_f%rowtype;
2105: and upper(ipv.name) = upper(input_name)
2106: and ele.nature_of_action_id = l_session.noa_id_correct
2107: and ele.pa_request_id in
2108: (select a.pa_request_id
2109: from ghr_pa_requests a
2110: connect by a.pa_request_id = prior a.altered_pa_request_id
2111: start with a.pa_request_id = l_session.altered_pa_request_id
2112: )
2113: -- and NVL(ipv.business_group_id,0)=NVL(eli.business_group_id,0)
3010: l_id_flex_num fnd_id_flex_structures.id_flex_num%type;
3011: l_analysis_criteria_id per_analysis_criteria.analysis_criteria_id%type;
3012: l_session ghr_history_api.g_session_var_type;
3013: l_person_analysis_id per_person_analyses.person_analysis_id%type;
3014: l_pa_request_id ghr_pa_requests.pa_request_id%type;
3015:
3016: Cursor c_flex_num is
3017: select flx.id_flex_num
3018: from fnd_id_flex_structures_tl flx
3188: select min(pa_history_id)
3189: from ghr_pa_history
3190: where pa_request_id =
3191: (select min(pa_request_id)
3192: from ghr_pa_requests
3193: connect by pa_request_id = prior altered_pa_request_id
3194: start with pa_request_id = cp_pa_req_id)
3195: and nature_of_action_id = cp_noa_id;
3196:
3255: select min(pa_history_id)
3256: from ghr_pa_history
3257: where pa_request_id =
3258: (select min(pa_request_id)
3259: from ghr_pa_requests
3260: connect by pa_request_id = prior altered_pa_request_id
3261: start with pa_request_id = cp_pa_req_id)
3262: and nature_of_action_id = cp_noa_id;
3263: