eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GHR_PROCESS_SF52 dependencies on GHR_NOA_FAMILIES

Line 540: ghr_noa_families nfa,

536: l_proc varchar2(72) := 'get_information_type';
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'

Line 715: ghr_noa_families fam

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
718: AND ghrf.noa_family_code = met.noa_family_code
719: AND ghrf.update_hr_flag = 'Y'

Line 2444: from ghr_noa_families noafam,

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

Line 3543: from ghr_noa_families nof

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

Line 4534: ghr_noa_families fam

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
4537: AND ghrf.noa_family_code = met.noa_family_code
4538: AND ghrf.update_hr_flag = 'Y'

Line 4548: ghr_noa_families fam2

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
4551: AND ghrf2.noa_family_code = met2.noa_family_code
4552: AND ghrf2.update_hr_flag = 'Y'

Line 4563: ghr_noa_families fam

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
4566: AND ghrf.noa_family_code = met.noa_family_code
4567: AND ghrf.update_hr_flag = 'Y'

Line 4578: ghr_noa_families fam

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
4581: AND ghrf.noa_family_code = met.noa_family_code
4582: AND ghrf.update_hr_flag = 'Y'

Line 4594: ghr_noa_families fam

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
4597: AND ghrf.noa_family_code = met.noa_family_code
4598: AND ghrf.update_hr_flag = 'Y'