APPS.IGS_AD_TI_COMP dependencies on IGS_AD_DOC_STAT

Line 702: igs_ad_doc_stat ads,

698: apai.sequence_number
699: FROM
700: igs_ad_ps_appl_inst apai,
701: igs_ad_ou_stat aos,
702: igs_ad_doc_stat ads,
703: igs_ad_appl aa
704: WHERE
705: apai.person_id = nvl(p_person_id,apai.person_id) AND
706: aa.acad_cal_type = nvl(p_acad_cal_type,aa.acad_cal_type) AND

Line 863: igs_ad_doc_stat ads ,

859: apai.sequence_number
860: FROM
861: igs_ad_ps_appl_inst apai,
862: igs_ad_ou_stat aos,
863: igs_ad_doc_stat ads ,
864: igs_ad_appl aa
865: WHERE
866: apai.person_id IN ( '||lv_sql_stmt||') AND
867: aos.s_adm_outcome_status = ''PENDING'' AND

Line 908: igs_ad_doc_stat ads ,

904: apai.sequence_number
905: FROM
906: igs_ad_ps_appl_inst apai,
907: igs_ad_ou_stat aos,
908: igs_ad_doc_stat ads ,
909: igs_ad_appl aa
910: WHERE
911: apai.person_id IN ( '||lv_sql_stmt||') AND
912: aos.s_adm_outcome_status = ''PENDING'' AND