eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GHR_PROCESS_SF52 dependencies on GHR_DUAL_ACTIONS

Line 673: CURSOR get_dual_family( p_first_noa_id in ghr_dual_actions.first_noa_id%type,

669: CONNECT BY pa_request_id = prior altered_pa_request_id
670: START WITH pa_request_id = cp_pa_request_id)
671: AND ghrpah_1.nature_of_action_id = cp_noa_id;
672:
673: CURSOR get_dual_family( p_first_noa_id in ghr_dual_actions.first_noa_id%type,
674: p_second_noa_id in ghr_dual_actions.second_noa_id%type) IS
675: SELECT noa_family_code
676: FROM ghr_dual_actions
677: WHERE first_noa_id = p_first_noa_id

Line 674: p_second_noa_id in ghr_dual_actions.second_noa_id%type) IS

670: START WITH pa_request_id = cp_pa_request_id)
671: AND ghrpah_1.nature_of_action_id = cp_noa_id;
672:
673: CURSOR get_dual_family( p_first_noa_id in ghr_dual_actions.first_noa_id%type,
674: p_second_noa_id in ghr_dual_actions.second_noa_id%type) IS
675: SELECT noa_family_code
676: FROM ghr_dual_actions
677: WHERE first_noa_id = p_first_noa_id
678: AND second_noa_id = p_second_noa_id;

Line 676: FROM ghr_dual_actions

672:
673: CURSOR get_dual_family( p_first_noa_id in ghr_dual_actions.first_noa_id%type,
674: p_second_noa_id in ghr_dual_actions.second_noa_id%type) IS
675: SELECT noa_family_code
676: FROM ghr_dual_actions
677: WHERE first_noa_id = p_first_noa_id
678: AND second_noa_id = p_second_noa_id;
679: CURSOR get_dual_action( p_noa_family_code in ghr_dual_actions.noa_family_code%type,
680: p_form_field_name in ghr_dual_actions.noa_family_code%type) IS

Line 679: CURSOR get_dual_action( p_noa_family_code in ghr_dual_actions.noa_family_code%type,

675: SELECT noa_family_code
676: FROM ghr_dual_actions
677: WHERE first_noa_id = p_first_noa_id
678: AND second_noa_id = p_second_noa_id;
679: CURSOR get_dual_action( p_noa_family_code in ghr_dual_actions.noa_family_code%type,
680: p_form_field_name in ghr_dual_actions.noa_family_code%type) IS
681: SELECT *
682: FROM ghr_dual_proc_methods
683: WHERE LOWER(noa_family_code) = LOWER(p_noa_family_code)

Line 680: p_form_field_name in ghr_dual_actions.noa_family_code%type) IS

676: FROM ghr_dual_actions
677: WHERE first_noa_id = p_first_noa_id
678: AND second_noa_id = p_second_noa_id;
679: CURSOR get_dual_action( p_noa_family_code in ghr_dual_actions.noa_family_code%type,
680: p_form_field_name in ghr_dual_actions.noa_family_code%type) IS
681: SELECT *
682: FROM ghr_dual_proc_methods
683: WHERE LOWER(noa_family_code) = LOWER(p_noa_family_code)
684: AND LOWER(form_field_name) = LOWER(p_form_field_name);

Line 699: l_noa_family_code ghr_dual_actions.noa_family_code%type := null;

695: l_non_from_pa_req ghr_pa_requests%rowtype;
696: l_correction boolean:= null;
697: l_pa_req_ref ghr_pa_requests%rowtype;
698: l_pa_req_ref2 ghr_pa_requests%rowtype;
699: l_noa_family_code ghr_dual_actions.noa_family_code%type := null;
700: tmp_varchar varchar2(150);
701:
702: l_proc varchar2(30):='assign_new_rg';
703: