APPS.IGF_AW_RULE dependencies on IGF_LOOKUPS_VIEW

Line 75: SELECT meaning, lookup_code FROM igf_lookups_view

71: WHERE cal_type = cp_ci_cal_type AND
72: sequence_NUMBER = cp_ci_sequence_NUMBER;
73:
74: CURSOR c_get_parameters IS
75: SELECT meaning, lookup_code FROM igf_lookups_view
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

Line 89: l_award_years igf_lookups_view.meaning%TYPE;

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;
90: l1_person_number igf_lookups_view.meaning%TYPE;
91: l_run_types igf_lookups_view.meaning%TYPE;
92: l_para_pass igf_lookups_view.meaning%TYPE;
93: l_alternate_code igs_ca_inst.alternate_code%TYPE;

Line 90: l1_person_number igf_lookups_view.meaning%TYPE;

86:
87:
88: parameter_rec c_get_parameters%ROWTYPE;
89: l_award_years igf_lookups_view.meaning%TYPE;
90: l1_person_number igf_lookups_view.meaning%TYPE;
91: l_run_types igf_lookups_view.meaning%TYPE;
92: l_para_pass igf_lookups_view.meaning%TYPE;
93: l_alternate_code igs_ca_inst.alternate_code%TYPE;
94:

Line 91: l_run_types igf_lookups_view.meaning%TYPE;

87:
88: parameter_rec c_get_parameters%ROWTYPE;
89: l_award_years igf_lookups_view.meaning%TYPE;
90: l1_person_number igf_lookups_view.meaning%TYPE;
91: l_run_types igf_lookups_view.meaning%TYPE;
92: l_para_pass igf_lookups_view.meaning%TYPE;
93: l_alternate_code igs_ca_inst.alternate_code%TYPE;
94:
95: BEGIN

Line 92: l_para_pass igf_lookups_view.meaning%TYPE;

88: parameter_rec c_get_parameters%ROWTYPE;
89: l_award_years igf_lookups_view.meaning%TYPE;
90: l1_person_number igf_lookups_view.meaning%TYPE;
91: l_run_types igf_lookups_view.meaning%TYPE;
92: l_para_pass igf_lookups_view.meaning%TYPE;
93: l_alternate_code igs_ca_inst.alternate_code%TYPE;
94:
95: BEGIN
96: