[Home] [Help]
538: 'GHR_US_PD_GEN_EMP')
539: and rei.information_type not in
540: (Select pit.information_type
541: from ghr_pa_request_info_types pit,
542: ghr_noa_families nfa,
543: ghr_families fam
544: where nfa.nature_of_action_id in (p_first_noa_id, p_second_noa_id)
545: and nfa.noa_family_code = fam.noa_family_code
546: and fam.pa_info_type_flag = 'Y'
719: l_per_refresh_flag varchar2(1);
720: l_asg_refresh_flag varchar2(1);
721: l_pos_refresh_flag varchar2(1);
722: -- Bug#4089400
723: l_noa_family_code ghr_noa_families.noa_family_code%type;
724: -- Bug#5039072 Added the following two parameters.
725: l_first_noa_code ghr_pa_requests.first_noa_code%type;
726: l_la_code1 ghr_pa_requests.first_action_la_code1%type;
727: l_la_code2 ghr_pa_requests.first_action_la_code2%type;
821: -- Bug#3941541 Added effective date condition to the cursor.
822: Cursor c_info_types(c_application_id fnd_application.application_id%type,c_resp_id fnd_responsibility.responsibility_id%type) is
823: Select pit.information_type
824: from ghr_pa_request_info_types pit,
825: ghr_noa_families nfa,
826: ghr_families fam
827: where nfa.nature_of_action_id = p_noa_id
828: and nfa.noa_family_code = fam.noa_family_code
829: and p_effective_date between NVL(nfa.start_date_active,p_effective_date)
4219: l_assignment_id per_assignments_f.assignment_id%type;
4220: l_per_refresh_flag varchar2(1);
4221: l_asg_refresh_flag varchar2(1);
4222: l_business_group_id per_assignments_f.business_group_id%type;
4223: l_noa_family_code ghr_noa_families.noa_family_code%type;
4224:
4225: l_proc varchar2(72) := g_package || 'fetch_generic_extra_info';
4226: l_information_type ghr_pa_request_extra_info.information_type%type;
4227: l_person_type per_person_types.system_person_type%type := hr_api.g_varchar2;
4771:
4772: Cursor c_info_type is
4773: Select pit.information_type
4774: from ghr_pa_request_info_types pit,
4775: ghr_noa_families nfa,
4776: ghr_families fam
4777: where nfa.nature_of_action_id = p_noa_id
4778: and nfa.noa_family_code = fam.noa_family_code
4779: and fam.pa_info_type_flag = 'Y'
5219: cursor get_ord_of_eit(p_information_type1 in varchar2,
5220: p_information_type2 in varchar2)
5221: is
5222: select a.noa_family_code, a.information_type
5223: from GHR_PA_REQUEST_INFO_TYPES a,ghr_noa_families b, ghr_nature_of_actions c
5224: where b.nature_of_action_id= c.nature_of_action_id
5225: and a.noa_family_code= b.noa_family_code
5226: and c.code in (p_first_noa_code,p_second_noa_code)
5227: and a.information_type in (p_information_type1,p_information_type2)