DBA Data[Home] [Help]

APPS.GHR_PA_REQUESTS_PKG dependencies on GHR_NOA_FAM_PROC_METHODS

Line 7: p_noa_family_code IN ghr_noa_fam_proc_methods.noa_family_code%TYPE

3:
4: -- For a particuar NOA Family this function returns the procesing method for a given
5: -- item in a form
6: PROCEDURE get_process_method(
7: p_noa_family_code IN ghr_noa_fam_proc_methods.noa_family_code%TYPE
8: ,p_form_block_name IN ghr_pa_data_fields.form_block_name%TYPE
9: ,p_form_field_name IN ghr_pa_data_fields.form_field_name%TYPE
10: ,p_effective_date IN DATE
11: ,p_process_method_code OUT NOCOPY VARCHAR2

Line 17: FROM ghr_noa_fam_proc_methods nfp

13:
14: CURSOR cur_nfp IS
15: SELECT nfp.process_method_code pm_code
16: ,nfp.navigable_flag
17: FROM ghr_noa_fam_proc_methods nfp
18: ,ghr_pa_data_fields pdf
19: WHERE pdf.pa_data_field_id = nfp.pa_data_field_id
20: AND pdf.form_block_name = p_form_block_name
21: AND pdf.form_field_name = p_form_field_name