APPS.GHR_PROCESS_SF52 dependencies on GHR_FAMILIES

Line 541: ghr_families fam

537: Cursor cur_info_type IS
538: Select pit.information_type
539: from ghr_pa_request_info_types pit,
540: ghr_noa_families nfa,
541: ghr_families fam
542: where nfa.nature_of_action_id = p_noa_id
543: and nfa.noa_family_code = fam.noa_family_code
544: and fam.pa_info_type_flag = 'Y'
545: and pit.noa_family_code = fam.noa_family_code

Line 712: ghr_families ghrf,

708: CURSOR cur_flds(p_noa_id number) IS
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

Line 2445: ghr_families fams

2441: cursor c_fam (c_noa_id number) is
2442: select
2443: fams.noa_family_code
2444: from ghr_noa_families noafam,
2445: ghr_families fams
2446: where noafam.nature_of_action_id = c_noa_id and
2447: noafam.enabled_flag = 'Y' and
2448: fams.noa_family_code = noafam.noa_family_code and
2449: fams.enabled_flag = 'Y' and

Line 3544: ,ghr_families fam

3540: -- JH Get To Position Title PM for Noa Code being updated.
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

Line 4531: ghr_families ghrf,

4527: CURSOR cur_flds2( p_1st_noa_id number,
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

Line 4545: ghr_families ghrf2,

4541: AND fam.nature_of_action_id = p_1st_noa_id
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

Line 4560: ghr_families ghrf,

4556:
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

Line 4575: ghr_families ghrf,

4571:
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

Line 4591: ghr_families ghrf,

4587:
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