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.IGF_AW_RULE dependencies on IGS_PE_PERSID_GROUP_ALL

Line 80: CURSOR get_grp_desc(lp_per_id igs_pe_persid_group_all.group_id%TYPE) IS

76: WHERE lookup_type='IGF_GE_PARAMETERS' AND
77: lookup_code IN ('AWARD_YEAR','PERSON_ID_GROUP','PARAMETER_PASS');
78:
79: --get person group description
80: CURSOR get_grp_desc(lp_per_id igs_pe_persid_group_all.group_id%TYPE) IS
81: SELECT description
82: FROM igs_pe_persid_group_all
83: WHERE group_id = lp_per_id;
84:

Line 82: FROM igs_pe_persid_group_all

78:
79: --get person group description
80: CURSOR get_grp_desc(lp_per_id igs_pe_persid_group_all.group_id%TYPE) IS
81: SELECT description
82: FROM igs_pe_persid_group_all
83: WHERE group_id = lp_per_id;
84:
85: lv_desc igs_pe_persid_group_all.description%TYPE;
86:

Line 85: lv_desc igs_pe_persid_group_all.description%TYPE;

81: SELECT description
82: FROM igs_pe_persid_group_all
83: WHERE group_id = lp_per_id;
84:
85: lv_desc igs_pe_persid_group_all.description%TYPE;
86:
87:
88: parameter_rec c_get_parameters%ROWTYPE;
89: l_award_years igf_lookups_view.meaning%TYPE;

Line 260: CURSOR get_grp_desc(lp_per_id igs_pe_persid_group_all.group_id%TYPE) IS

256: ln_person_id igs_ad_ps_appl_inst.person_id%TYPE;
257: l_person_NUMBER igf_ap_fa_con_v.person_NUMBER%TYPE;
258:
259: -- Get
260: CURSOR get_grp_desc(lp_per_id igs_pe_persid_group_all.group_id%TYPE) IS
261: SELECT description
262: FROM igs_pe_persid_group_all
263: WHERE group_id = lp_per_id;
264: lv_desc igs_pe_persid_group_all.description%TYPE;

Line 262: FROM igs_pe_persid_group_all

258:
259: -- Get
260: CURSOR get_grp_desc(lp_per_id igs_pe_persid_group_all.group_id%TYPE) IS
261: SELECT description
262: FROM igs_pe_persid_group_all
263: WHERE group_id = lp_per_id;
264: lv_desc igs_pe_persid_group_all.description%TYPE;
265:
266: -- Get

Line 264: lv_desc igs_pe_persid_group_all.description%TYPE;

260: CURSOR get_grp_desc(lp_per_id igs_pe_persid_group_all.group_id%TYPE) IS
261: SELECT description
262: FROM igs_pe_persid_group_all
263: WHERE group_id = lp_per_id;
264: lv_desc igs_pe_persid_group_all.description%TYPE;
265:
266: -- Get
267: CURSOR c_get_base_id(lp_ci_cal_type igf_ap_fa_base_rec.ci_cal_type%TYPE, lp_ci_seq_num igf_ap_fa_base_rec.ci_sequence_number%TYPE, lp_person_id igf_ap_fa_base_rec.person_id%TYPE) IS
268: SELECT fa.base_id