APPS.IGS_AV_GEN_001 dependencies on IGS_PE_PERSON

Line 638: CURSOR c_asu (cp_person_id IGS_PE_PERSON.person_id%TYPE) IS

634: FROM IGS_GE_S_LOG
635: WHERE s_log_type = cp_s_log_type AND
636: creation_dt = cp_creation_dt;
637:
638: CURSOR c_asu (cp_person_id IGS_PE_PERSON.person_id%TYPE) IS
639: SELECT *
640: FROM IGS_AV_STND_UNIT
641: WHERE
642: s_adv_stnd_granting_status = cst_approved AND

Line 653: CURSOR c_asul (cp_person_id IGS_PE_PERSON.person_id%TYPE) IS

649: approved_dt desc,
650: granted_dt desc;
651: -- FOR UPDATE NOWAIT;
652:
653: CURSOR c_asul (cp_person_id IGS_PE_PERSON.person_id%TYPE) IS
654: SELECT *
655: FROM IGS_AV_STND_UNIT_LVL
656: WHERE
657: s_adv_stnd_granting_status = cst_approved AND

Line 1781: CURSOR c_adv_stnd_unit (cp_person_id IGS_PE_PERSON.person_id%TYPE) IS

1777: FROM IGS_AV_STND_UNIT_LVL_ALL
1778: WHERE s_adv_stnd_granting_status = 'APPROVED' AND
1779: NVL(expiry_dt, IGS_GE_DATE.IGSDATE('9999/01/01')) < SYSDATE;
1780:
1781: CURSOR c_adv_stnd_unit (cp_person_id IGS_PE_PERSON.person_id%TYPE) IS
1782: SELECT rowid , IGS_AV_STND_UNIT.*
1783: FROM igs_av_stnd_unit
1784: WHERE s_adv_stnd_granting_status = 'APPROVED' AND
1785: NVL(expiry_dt, IGS_GE_DATE.IGSDATE('9999/01/01')) < SYSDATE AND

Line 1794: CURSOR c_adv_stnd_unit_level (cp_person_id IGS_PE_PERSON.person_id%TYPE) IS

1790: as_course_cd,
1791: as_version_number
1792: FOR UPDATE OF s_adv_stnd_granting_status NOWAIT;
1793:
1794: CURSOR c_adv_stnd_unit_level (cp_person_id IGS_PE_PERSON.person_id%TYPE) IS
1795: SELECT rowid,IGS_AV_STND_UNIT_LVL.*
1796: FROM IGS_AV_STND_UNIT_LVL
1797: WHERE s_adv_stnd_granting_status = 'APPROVED' AND
1798: NVL(expiry_dt, IGS_GE_DATE.IGSDATE('9999/01/01')) < SYSDATE AND