APPS.BEN_DM_UPLOAD_DK dependencies on BEN_LEE_RSN_F

Line 1032: -- DK Resolve For Table BEN_LEE_RSN_F

1028: end loop;
1029: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;
1030: end;
1031: --
1032: -- DK Resolve For Table BEN_LEE_RSN_F
1033: --
1034: procedure get_dk_frm_len is
1035: --
1036: -- cursor to Fetch the DK for BEN_LEE_RSN_F.LEE_RSN_ID

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

1032: -- DK Resolve For Table BEN_LEE_RSN_F
1033: --
1034: procedure get_dk_frm_len is
1035: --
1036: -- cursor to Fetch the DK for BEN_LEE_RSN_F.LEE_RSN_ID
1037: --
1038: cursor csr_get_dk_len (c_business_group_id number,
1039: c_source_key varchar2,
1040: c_ler_id number,

Line 1043: from ben_lee_rsn_f

1039: c_source_key varchar2,
1040: c_ler_id number,
1041: c_popl_enrt_typ_cycl_id number) is
1042: select lee_rsn_id
1043: from ben_lee_rsn_f
1044: where effective_start_date = to_date(c_source_key,'dd-mm-rrrr')
1045: and ler_id = c_ler_id
1046: and popl_enrt_typ_cycl_id = c_popl_enrt_typ_cycl_id
1047: and business_group_id = c_business_group_id;

Line 1052: where table_name = 'BEN_LEE_RSN_F'

1048:
1049: cursor csr_get_all_len is
1050: select *
1051: from ben_dm_resolve_mappings
1052: where table_name = 'BEN_LEE_RSN_F'
1053: and target_id is null;
1054:
1055: cursor csr_get_dk_pop (c_pgm_id number, c_pl_id number, c_business_group_id number) is
1056: select *

Line 3196: -- DK Resolve for Table BEN_LEE_RSN_F

3192:
3193: -- DK Resolve for Table BEN_YR_PERD
3194: get_dk_frm_yrp;
3195:
3196: -- DK Resolve for Table BEN_LEE_RSN_F
3197: get_dk_frm_len;
3198:
3199: -- DK Resolve for Table FF_FORMULAS_F
3200: get_dk_frm_fra;