APPS.IGF_AW_PACKNG_SUBFNS dependencies on IGF_AW_AWD_DIST_PLANS

Line 891: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE

887:
888: l_enrl_dt_rec c_enrl_dtl_cur%ROWTYPE;
889:
890: CURSOR c_get_awd_dt(
891: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE
892: ) IS
893: SELECT MIN(terms.start_date) start_dt
894: FROM igf_aw_dp_terms_v terms
895: WHERE terms.adplans_id = cp_adplans_id;

Line 918: igf_aw_awd_dist_plans adplans

914: SELECT igf_aw_packaging.get_term_start_date(cp_base_id, dp_terms.ld_cal_type, dp_terms.ld_sequence_number) ear_term_start_date
915: FROM
916: igf_aw_coa_term_tot_v coa_terms,
917: igf_aw_dp_terms dp_terms,
918: igf_aw_awd_dist_plans adplans
919: WHERE
920: dp_terms.ld_cal_type = coa_terms.ld_cal_type
921: AND dp_terms.ld_sequence_number = coa_terms.ld_sequence_number
922: AND dp_terms.adplans_id = adplans.adplans_id

Line 930: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE

926:
927: -- Get the start date of the earliest term in the DP matching terms
928: CURSOR c_get_ear_term_st_date_dp(
929: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
930: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE
931: ) IS
932: SELECT igf_aw_packaging.get_term_start_date(cp_base_id, dp_terms.ld_cal_type, dp_terms.ld_sequence_number) ear_term_start_date
933: FROM igf_aw_dp_terms dp_terms,
934: igf_aw_awd_dist_plans adplans

Line 934: igf_aw_awd_dist_plans adplans

930: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE
931: ) IS
932: SELECT igf_aw_packaging.get_term_start_date(cp_base_id, dp_terms.ld_cal_type, dp_terms.ld_sequence_number) ear_term_start_date
933: FROM igf_aw_dp_terms dp_terms,
934: igf_aw_awd_dist_plans adplans
935: WHERE dp_terms.adplans_id = adplans.adplans_id
936: AND dp_terms.adplans_id = cp_adplans_id
937: ORDER BY igf_aw_packaging.get_term_start_date(cp_base_id, dp_terms.ld_cal_type, dp_terms.ld_sequence_number) ASC;
938: