APPS.BEN_DM_DOWNLOAD_DK dependencies on BEN_LEE_RSN_F

Line 1030: -- DK Resolve from Table BEN_LEE_RSN_F

1026: --
1027: end if;
1028: end;
1029: --
1030: -- DK Resolve from Table BEN_LEE_RSN_F
1031: --
1032: procedure get_dk_frm_len (p_business_group_name in VARCHAR2
1033: ,p_source_id in NUMBER
1034: ,p_resolve_mapping_id out nocopy NUMBER) is

Line 1036: -- cursor to Fetch the DK for BEN_LEE_RSN_F.LEE_RSN_ID

1032: procedure get_dk_frm_len (p_business_group_name in VARCHAR2
1033: ,p_source_id in NUMBER
1034: ,p_resolve_mapping_id out nocopy NUMBER) is
1035: --
1036: -- cursor to Fetch the DK for BEN_LEE_RSN_F.LEE_RSN_ID
1037: --
1038: cursor csr_get_dk_len is
1039: select ler_id,
1040: popl_enrt_typ_cycl_id,

Line 1042: from ben_lee_rsn_f

1038: cursor csr_get_dk_len is
1039: select ler_id,
1040: popl_enrt_typ_cycl_id,
1041: effective_start_date
1042: from ben_lee_rsn_f
1043: where lee_rsn_id = p_source_id
1044: order by effective_start_date asc;
1045:
1046: --

Line 1060: l_table_name varchar2(30) := 'BEN_LEE_RSN_F';

1056: l_row_fetched boolean := FALSE;
1057: l_row_fetched_pop boolean := FALSE;
1058: l_table_rec csr_get_dk_len%rowtype;
1059: l_table_rec_pop csr_get_dk_pop%rowtype;
1060: l_table_name varchar2(30) := 'BEN_LEE_RSN_F';
1061: l_column_name varchar2(30) := 'LEE_RSN_ID';
1062: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
1063: l_resolve_mapping_id1 ben_dm_resolve_mappings.resolve_mapping_id%type;
1064: l_resolve_mapping_id2 ben_dm_resolve_mappings.resolve_mapping_id%type;