DBA Data[Home] [Help]

APPS.GHR_NON_SF52_EXTRA_INFO dependencies on FND_RESPONSIBILITY

Line 732: l_resp_id fnd_responsibility.responsibility_id%type;

728: l_sec_la_code1 ghr_pa_requests.second_action_la_code1%type;
729: l_sec_la_code2 ghr_pa_requests.second_action_la_code2%type;
730: l_payment_option ghr_pa_requests.pa_incentive_payment_option%type;
731: l_application_id fnd_application.application_id%type;
732: l_resp_id fnd_responsibility.responsibility_id%type;
733:
734: -- Begin Bug#4126188
735: l_from_position_id ghr_pa_requests.from_position_id%type;
736: l_to_position_id ghr_pa_requests.to_position_id%type;

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

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