DBA Data[Home] [Help]

APPS.IGF_AW_GEN dependencies on IGF_AW_DP_TERMS

Line 1761: FROM igf_aw_dp_terms terms

1757: CURSOR cur_check_terms(
1758: p_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE
1759: ) IS
1760: SELECT terms.adterms_id
1761: FROM igf_aw_dp_terms terms
1762: WHERE terms.adplans_id = p_adplans_id;
1763: l_check_terms cur_check_terms%ROWTYPE;
1764: --Get incomplete terms
1765: CURSOR cur_check_teach(

Line 1769: FROM igf_aw_dp_terms terms

1765: CURSOR cur_check_teach(
1766: p_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE
1767: ) IS
1768: SELECT terms.adterms_id
1769: FROM igf_aw_dp_terms terms
1770: WHERE terms.adplans_id = p_adplans_id
1771: AND NOT EXISTS (
1772: SELECT 'x'
1773: FROM igf_aw_dp_teach_prds tech