DBA Data[Home] [Help]

APPS.IGS_AS_ADI_UPLD_PR_PKG dependencies on IGS_EN_SU_ATTEMPT

Line 887: igs_en_su_attempt sua

883: AND ci.start_dt < SYSDATE
884: --AND ci.end_dt = (SELECT MAX(ci.end_dt)
885: AND EXISTS ( SELECT 'X'
886: FROM igs_ca_inst_rel cir,
887: igs_en_su_attempt sua
888: WHERE cir.sup_cal_type = ci.cal_type
889: AND cir.sup_ci_sequence_number = ci.sequence_number
890: AND cir.sub_cal_type = sua.cal_type
891: AND cir.sub_ci_sequence_number = sua.ci_sequence_number

Line 923: igs_en_su_attempt sua

919: AND ci.start_dt < SYSDATE
920: --AND ci.end_dt = (SELECT MAX(ci.end_dt)
921: AND EXISTS ( SELECT 'X'
922: FROM igs_ca_inst_rel cir,
923: igs_en_su_attempt sua
924: WHERE cir.sup_cal_type = ci.cal_type
925: AND cir.sup_ci_sequence_number = ci.sequence_number
926: AND cir.sub_cal_type = sua.cal_type
927: AND cir.sub_ci_sequence_number = sua.ci_sequence_number

Line 949: igs_en_su_attempt sua

945: AND ci.start_dt < SYSDATE
946: --AND ci.end_dt = (SELECT MAX(ci.end_dt)
947: AND EXISTS ( SELECT 'X'
948: FROM igs_ca_inst_rel cir,
949: igs_en_su_attempt sua
950: WHERE cir.sup_cal_type = ci.cal_type
951: AND cir.sup_ci_sequence_number = ci.sequence_number
952: AND cir.sub_cal_type = sua.cal_type
953: AND cir.sub_ci_sequence_number = sua.ci_sequence_number