APPS.IGF_AW_PACKAGING dependencies on IGF_AW_AWD_DIST_PLANS_V

Line 665: p_method_desc OUT NOCOPY igf_aw_awd_dist_plans_v.dist_plan_method_code_desc%TYPE

661:
662: PROCEDURE get_plan_desc(
663: p_adplans_id IN igf_aw_awd_dist_plans.adplans_id%TYPE,
664: p_method_name OUT NOCOPY igf_aw_awd_dist_plans.awd_dist_plan_cd_desc%TYPE,
665: p_method_desc OUT NOCOPY igf_aw_awd_dist_plans_v.dist_plan_method_code_desc%TYPE
666: ) AS
667: ------------------------------------------------------------------
668: --Created by : veramach, Oracle India
669: --Date created:

Line 685: FROM igf_aw_awd_dist_plans_v

681: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE
682: ) IS
683: SELECT awd_dist_plan_cd_desc,
684: dist_plan_method_code_desc
685: FROM igf_aw_awd_dist_plans_v
686: WHERE adplans_id = cp_adplans_id;
687: l_plan c_plan%ROWTYPE;
688:
689: BEGIN

Line 5725: lv_desc igf_aw_awd_dist_plans_v.dist_plan_method_code_desc%TYPE;

5721: lv_result VARCHAR2(80);
5722: lv_method_code igf_aw_awd_dist_plans.dist_plan_method_code%TYPE;
5723:
5724: lv_name igf_aw_awd_dist_plans.awd_dist_plan_cd_desc%TYPE;
5725: lv_desc igf_aw_awd_dist_plans_v.dist_plan_method_code_desc%TYPE;
5726: --FACR116
5727: l_rel_code igf_sl_cl_setup.relationship_cd%TYPE;
5728: ln_person_id igf_sl_cl_pref_lenders.person_id%TYPE;
5729: l_party_id igf_sl_cl_setup.party_id%TYPE;

Line 7726: lv_desc igf_aw_awd_dist_plans_v.dist_plan_method_code_desc%TYPE := NULL;

7722: lv_result VARCHAR2(80) := NULL;
7723: lv_method_code VARCHAR2(80) := NULL;
7724:
7725: lv_name igf_aw_awd_dist_plans.awd_dist_plan_cd_desc%TYPE := NULL;
7726: lv_desc igf_aw_awd_dist_plans_v.dist_plan_method_code_desc%TYPE := NULL;
7727:
7728: l_failed_award_id igf_aw_award_all.award_id%TYPE;
7729:
7730: BEGIN

Line 8781: lv_method_desc igf_aw_awd_dist_plans_v.dist_plan_method_code_desc%TYPE;

8777:
8778: lv_result VARCHAR2(80);
8779: lv_method_code igf_aw_awd_dist_plans.dist_plan_method_code%TYPE;
8780: lv_method_name igf_aw_awd_dist_plans.awd_dist_plan_cd_desc%TYPE;
8781: lv_method_desc igf_aw_awd_dist_plans_v.dist_plan_method_code_desc%TYPE;
8782:
8783: ln_com_perct NUMBER;
8784:
8785: l_pell_seq_id igf_gr_pell_setup_all.pell_seq_id%TYPE;