APPS.IGS_HE_IMPORT_DATA dependencies on IGS_OR_ORG_ALT_IDS

Line 18: l_oss_inst igs_or_org_alt_ids.org_structure_id%TYPE ;

14: l_oss_subj3 igs_he_code_map_val.map2%TYPE ;
15: l_oss_proportion igs_he_code_map_val.map2%TYPE ;
16: l_oss_disability igs_he_code_map_val.map2%TYPE ;
17: l_oss_fee_elig igs_he_code_values.value%TYPE ;
18: l_oss_inst igs_or_org_alt_ids.org_structure_id%TYPE ;
19: l_oss_social_class igs_he_code_map_val.map2%TYPE ;
20: l_batch_id igs_he_ucas_imp_err.batch_id%TYPE ;
21: l_error_flag BOOLEAN ;
22:

Line 1236: CURSOR c_inst( cp_inst_code igs_or_org_alt_ids.org_alternate_id%TYPE ) IS

1232: AND gsg.grade= cp_high_qual
1233: AND ROWNUM < 2;
1234:
1235: -- get the oss inst code
1236: CURSOR c_inst( cp_inst_code igs_or_org_alt_ids.org_alternate_id%TYPE ) IS
1237: SELECT ORG_STRUCTURE_ID
1238: FROM IGS_OR_ORG_ALT_IDS OAI,IGS_OR_ORG_ALT_IDTYP_V OAIT
1239: WHERE OAI.ORG_alternate_ID = CP_INST_CODE
1240: AND OAI.ORG_STRUCTURE_TYPE = 'INSTITUTE'

Line 1238: FROM IGS_OR_ORG_ALT_IDS OAI,IGS_OR_ORG_ALT_IDTYP_V OAIT

1234:
1235: -- get the oss inst code
1236: CURSOR c_inst( cp_inst_code igs_or_org_alt_ids.org_alternate_id%TYPE ) IS
1237: SELECT ORG_STRUCTURE_ID
1238: FROM IGS_OR_ORG_ALT_IDS OAI,IGS_OR_ORG_ALT_IDTYP_V OAIT
1239: WHERE OAI.ORG_alternate_ID = CP_INST_CODE
1240: AND OAI.ORG_STRUCTURE_TYPE = 'INSTITUTE'
1241: AND TRUNC (SYSDATE) BETWEEN TRUNC (OAI.START_DATE) AND NVL (TRUNC (OAI.END_DATE), TRUNC (SYSDATE)+1)
1242: AND OAI.ORG_ALTERNATE_ID_TYPE = OAIT.ORG_ALTERNATE_ID_TYPE