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_APPROVED_PA_REQUESTS dependencies on GHR_NATURE_OF_ACTIONS

Line 546: from ghr_nature_of_actions

542: where rowid = chartorowid(p_row_id);
543: --
544: cursor C_noa_id(p_noa_code varchar2, p_effective_date date) is
545: select nature_of_action_id, description
546: from ghr_nature_of_actions
547: where code = p_noa_code
548: and p_effective_date between date_from and nvl(date_to, p_effective_date);
549: --
550: cursor c_noa_code (p_noa_id number)is

Line 552: from ghr_nature_of_actions where nature_of_action_id = p_noa_id;

548: and p_effective_date between date_from and nvl(date_to, p_effective_date);
549: --
550: cursor c_noa_code (p_noa_id number)is
551: select code
552: from ghr_nature_of_actions where nature_of_action_id = p_noa_id;
553: --
554: -- Added this cursor for bug # 2951865 to check if the person is persent in the system !!
555: CURSOR chk_person ( p_person_id NUMBER ) IS
556: SELECT person_id

Line 1074: from ghr_nature_of_actions

1070: where pa_request_id = p_par_id;
1071: --
1072: cursor C_noa_id(p_noa_code varchar2, p_effective_date date) is
1073: select nature_of_action_id, description
1074: from ghr_nature_of_actions
1075: where code = p_noa_code
1076: and p_effective_date between date_from and nvl(date_to, p_effective_date);
1077: --
1078: cursor c_noa_code (p_noa_id number)is

Line 1080: from ghr_nature_of_actions where nature_of_action_id = p_noa_id;

1076: and p_effective_date between date_from and nvl(date_to, p_effective_date);
1077: --
1078: cursor c_noa_code (p_noa_id number)is
1079: select code
1080: from ghr_nature_of_actions where nature_of_action_id = p_noa_id;
1081: --
1082: -- Bug#3941541 Added parameter p_effective_date.
1083: cursor c_noa_fam_code(p_noa_code varchar2,p_effective_date date) is
1084: select noa_family_code from ghr_noa_families

Line 1086: ( select nature_of_action_id from ghr_nature_of_actions

1082: -- Bug#3941541 Added parameter p_effective_date.
1083: cursor c_noa_fam_code(p_noa_code varchar2,p_effective_date date) is
1084: select noa_family_code from ghr_noa_families
1085: where nature_of_action_id in
1086: ( select nature_of_action_id from ghr_nature_of_actions
1087: where code = p_noa_code )
1088: and noa_family_code in
1089: ( select noa_family_code from ghr_families
1090: where update_hr_flag = 'Y')

Line 1111: l_retro_first_noa ghr_nature_of_actions.code%type;

1107: l_to_step_or_rate ghr_pa_requests.to_step_or_rate%type;
1108: l_pa_notification_id ghr_pa_requests.pa_notification_id%type;
1109: l_noa_family_code ghr_pa_requests.noa_family_code%type;
1110: l_retro_noa_family_code ghr_pa_requests.noa_family_code%type;
1111: l_retro_first_noa ghr_nature_of_actions.code%type;
1112: l_retro_second_noa ghr_nature_of_actions.code%type;
1113: l_ia_flag varchar2(30);
1114: --bug 5172710
1115: l_to_total_salary ghr_pa_requests.to_total_salary%type;

Line 1112: l_retro_second_noa ghr_nature_of_actions.code%type;

1108: l_pa_notification_id ghr_pa_requests.pa_notification_id%type;
1109: l_noa_family_code ghr_pa_requests.noa_family_code%type;
1110: l_retro_noa_family_code ghr_pa_requests.noa_family_code%type;
1111: l_retro_first_noa ghr_nature_of_actions.code%type;
1112: l_retro_second_noa ghr_nature_of_actions.code%type;
1113: l_ia_flag varchar2(30);
1114: --bug 5172710
1115: l_to_total_salary ghr_pa_requests.to_total_salary%type;
1116: -- Bug 2681842 and 3191676 Added variables for To Position Org lines

Line 1810: l_retro_first_noa ghr_nature_of_actions.code%type;

1806: ;
1807:
1808: l_proc varchar2(61) := g_package_name || 'chk_intervene_seq';
1809: l_effective_date ghr_pa_requests.effective_date%type;
1810: l_retro_first_noa ghr_nature_of_actions.code%type;
1811: l_retro_second_noa ghr_nature_of_actions.code%type;
1812: l_retro_pa_request_id ghr_pa_requests.pa_request_id%type;
1813: BEGIN
1814: hr_utility.set_location('Entering '|| l_proc, 5);

Line 1811: l_retro_second_noa ghr_nature_of_actions.code%type;

1807:
1808: l_proc varchar2(61) := g_package_name || 'chk_intervene_seq';
1809: l_effective_date ghr_pa_requests.effective_date%type;
1810: l_retro_first_noa ghr_nature_of_actions.code%type;
1811: l_retro_second_noa ghr_nature_of_actions.code%type;
1812: l_retro_pa_request_id ghr_pa_requests.pa_request_id%type;
1813: BEGIN
1814: hr_utility.set_location('Entering '|| l_proc, 5);
1815: -- Determine Intervening Action

Line 1883: from ghr_nature_of_actions

1879: -- action found
1880: cursor chk_ord_of_proc(p_ia_noac in varchar2)
1881: is
1882: select 1
1883: from ghr_nature_of_actions
1884: where nature_of_action_id = p_noa_id_correct
1885: and order_of_processing < (select order_of_processing
1886: from ghr_nature_of_actions
1887: where code = p_ia_noac

Line 1886: from ghr_nature_of_actions

1882: select 1
1883: from ghr_nature_of_actions
1884: where nature_of_action_id = p_noa_id_correct
1885: and order_of_processing < (select order_of_processing
1886: from ghr_nature_of_actions
1887: where code = p_ia_noac
1888: and p_effective_date between nvl(date_from,p_effective_date)
1889: and nvl(date_to,p_effective_date)
1890: );