DBA Data[Home] [Help]

APPS.IGS_AD_UPD_INITIALISE dependencies on IGS_CA_TYPE

Line 510: igs_ca_type cat, -- calendar types table

506: SELECT count(*)
507: FROM
508: igs_ca_inst_rel car , -- calendar relations table
509: igs_ca_inst_all ca , -- calendar instances table
510: igs_ca_type cat, -- calendar types table
511: igs_ad_appl_all apl
512: WHERE
513: apl.person_id = p_person_id -- current person id
514: AND apl.admission_appl_number = p_admission_appl_number -- current adm appl number

Line 533: igs_ca_type cat -- calendar types table

529: ca.sequence_number load_cal_seq_num
530: FROM
531: igs_ca_inst_rel car , -- calendar relations table
532: igs_ca_inst_all ca , -- calendar instances table
533: igs_ca_type cat -- calendar types table
534: WHERE
535: ca.cal_type = car.sub_cal_type
536: AND ca.sequence_number = car.sub_ci_sequence_number
537: AND ca.cal_type = cat.cal_type