APPS.IGS_PE_VISAPASS_PUB dependencies on IGS_PE_PASSPORT

Line 66: passport_id igs_pe_passport.passport_id%TYPE,

62: remarks igs_pe_visit_histry.remarks%TYPE
63: );
64:
65: TYPE passport_rec_type IS RECORD(
66: passport_id igs_pe_passport.passport_id%TYPE,
67: person_id igs_pe_passport.person_id%TYPE,
68: passport_number igs_pe_passport.passport_number%TYPE,
69: passport_expiry_date igs_pe_passport.passport_expiry_date%TYPE,
70: passport_cntry_code igs_pe_passport.passport_cntry_code%TYPE

Line 67: person_id igs_pe_passport.person_id%TYPE,

63: );
64:
65: TYPE passport_rec_type IS RECORD(
66: passport_id igs_pe_passport.passport_id%TYPE,
67: person_id igs_pe_passport.person_id%TYPE,
68: passport_number igs_pe_passport.passport_number%TYPE,
69: passport_expiry_date igs_pe_passport.passport_expiry_date%TYPE,
70: passport_cntry_code igs_pe_passport.passport_cntry_code%TYPE
71: );

Line 68: passport_number igs_pe_passport.passport_number%TYPE,

64:
65: TYPE passport_rec_type IS RECORD(
66: passport_id igs_pe_passport.passport_id%TYPE,
67: person_id igs_pe_passport.person_id%TYPE,
68: passport_number igs_pe_passport.passport_number%TYPE,
69: passport_expiry_date igs_pe_passport.passport_expiry_date%TYPE,
70: passport_cntry_code igs_pe_passport.passport_cntry_code%TYPE
71: );
72:

Line 69: passport_expiry_date igs_pe_passport.passport_expiry_date%TYPE,

65: TYPE passport_rec_type IS RECORD(
66: passport_id igs_pe_passport.passport_id%TYPE,
67: person_id igs_pe_passport.person_id%TYPE,
68: passport_number igs_pe_passport.passport_number%TYPE,
69: passport_expiry_date igs_pe_passport.passport_expiry_date%TYPE,
70: passport_cntry_code igs_pe_passport.passport_cntry_code%TYPE
71: );
72:
73:

Line 70: passport_cntry_code igs_pe_passport.passport_cntry_code%TYPE

66: passport_id igs_pe_passport.passport_id%TYPE,
67: person_id igs_pe_passport.person_id%TYPE,
68: passport_number igs_pe_passport.passport_number%TYPE,
69: passport_expiry_date igs_pe_passport.passport_expiry_date%TYPE,
70: passport_cntry_code igs_pe_passport.passport_cntry_code%TYPE
71: );
72:
73:
74: -- Start of comments