DBA Data[Home] [Help]

APPS.GHR_PA_REQUESTS_PKG dependencies on GHR_RESTRICTED_PROC_METHODS

Line 65: p_restricted_form IN ghr_restricted_proc_methods.restricted_form%TYPE

61: --
62: END get_data_field_name;
63: --
64: PROCEDURE get_restricted_process_method(
65: p_restricted_form IN ghr_restricted_proc_methods.restricted_form%TYPE
66: ,p_form_block_name IN ghr_pa_data_fields.form_block_name%TYPE
67: ,p_form_field_name IN ghr_pa_data_fields.form_field_name%TYPE
68: ,p_restricted_proc_method OUT NOCOPY VARCHAR2) IS
69:

Line 75: ,ghr_restricted_proc_methods rpm

71: -- relevant to the 'effective date' on the SF52 we will do the restricted form as of todays date
72: CURSOR cur_rpm IS
73: SELECT rpm.restricted_proc_method
74: FROM ghr_pa_data_fields pdf
75: ,ghr_restricted_proc_methods rpm
76: WHERE pdf.pa_data_field_id = rpm.pa_data_field_id
77: AND rpm.restricted_form = p_restricted_form
78: AND pdf.form_block_name = p_form_block_name
79: AND pdf.form_field_name = p_form_field_name