DBA Data[Home] [Help]

APPS.IGS_ST_GEN_002 dependencies on IGS_PE_ABORG_TORESCD

Line 351: FROM IGS_PE_ABORG_TORESCD atc

347: v_birth_country_cd IGS_PE_STATISTICS.birth_country_cd%TYPE;
348: v_home_language_cd IGS_PE_STATISTICS.home_language_cd%TYPE;
349: CURSOR c_atc IS
350: SELECT atc.govt_aborig_torres_cd
351: FROM IGS_PE_ABORG_TORESCD atc
352: WHERE atc.aborig_torres_cd = v_aborig_torres_cd;
353: CURSOR c_cic IS
354: SELECT cic.govt_citizenship_cd
355: FROM IGS_ST_CITIZENSHP_CD cic

Line 574: FROM IGS_PE_ABORG_TORESCD atcd

570: ps.end_dt >= p_effective_dt)
571: ORDER BY ps.end_dt ASC;
572: CURSOR c_aborig_tsi IS
573: SELECT atcd.govt_aborig_torres_cd
574: FROM IGS_PE_ABORG_TORESCD atcd
575: WHERE atcd.aborig_torres_cd = v_aborig_torres_cd;
576: CURSOR c_citz IS
577: SELECT ccd.govt_citizenship_cd
578: FROM IGS_ST_CITIZENSHP_CD ccd