APPS.GHR_PROCESS_SF52 dependencies on GHR_NOA_FAM_PROC_METHODS

Line 660: process_method_code ghr_noa_fam_proc_methods.process_method_code%TYPE

656: p_pa_req in out nocopy ghr_pa_requests%rowtype) IS
657:
658: TYPE fields_type is record
659: (form_field_name ghr_pa_data_fields.form_field_name%TYPE,
660: process_method_code ghr_noa_fam_proc_methods.process_method_code%TYPE
661: );
662: CURSOR get_root_pa_hist_id( cp_pa_request_id in number,
663: cp_noa_id in number) IS
664: SELECT min(pa_history_id)

Line 713: ghr_noa_fam_proc_methods met,

709: SELECT fld.form_field_name,
710: met.process_method_code
711: FROM
712: ghr_families ghrf,
713: ghr_noa_fam_proc_methods met,
714: ghr_pa_data_fields fld,
715: ghr_noa_families fam
716: WHERE
717: fam.noa_family_code = met.noa_family_code

Line 3545: ,ghr_noa_fam_proc_methods fpm

3541: Cursor get_to_posn_title_pm(p_noa_id in number) is
3542: select fpm.process_method_code
3543: from ghr_noa_families nof
3544: ,ghr_families fam
3545: ,ghr_noa_fam_proc_methods fpm
3546: ,ghr_pa_data_fields pdf
3547: where nof.nature_of_action_id = p_noa_id
3548: and nof.noa_family_code = fam.noa_family_code
3549: and nof.enabled_flag = 'Y'

Line 4532: ghr_noa_fam_proc_methods met,

4528: p_2nd_noa_id number) IS
4529: SELECT fld.form_field_name
4530: FROM
4531: ghr_families ghrf,
4532: ghr_noa_fam_proc_methods met,
4533: ghr_pa_data_fields fld,
4534: ghr_noa_families fam
4535: WHERE
4536: fam.noa_family_code = met.noa_family_code

Line 4546: ghr_noa_fam_proc_methods met2,

4542: UNION
4543: SELECT fld2.form_field_name
4544: FROM
4545: ghr_families ghrf2,
4546: ghr_noa_fam_proc_methods met2,
4547: ghr_pa_data_fields fld2,
4548: ghr_noa_families fam2
4549: WHERE
4550: fam2.noa_family_code = met2.noa_family_code

Line 4561: ghr_noa_fam_proc_methods met,

4557: CURSOR cur_flds1( p_1st_noa_id number) IS
4558: SELECT fld.form_field_name
4559: FROM
4560: ghr_families ghrf,
4561: ghr_noa_fam_proc_methods met,
4562: ghr_pa_data_fields fld,
4563: ghr_noa_families fam
4564: WHERE
4565: fam.noa_family_code = met.noa_family_code

Line 4576: ghr_noa_fam_proc_methods met,

4572: CURSOR cur_pos_title1( p_1st_noa_id number) IS
4573: SELECT fld.form_field_name
4574: FROM
4575: ghr_families ghrf,
4576: ghr_noa_fam_proc_methods met,
4577: ghr_pa_data_fields fld,
4578: ghr_noa_families fam
4579: WHERE
4580: fam.noa_family_code = met.noa_family_code

Line 4592: ghr_noa_fam_proc_methods met,

4588: CURSOR cur_pos_title2( p_1st_noa_id number, p_2nd_noa_id number ) IS
4589: SELECT fld.form_field_name
4590: FROM
4591: ghr_families ghrf,
4592: ghr_noa_fam_proc_methods met,
4593: ghr_pa_data_fields fld,
4594: ghr_noa_families fam
4595: WHERE
4596: fam.noa_family_code = met.noa_family_code