APPS.IGS_HE_EXTRACT_PKG dependencies on IGS_HE_ST_UNT_VS_ALL

Line 1896: CURSOR c_get_exclude_flag(cp_unit_cd igs_he_st_unt_vs_all.unit_cd%TYPE,

1892: AND NVL(c.program_calc,'N') = 'N'
1893: AND a.field_number BETWEEN 85 AND 100
1894: AND NVL(a.override_value,a.value) IS NOT NULL ;
1895:
1896: CURSOR c_get_exclude_flag(cp_unit_cd igs_he_st_unt_vs_all.unit_cd%TYPE,
1897: cp_version_number igs_he_st_unt_vs_all.version_number%TYPE) IS
1898: SELECT NVL(exclude_flag, 'N') exclude_flag
1899: FROM igs_he_st_unt_vs_all
1900: WHERE unit_cd = cp_unit_cd

Line 1897: cp_version_number igs_he_st_unt_vs_all.version_number%TYPE) IS

1893: AND a.field_number BETWEEN 85 AND 100
1894: AND NVL(a.override_value,a.value) IS NOT NULL ;
1895:
1896: CURSOR c_get_exclude_flag(cp_unit_cd igs_he_st_unt_vs_all.unit_cd%TYPE,
1897: cp_version_number igs_he_st_unt_vs_all.version_number%TYPE) IS
1898: SELECT NVL(exclude_flag, 'N') exclude_flag
1899: FROM igs_he_st_unt_vs_all
1900: WHERE unit_cd = cp_unit_cd
1901: AND version_number = cp_version_number;

Line 1899: FROM igs_he_st_unt_vs_all

1895:
1896: CURSOR c_get_exclude_flag(cp_unit_cd igs_he_st_unt_vs_all.unit_cd%TYPE,
1897: cp_version_number igs_he_st_unt_vs_all.version_number%TYPE) IS
1898: SELECT NVL(exclude_flag, 'N') exclude_flag
1899: FROM igs_he_st_unt_vs_all
1900: WHERE unit_cd = cp_unit_cd
1901: AND version_number = cp_version_number;
1902:
1903: l_exclude igs_he_st_unt_vs_all.exclude_flag%TYPE;

Line 1903: l_exclude igs_he_st_unt_vs_all.exclude_flag%TYPE;

1899: FROM igs_he_st_unt_vs_all
1900: WHERE unit_cd = cp_unit_cd
1901: AND version_number = cp_version_number;
1902:
1903: l_exclude igs_he_st_unt_vs_all.exclude_flag%TYPE;
1904: l_he_ext_run_interim igs_he_ext_run_interim%ROWTYPE;
1905: l_rowid VARCHAR2(50);
1906: l_dot_position NUMBER;
1907: