APPS.GHR_NON_SF52_EXTRA_INFO dependencies on GHR_PA_REQUEST_INFO_TYPES

Line 541: from ghr_pa_request_info_types pit,

537: 'GHR_US_PAR_GEN_AGENCY_DATA',
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

Line 704: l_information_type ghr_pa_request_info_types.information_type%type;

700: l_pos_ei_data per_position_extra_info%rowtype;
701: l_multiple_error_flag boolean;
702: l_noa_id ghr_nature_of_actions.nature_of_action_id%type;
703: l_proc varchar2(72):= g_package || 'noa_spec_extra_info';
704: l_information_type ghr_pa_request_info_types.information_type%type;
705: l_update_rei varchar2(1) := 'N';
706: l_exists boolean := FALSE;
707: l_value varchar2(30);
708: l_rei_rec ghr_pa_request_extra_info%rowtype; -- as in the ddf and then subsequently overwrittwn with data to be updated

Line 824: from ghr_pa_request_info_types pit,

820:
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

Line 4766: p_information_type out NOCOPY ghr_pa_request_info_types.information_type%type

4762:
4763: -- Get Information Type
4764: Procedure get_information_type
4765: (p_noa_id in ghr_nature_of_actions.nature_of_action_id%type,
4766: p_information_type out NOCOPY ghr_pa_request_info_types.information_type%type
4767: )
4768: is
4769:
4770: l_proc varchar2(72) := g_package || 'get_information_type';

Line 4774: from ghr_pa_request_info_types pit,

4770: l_proc varchar2(72) := g_package || 'get_information_type';
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

Line 4797: p_information_type in ghr_pa_request_info_types.information_type%type,

4793: End get_information_type;
4794:
4795: Procedure determine_operation
4796: (p_pa_request_id in ghr_pa_requests.pa_request_id%type,
4797: p_information_type in ghr_pa_request_info_types.information_type%type,
4798: p_update_rei in varchar2,
4799: p_rei_rec in ghr_pa_request_extra_info%rowtype,
4800: p_operation_flag out NOCOPY varchar2,
4801: p_pa_request_extra_info_id out NOCOPY ghr_pa_request_extra_info.pa_request_extra_info_id%type,

Line 5223: from GHR_PA_REQUEST_INFO_TYPES a,ghr_noa_families b, ghr_nature_of_actions c

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)