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 632: ghr_noa_families nfa,

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

Line 807: ghr_noa_families fam

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
809: fam.noa_family_code = met.noa_family_code
810: AND ghrf.noa_family_code = met.noa_family_code
811: AND ghrf.update_hr_flag = 'Y'

Line 2554: from ghr_noa_families noafam,

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

Line 3673: from ghr_noa_families nof

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

Line 3740: from ghr_noa_families nof

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

Line 4782: ghr_noa_families fam

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
4784: fam.noa_family_code = met.noa_family_code
4785: AND ghrf.noa_family_code = met.noa_family_code
4786: AND ghrf.update_hr_flag = 'Y'

Line 4796: ghr_noa_families fam2

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
4798: fam2.noa_family_code = met2.noa_family_code
4799: AND ghrf2.noa_family_code = met2.noa_family_code
4800: AND ghrf2.update_hr_flag = 'Y'

Line 4811: ghr_noa_families fam

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
4813: fam.noa_family_code = met.noa_family_code
4814: AND ghrf.noa_family_code = met.noa_family_code
4815: AND ghrf.update_hr_flag = 'Y'

Line 4826: ghr_noa_families fam

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
4828: fam.noa_family_code = met.noa_family_code
4829: AND ghrf.noa_family_code = met.noa_family_code
4830: AND ghrf.update_hr_flag = 'Y'

Line 4842: ghr_noa_families fam

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
4844: fam.noa_family_code = met.noa_family_code
4845: AND ghrf.noa_family_code = met.noa_family_code
4846: AND ghrf.update_hr_flag = 'Y'