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 566: from ghr_nature_of_actions

562: where rowid = chartorowid(p_row_id);
563: --
564: cursor C_noa_id(p_noa_code varchar2, p_effective_date date) is
565: select nature_of_action_id, description
566: from ghr_nature_of_actions
567: where code = p_noa_code
568: and p_effective_date between date_from and nvl(date_to, p_effective_date);
569: --
570: cursor c_noa_code (p_noa_id number)is

Line 572: from ghr_nature_of_actions where nature_of_action_id = p_noa_id;

568: and p_effective_date between date_from and nvl(date_to, p_effective_date);
569: --
570: cursor c_noa_code (p_noa_id number)is
571: select code
572: from ghr_nature_of_actions where nature_of_action_id = p_noa_id;
573: --
574: -- Added this cursor for bug # 2951865 to check if the person is persent in the system !!
575: CURSOR chk_person ( p_person_id NUMBER ) IS
576: SELECT person_id

Line 1130: from ghr_nature_of_actions

1126: where pa_request_id = p_par_id;
1127: --
1128: cursor C_noa_id(p_noa_code varchar2, p_effective_date date) is
1129: select nature_of_action_id, description
1130: from ghr_nature_of_actions
1131: where code = p_noa_code
1132: and p_effective_date between date_from and nvl(date_to, p_effective_date);
1133: --
1134: cursor c_noa_code (p_noa_id number)is

Line 1136: from ghr_nature_of_actions where nature_of_action_id = p_noa_id;

1132: and p_effective_date between date_from and nvl(date_to, p_effective_date);
1133: --
1134: cursor c_noa_code (p_noa_id number)is
1135: select code
1136: from ghr_nature_of_actions where nature_of_action_id = p_noa_id;
1137: --
1138: -- Bug#3941541 Added parameter p_effective_date.
1139: cursor c_noa_fam_code(p_noa_code varchar2,p_effective_date date) is
1140: select noa_family_code from ghr_noa_families

Line 1142: ( select nature_of_action_id from ghr_nature_of_actions

1138: -- Bug#3941541 Added parameter p_effective_date.
1139: cursor c_noa_fam_code(p_noa_code varchar2,p_effective_date date) is
1140: select noa_family_code from ghr_noa_families
1141: where nature_of_action_id in
1142: ( select nature_of_action_id from ghr_nature_of_actions
1143: where code = p_noa_code )
1144: and noa_family_code in
1145: ( select noa_family_code from ghr_families
1146: where update_hr_flag = 'Y')

Line 1167: l_retro_first_noa ghr_nature_of_actions.code%type;

1163: l_to_step_or_rate ghr_pa_requests.to_step_or_rate%type;
1164: l_pa_notification_id ghr_pa_requests.pa_notification_id%type;
1165: l_noa_family_code ghr_pa_requests.noa_family_code%type;
1166: l_retro_noa_family_code ghr_pa_requests.noa_family_code%type;
1167: l_retro_first_noa ghr_nature_of_actions.code%type;
1168: l_retro_second_noa ghr_nature_of_actions.code%type;
1169: l_ia_flag varchar2(30);
1170: --bug 5172710
1171: l_to_total_salary ghr_pa_requests.to_total_salary%type;

Line 1168: l_retro_second_noa ghr_nature_of_actions.code%type;

1164: l_pa_notification_id ghr_pa_requests.pa_notification_id%type;
1165: l_noa_family_code ghr_pa_requests.noa_family_code%type;
1166: l_retro_noa_family_code ghr_pa_requests.noa_family_code%type;
1167: l_retro_first_noa ghr_nature_of_actions.code%type;
1168: l_retro_second_noa ghr_nature_of_actions.code%type;
1169: l_ia_flag varchar2(30);
1170: --bug 5172710
1171: l_to_total_salary ghr_pa_requests.to_total_salary%type;
1172: -- Bug 2681842 and 3191676 Added variables for To Position Org lines

Line 1900: l_retro_first_noa ghr_nature_of_actions.code%type;

1896: ;
1897:
1898: l_proc varchar2(61) := g_package_name || 'chk_intervene_seq';
1899: l_effective_date ghr_pa_requests.effective_date%type;
1900: l_retro_first_noa ghr_nature_of_actions.code%type;
1901: l_retro_second_noa ghr_nature_of_actions.code%type;
1902: l_retro_pa_request_id ghr_pa_requests.pa_request_id%type;
1903: BEGIN
1904: hr_utility.set_location('Entering '|| l_proc, 5);

Line 1901: l_retro_second_noa ghr_nature_of_actions.code%type;

1897:
1898: l_proc varchar2(61) := g_package_name || 'chk_intervene_seq';
1899: l_effective_date ghr_pa_requests.effective_date%type;
1900: l_retro_first_noa ghr_nature_of_actions.code%type;
1901: l_retro_second_noa ghr_nature_of_actions.code%type;
1902: l_retro_pa_request_id ghr_pa_requests.pa_request_id%type;
1903: BEGIN
1904: hr_utility.set_location('Entering '|| l_proc, 5);
1905: -- Determine Intervening Action

Line 1975: from ghr_nature_of_actions

1971: -- action found
1972: cursor chk_ord_of_proc(p_ia_noac in varchar2)
1973: is
1974: select 1
1975: from ghr_nature_of_actions
1976: where nature_of_action_id = p_noa_id_correct
1977: and order_of_processing < (select order_of_processing
1978: from ghr_nature_of_actions
1979: where code = p_ia_noac

Line 1978: from ghr_nature_of_actions

1974: select 1
1975: from ghr_nature_of_actions
1976: where nature_of_action_id = p_noa_id_correct
1977: and order_of_processing < (select order_of_processing
1978: from ghr_nature_of_actions
1979: where code = p_ia_noac
1980: and p_effective_date between nvl(date_from,p_effective_date)
1981: and nvl(date_to,p_effective_date)
1982: );