[Home] [Help]
1293: Cursor get_to_posn_title_pm is
1294: select fpm.process_method_code
1295: from ghr_noa_families nof
1296: ,ghr_families fam
1297: ,ghr_noa_fam_proc_methods fpm
1298: ,ghr_pa_data_fields pdf
1299: where nof.nature_of_action_id = p_pa_request_rec.first_noa_id
1300: and nof.noa_family_code = fam.noa_family_code
1301: and nof.enabled_flag = 'Y'
3313: Cursor get_to_posn_title_pm is
3314: select fpm.process_method_code
3315: from ghr_noa_families nof
3316: ,ghr_families fam
3317: ,ghr_noa_fam_proc_methods fpm
3318: ,ghr_pa_data_fields pdf
3319: where nof.nature_of_action_id = p_pa_request_rec.first_noa_id
3320: and nof.noa_family_code = fam.noa_family_code
3321: and nof.enabled_flag = 'Y'