DBA Data[Home] [Help]

APPS.IGF_AW_GEN_004 dependencies on IGS_CA_INST_ALL

Line 139: p_fa_cal_type igs_ca_inst_all.cal_type%TYPE,

135: ) RETURN NUMBER;
136:
137: FUNCTION get_base_id_for_person (
138: p_person_id igf_ap_fa_base_rec_all.person_id%TYPE,
139: p_fa_cal_type igs_ca_inst_all.cal_type%TYPE,
140: p_fa_sequence_number igs_ca_inst_all.sequence_number%TYPE
141: ) RETURN NUMBER ;
142:
143: -- bvisvana - bug 3724328 - For Code refactoring (Issue with huge person id groups)

Line 140: p_fa_sequence_number igs_ca_inst_all.sequence_number%TYPE

136:
137: FUNCTION get_base_id_for_person (
138: p_person_id igf_ap_fa_base_rec_all.person_id%TYPE,
139: p_fa_cal_type igs_ca_inst_all.cal_type%TYPE,
140: p_fa_sequence_number igs_ca_inst_all.sequence_number%TYPE
141: ) RETURN NUMBER ;
142:
143: -- bvisvana - bug 3724328 - For Code refactoring (Issue with huge person id groups)
144: TYPE person_id_array IS TABLE OF VARCHAR2(30);