DBA Data[Home] [Help]

APPS.GHR_NON_SF52_EXTRA_INFO dependencies on FND_APPLICATION

Line 669: l_application_id fnd_application.application_id%type;

665: -- Bug#5039072 Added the following two parameters.
666: l_first_noa_code ghr_pa_requests.first_noa_code%type;
667: l_la_code1 ghr_pa_requests.first_action_la_code1%type;
668: l_payment_option ghr_pa_requests.pa_incentive_payment_option%type;
669: l_application_id fnd_application.application_id%type;
670: l_resp_id fnd_responsibility.responsibility_id%type;
671:
672: -- Begin Bug#4126188
673: l_from_position_id ghr_pa_requests.from_position_id%type;

Line 760: Cursor c_info_types(c_application_id fnd_application.application_id%type,c_resp_id fnd_responsibility.responsibility_id%type) is

756: from ghr_pa_request_ei_shadow
757: where pa_request_extra_info_id = l_rei_rec.pa_request_extra_info_id;
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