APPS.BEN_DM_DOWNLOAD_DK dependencies on BEN_ACTL_PREM_F

Line 64: -- DK Resolve from Table BEN_ACTL_PREM_F

60:
61: end;
62:
63: --
64: -- DK Resolve from Table BEN_ACTL_PREM_F
65: --
66: procedure get_dk_frm_apr (p_business_group_name in VARCHAR2
67: ,p_source_id in NUMBER
68: ,p_resolve_mapping_id out nocopy NUMBER) is

Line 70: -- cursor to Fetch the DK for BEN_ACTL_PREM_F.ACTL_PREM_ID.

66: procedure get_dk_frm_apr (p_business_group_name in VARCHAR2
67: ,p_source_id in NUMBER
68: ,p_resolve_mapping_id out nocopy NUMBER) is
69: --
70: -- cursor to Fetch the DK for BEN_ACTL_PREM_F.ACTL_PREM_ID.
71: --
72:
73: cursor csr_get_dk_apr is
74: select name

Line 75: from ben_actl_prem_f apr

71: --
72:
73: cursor csr_get_dk_apr is
74: select name
75: from ben_actl_prem_f apr
76: where actl_prem_id = p_source_id;
77:
78: -- Declare local variables
79: l_proc varchar2(72) := g_package || 'get_dk_frm_apr' ;

Line 83: l_table_name varchar2(30) := 'BEN_ACTL_PREM_F';

79: l_proc varchar2(72) := g_package || 'get_dk_frm_apr' ;
80: l_rec_inserted_cnt number := 0;
81: l_row_fetched boolean := FALSE;
82: l_table_rec csr_get_dk_apr%rowtype;
83: l_table_name varchar2(30) := 'BEN_ACTL_PREM_F';
84: l_column_name varchar2(30) := 'ACTL_PREM_ID';
85: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
86:
87: begin