APPS.BEN_DM_DOWNLOAD_DK dependencies on PER_GRADES

Line 2639: -- DK Resolve from Table PER_GRADES

2635: --
2636: end if;
2637: end;
2638: --
2639: -- DK Resolve from Table PER_GRADES
2640: --
2641: procedure get_dk_frm_gra (p_business_group_name in VARCHAR2
2642: ,p_source_id in NUMBER
2643: ,p_resolve_mapping_id out nocopy NUMBER) is

Line 2645: -- cursor to Fetch the DK for PER_GRADES.GRADE_ID

2641: procedure get_dk_frm_gra (p_business_group_name in VARCHAR2
2642: ,p_source_id in NUMBER
2643: ,p_resolve_mapping_id out nocopy NUMBER) is
2644: --
2645: -- cursor to Fetch the DK for PER_GRADES.GRADE_ID
2646: --
2647: cursor csr_get_dk_gra is
2648: select name
2649: from per_grades

Line 2649: from per_grades

2645: -- cursor to Fetch the DK for PER_GRADES.GRADE_ID
2646: --
2647: cursor csr_get_dk_gra is
2648: select name
2649: from per_grades
2650: where grade_id = p_source_id;
2651:
2652: -- Declare local variables
2653: l_proc varchar2(72) := g_package || 'get_dk_frm_gra';

Line 2656: l_table_name varchar2(30) := 'PER_GRADES';

2652: -- Declare local variables
2653: l_proc varchar2(72) := g_package || 'get_dk_frm_gra';
2654: l_row_fetched boolean := FALSE;
2655: l_table_rec csr_get_dk_gra%rowtype;
2656: l_table_name varchar2(30) := 'PER_GRADES';
2657: l_column_name varchar2(30) := 'GRADE_ID';
2658: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
2659:
2660: begin