APPS.GHR_NON_SF52_EXTRA_INFO dependencies on GHR_PA_REQUEST_INFO_TYPES

Line 494: from ghr_pa_request_info_types pit,

490: 'GHR_US_PAR_GEN_AGENCY_DATA',
491: 'GHR_US_PD_GEN_EMP')
492: and rei.information_type not in
493: (Select pit.information_type
494: from ghr_pa_request_info_types pit,
495: ghr_noa_families nfa,
496: ghr_families fam
497: where nfa.nature_of_action_id in (p_first_noa_id, p_second_noa_id)
498: and nfa.noa_family_code = fam.noa_family_code

Line 645: l_information_type ghr_pa_request_info_types.information_type%type;

641: l_pos_ei_data per_position_extra_info%rowtype;
642: l_multiple_error_flag boolean;
643: l_noa_id ghr_nature_of_actions.nature_of_action_id%type;
644: l_proc varchar2(72):= g_package || 'noa_spec_extra_info';
645: l_information_type ghr_pa_request_info_types.information_type%type;
646: l_update_rei varchar2(1) := 'N';
647: l_exists boolean := FALSE;
648: l_value varchar2(30);
649: l_rei_rec ghr_pa_request_extra_info%rowtype; -- as in the ddf and then subsequently overwrittwn with data to be updated

Line 762: from ghr_pa_request_info_types pit,

758:
759: -- Bug#3941541 Added effective date condition to the cursor.
760: Cursor c_info_types(c_application_id fnd_application.application_id%type,c_resp_id fnd_responsibility.responsibility_id%type) is
761: Select pit.information_type
762: from ghr_pa_request_info_types pit,
763: ghr_noa_families nfa,
764: ghr_families fam
765: where nfa.nature_of_action_id = p_noa_id
766: and nfa.noa_family_code = fam.noa_family_code

Line 4009: p_information_type out NOCOPY ghr_pa_request_info_types.information_type%type

4005:
4006: -- Get Information Type
4007: Procedure get_information_type
4008: (p_noa_id in ghr_nature_of_actions.nature_of_action_id%type,
4009: p_information_type out NOCOPY ghr_pa_request_info_types.information_type%type
4010: )
4011: is
4012:
4013: l_proc varchar2(72) := g_package || 'get_information_type';

Line 4017: from ghr_pa_request_info_types pit,

4013: l_proc varchar2(72) := g_package || 'get_information_type';
4014:
4015: Cursor c_info_type is
4016: Select pit.information_type
4017: from ghr_pa_request_info_types pit,
4018: ghr_noa_families nfa,
4019: ghr_families fam
4020: where nfa.nature_of_action_id = p_noa_id
4021: and nfa.noa_family_code = fam.noa_family_code

Line 4040: p_information_type in ghr_pa_request_info_types.information_type%type,

4036: End get_information_type;
4037:
4038: Procedure determine_operation
4039: (p_pa_request_id in ghr_pa_requests.pa_request_id%type,
4040: p_information_type in ghr_pa_request_info_types.information_type%type,
4041: p_update_rei in varchar2,
4042: p_rei_rec in ghr_pa_request_extra_info%rowtype,
4043: p_operation_flag out NOCOPY varchar2,
4044: p_pa_request_extra_info_id out NOCOPY ghr_pa_request_extra_info.pa_request_extra_info_id%type,