APPS.IGS_EN_ELGBL_PROGRAM dependencies on IGS_PS_OWN

Line 2333: FROM IGS_PS_OWN cow

2329: SELECT cow.course_cd,
2330: cow.version_number,
2331: cow.org_unit_cd,
2332: cow.ou_start_dt
2333: FROM IGS_PS_OWN cow
2334: WHERE cow.course_cd = cp_sca_course_cd AND
2335: cow.version_number = cp_sca_version_number AND
2336: ((cow.org_unit_cd = cp_uv_owner_org_unit_cd AND
2337: cow.ou_start_dt = cp_uv_owner_ou_start_dt) OR

Line 2376: l_cow_course_cd IGS_PS_OWN.course_cd%TYPE;

2372: l_sca_location_cd IGS_EN_STDNT_PS_ATT.location_cd%TYPE;
2373: l_sca_attendance_mode IGS_EN_STDNT_PS_ATT.attendance_mode%TYPE;
2374: l_sca_coo_id IGS_EN_STDNT_PS_ATT.coo_id%TYPE;
2375:
2376: l_cow_course_cd IGS_PS_OWN.course_cd%TYPE;
2377: l_cow_version_number IGS_PS_OWN.version_number%TYPE;
2378: l_cow_org_unit_cd IGS_PS_OWN.org_unit_cd%TYPE;
2379: v_cow_ou_start_dt IGS_PS_OWN.ou_start_dt%TYPE;
2380:

Line 2377: l_cow_version_number IGS_PS_OWN.version_number%TYPE;

2373: l_sca_attendance_mode IGS_EN_STDNT_PS_ATT.attendance_mode%TYPE;
2374: l_sca_coo_id IGS_EN_STDNT_PS_ATT.coo_id%TYPE;
2375:
2376: l_cow_course_cd IGS_PS_OWN.course_cd%TYPE;
2377: l_cow_version_number IGS_PS_OWN.version_number%TYPE;
2378: l_cow_org_unit_cd IGS_PS_OWN.org_unit_cd%TYPE;
2379: v_cow_ou_start_dt IGS_PS_OWN.ou_start_dt%TYPE;
2380:
2381: l_acad_cal_type IGS_CA_TYPE.CAL_TYPE%TYPE;

Line 2378: l_cow_org_unit_cd IGS_PS_OWN.org_unit_cd%TYPE;

2374: l_sca_coo_id IGS_EN_STDNT_PS_ATT.coo_id%TYPE;
2375:
2376: l_cow_course_cd IGS_PS_OWN.course_cd%TYPE;
2377: l_cow_version_number IGS_PS_OWN.version_number%TYPE;
2378: l_cow_org_unit_cd IGS_PS_OWN.org_unit_cd%TYPE;
2379: v_cow_ou_start_dt IGS_PS_OWN.ou_start_dt%TYPE;
2380:
2381: l_acad_cal_type IGS_CA_TYPE.CAL_TYPE%TYPE;
2382: l_acad_ci_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE;

Line 2379: v_cow_ou_start_dt IGS_PS_OWN.ou_start_dt%TYPE;

2375:
2376: l_cow_course_cd IGS_PS_OWN.course_cd%TYPE;
2377: l_cow_version_number IGS_PS_OWN.version_number%TYPE;
2378: l_cow_org_unit_cd IGS_PS_OWN.org_unit_cd%TYPE;
2379: v_cow_ou_start_dt IGS_PS_OWN.ou_start_dt%TYPE;
2380:
2381: l_acad_cal_type IGS_CA_TYPE.CAL_TYPE%TYPE;
2382: l_acad_ci_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE;
2383: l_acad_start_dt IGS_CA_INST.START_DT%TYPE;