APPS.IGF_AP_CALC_IM_EFC dependencies on IGS_CA_INST_ALL

Line 60: cp_cal_type igs_ca_inst_all.cal_type%TYPE,

56: l_pers_id_grp_log igf_lookups_view.meaning%TYPE DEFAULT igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PERSON_ID_GROUP');
57:
58: -- Get alternate code
59: CURSOR c_alternate_code(
60: cp_cal_type igs_ca_inst_all.cal_type%TYPE,
61: cp_seq_number igs_ca_inst_all.sequence_number%TYPE
62: ) IS
63: SELECT alternate_code
64: FROM igs_ca_inst_all

Line 61: cp_seq_number igs_ca_inst_all.sequence_number%TYPE

57:
58: -- Get alternate code
59: CURSOR c_alternate_code(
60: cp_cal_type igs_ca_inst_all.cal_type%TYPE,
61: cp_seq_number igs_ca_inst_all.sequence_number%TYPE
62: ) IS
63: SELECT alternate_code
64: FROM igs_ca_inst_all
65: WHERE cal_type = cp_cal_type

Line 64: FROM igs_ca_inst_all

60: cp_cal_type igs_ca_inst_all.cal_type%TYPE,
61: cp_seq_number igs_ca_inst_all.sequence_number%TYPE
62: ) IS
63: SELECT alternate_code
64: FROM igs_ca_inst_all
65: WHERE cal_type = cp_cal_type
66: AND sequence_number = cp_seq_number;
67:
68: l_alternate_code igs_ca_inst_all.alternate_code%TYPE;

Line 68: l_alternate_code igs_ca_inst_all.alternate_code%TYPE;

64: FROM igs_ca_inst_all
65: WHERE cal_type = cp_cal_type
66: AND sequence_number = cp_seq_number;
67:
68: l_alternate_code igs_ca_inst_all.alternate_code%TYPE;
69:
70: -- Get get group description for group_id
71: CURSOR c_person_group(
72: cp_persid_grp igs_pe_persid_group_all.group_id%TYPE