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_FAM_PROC_METHODS

Line 752: process_method_code ghr_noa_fam_proc_methods.process_method_code%TYPE

748: p_pa_req in out nocopy ghr_pa_requests%rowtype) IS
749:
750: TYPE fields_type is record
751: (form_field_name ghr_pa_data_fields.form_field_name%TYPE,
752: process_method_code ghr_noa_fam_proc_methods.process_method_code%TYPE
753: );
754: CURSOR get_root_pa_hist_id( cp_pa_request_id in number,
755: cp_noa_id in number) IS
756: SELECT min(pa_history_id)

Line 805: ghr_noa_fam_proc_methods met,

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
809: fam.noa_family_code = met.noa_family_code

Line 3675: ,ghr_noa_fam_proc_methods fpm

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
3679: and nof.enabled_flag = 'Y'

Line 3742: ,ghr_noa_fam_proc_methods fpm

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
3746: and nof.enabled_flag = 'Y'

Line 4780: ghr_noa_fam_proc_methods met,

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
4784: fam.noa_family_code = met.noa_family_code

Line 4794: ghr_noa_fam_proc_methods met2,

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
4798: fam2.noa_family_code = met2.noa_family_code

Line 4809: ghr_noa_fam_proc_methods met,

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
4813: fam.noa_family_code = met.noa_family_code

Line 4824: ghr_noa_fam_proc_methods met,

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
4828: fam.noa_family_code = met.noa_family_code

Line 4840: ghr_noa_fam_proc_methods met,

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
4844: fam.noa_family_code = met.noa_family_code