APPS.GHR_PROCESS_SF52 dependencies on GHR_FAMILIES

Line 633: ghr_families fam

629: Cursor cur_info_type IS
630: Select pit.information_type
631: from ghr_pa_request_info_types pit,
632: ghr_noa_families nfa,
633: ghr_families fam
634: where nfa.nature_of_action_id = p_noa_id
635: and nfa.noa_family_code = fam.noa_family_code
636: and fam.pa_info_type_flag = 'Y'
637: and pit.noa_family_code = fam.noa_family_code

Line 804: ghr_families ghrf,

800: CURSOR cur_flds(p_noa_id number) IS
801: SELECT fld.form_field_name,
802: met.process_method_code
803: FROM
804: ghr_families ghrf,
805: ghr_noa_fam_proc_methods met,
806: ghr_pa_data_fields fld,
807: ghr_noa_families fam
808: WHERE

Line 2555: ghr_families fams

2551: cursor c_fam (c_noa_id number) is
2552: select
2553: fams.noa_family_code
2554: from ghr_noa_families noafam,
2555: ghr_families fams
2556: where noafam.nature_of_action_id = c_noa_id and
2557: noafam.enabled_flag = 'Y' and
2558: fams.noa_family_code = noafam.noa_family_code and
2559: fams.enabled_flag = 'Y' and

Line 3674: ,ghr_families fam

3670: -- JH Get To Position Title PM for Noa Code being updated.
3671: Cursor get_to_posn_title_pm(p_noa_id in number) is
3672: select fpm.process_method_code
3673: from ghr_noa_families nof
3674: ,ghr_families fam
3675: ,ghr_noa_fam_proc_methods fpm
3676: ,ghr_pa_data_fields pdf
3677: where nof.nature_of_action_id = p_noa_id
3678: and nof.noa_family_code = fam.noa_family_code

Line 3741: ,ghr_families fam

3737: --Begin Bug# 14047036, 13587903
3738: Cursor get_prd_pm(p_noa_id in number) is
3739: select fpm.process_method_code
3740: from ghr_noa_families nof
3741: ,ghr_families fam
3742: ,ghr_noa_fam_proc_methods fpm
3743: ,ghr_pa_data_fields pdf
3744: where nof.nature_of_action_id = p_noa_id
3745: and nof.noa_family_code = fam.noa_family_code

Line 4779: ghr_families ghrf,

4775: CURSOR cur_flds2( p_1st_noa_id number,
4776: p_2nd_noa_id number) IS
4777: SELECT fld.form_field_name
4778: FROM
4779: ghr_families ghrf,
4780: ghr_noa_fam_proc_methods met,
4781: ghr_pa_data_fields fld,
4782: ghr_noa_families fam
4783: WHERE

Line 4793: ghr_families ghrf2,

4789: AND fam.nature_of_action_id = p_1st_noa_id
4790: UNION
4791: SELECT fld2.form_field_name
4792: FROM
4793: ghr_families ghrf2,
4794: ghr_noa_fam_proc_methods met2,
4795: ghr_pa_data_fields fld2,
4796: ghr_noa_families fam2
4797: WHERE

Line 4808: ghr_families ghrf,

4804:
4805: CURSOR cur_flds1( p_1st_noa_id number) IS
4806: SELECT fld.form_field_name
4807: FROM
4808: ghr_families ghrf,
4809: ghr_noa_fam_proc_methods met,
4810: ghr_pa_data_fields fld,
4811: ghr_noa_families fam
4812: WHERE

Line 4823: ghr_families ghrf,

4819:
4820: CURSOR cur_pos_title1( p_1st_noa_id number) IS
4821: SELECT fld.form_field_name
4822: FROM
4823: ghr_families ghrf,
4824: ghr_noa_fam_proc_methods met,
4825: ghr_pa_data_fields fld,
4826: ghr_noa_families fam
4827: WHERE

Line 4839: ghr_families ghrf,

4835:
4836: CURSOR cur_pos_title2( p_1st_noa_id number, p_2nd_noa_id number ) IS
4837: SELECT fld.form_field_name
4838: FROM
4839: ghr_families ghrf,
4840: ghr_noa_fam_proc_methods met,
4841: ghr_pa_data_fields fld,
4842: ghr_noa_families fam
4843: WHERE