APPS.IGS_AD_IMP_026 dependencies on IGS_LOOKUP_VALUES

Line 98: CURSOR visa_issue_match_cur(cp_lookup_type igs_lookup_values.lookup_type%TYPE,

94: FROM igs_pe_passport p
95: WHERE p.person_id = visa_rec.person_id AND
96: p.passport_id = visa_rec.passport_id;
97:
98: CURSOR visa_issue_match_cur(cp_lookup_type igs_lookup_values.lookup_type%TYPE,
99: cp_enabled_flag igs_lookup_values.enabled_flag%TYPE,
100: cp_visa_issuing_post igs_lookup_values.lookup_code%TYPE,
101: cp_visa_issuing_country igs_lookup_values.tag%TYPE) IS
102: SELECT 'X'

Line 99: cp_enabled_flag igs_lookup_values.enabled_flag%TYPE,

95: WHERE p.person_id = visa_rec.person_id AND
96: p.passport_id = visa_rec.passport_id;
97:
98: CURSOR visa_issue_match_cur(cp_lookup_type igs_lookup_values.lookup_type%TYPE,
99: cp_enabled_flag igs_lookup_values.enabled_flag%TYPE,
100: cp_visa_issuing_post igs_lookup_values.lookup_code%TYPE,
101: cp_visa_issuing_country igs_lookup_values.tag%TYPE) IS
102: SELECT 'X'
103: FROM igs_lookup_values

Line 100: cp_visa_issuing_post igs_lookup_values.lookup_code%TYPE,

96: p.passport_id = visa_rec.passport_id;
97:
98: CURSOR visa_issue_match_cur(cp_lookup_type igs_lookup_values.lookup_type%TYPE,
99: cp_enabled_flag igs_lookup_values.enabled_flag%TYPE,
100: cp_visa_issuing_post igs_lookup_values.lookup_code%TYPE,
101: cp_visa_issuing_country igs_lookup_values.tag%TYPE) IS
102: SELECT 'X'
103: FROM igs_lookup_values
104: WHERE lookup_type = cp_lookup_type AND

Line 101: cp_visa_issuing_country igs_lookup_values.tag%TYPE) IS

97:
98: CURSOR visa_issue_match_cur(cp_lookup_type igs_lookup_values.lookup_type%TYPE,
99: cp_enabled_flag igs_lookup_values.enabled_flag%TYPE,
100: cp_visa_issuing_post igs_lookup_values.lookup_code%TYPE,
101: cp_visa_issuing_country igs_lookup_values.tag%TYPE) IS
102: SELECT 'X'
103: FROM igs_lookup_values
104: WHERE lookup_type = cp_lookup_type AND
105: lookup_code = cp_visa_issuing_post AND

Line 103: FROM igs_lookup_values

99: cp_enabled_flag igs_lookup_values.enabled_flag%TYPE,
100: cp_visa_issuing_post igs_lookup_values.lookup_code%TYPE,
101: cp_visa_issuing_country igs_lookup_values.tag%TYPE) IS
102: SELECT 'X'
103: FROM igs_lookup_values
104: WHERE lookup_type = cp_lookup_type AND
105: lookup_code = cp_visa_issuing_post AND
106: tag = cp_visa_issuing_country AND
107: enabled_flag = cp_enabled_flag;