APPS.IGF_GR_REPACKAGE dependencies on IGS_CA_INST_ALL

Line 84: cp_cal_type igs_ca_inst_all.cal_type%TYPE,

80: l_person_number hz_parties.party_number%TYPE;
81:
82: -- Get alternate code
83: CURSOR c_alternate_code(
84: cp_cal_type igs_ca_inst_all.cal_type%TYPE,
85: cp_seq_number igs_ca_inst_all.sequence_number%TYPE
86: ) IS
87: SELECT alternate_code
88: FROM igs_ca_inst_all

Line 85: cp_seq_number igs_ca_inst_all.sequence_number%TYPE

81:
82: -- Get alternate code
83: CURSOR c_alternate_code(
84: cp_cal_type igs_ca_inst_all.cal_type%TYPE,
85: cp_seq_number igs_ca_inst_all.sequence_number%TYPE
86: ) IS
87: SELECT alternate_code
88: FROM igs_ca_inst_all
89: WHERE cal_type = cp_cal_type

Line 88: FROM igs_ca_inst_all

84: cp_cal_type igs_ca_inst_all.cal_type%TYPE,
85: cp_seq_number igs_ca_inst_all.sequence_number%TYPE
86: ) IS
87: SELECT alternate_code
88: FROM igs_ca_inst_all
89: WHERE cal_type = cp_cal_type
90: AND sequence_number = cp_seq_number;
91:
92: l_alternate_code igs_ca_inst_all.alternate_code%TYPE;

Line 92: l_alternate_code igs_ca_inst_all.alternate_code%TYPE;

88: FROM igs_ca_inst_all
89: WHERE cal_type = cp_cal_type
90: AND sequence_number = cp_seq_number;
91:
92: l_alternate_code igs_ca_inst_all.alternate_code%TYPE;
93:
94: -- Get get group description for group_id
95: CURSOR c_person_group(
96: cp_persid_grp igs_pe_persid_group_all.group_id%TYPE

Line 428: cp_cal_type igs_ca_inst_all.cal_type%TYPE,

424: l_log_message VARCHAR2(4000);
425:
426: -- Get alternate code
427: CURSOR c_alternate_code(
428: cp_cal_type igs_ca_inst_all.cal_type%TYPE,
429: cp_sequence_number igs_ca_inst_all.sequence_number%TYPE
430: ) IS
431: SELECT alternate_code
432: FROM igs_ca_inst_all

Line 429: cp_sequence_number igs_ca_inst_all.sequence_number%TYPE

425:
426: -- Get alternate code
427: CURSOR c_alternate_code(
428: cp_cal_type igs_ca_inst_all.cal_type%TYPE,
429: cp_sequence_number igs_ca_inst_all.sequence_number%TYPE
430: ) IS
431: SELECT alternate_code
432: FROM igs_ca_inst_all
433: WHERE cal_type = cp_cal_type

Line 432: FROM igs_ca_inst_all

428: cp_cal_type igs_ca_inst_all.cal_type%TYPE,
429: cp_sequence_number igs_ca_inst_all.sequence_number%TYPE
430: ) IS
431: SELECT alternate_code
432: FROM igs_ca_inst_all
433: WHERE cal_type = cp_cal_type
434: AND sequence_number = cp_sequence_number;
435: l_alternate_code c_alternate_code%ROWTYPE;
436: