APPS.BEN_DM_DOWNLOAD_DK dependencies on BEN_CMBN_PTIP_F

Line 526: -- DK Resolve from Table BEN_CMBN_PTIP_F

522: --
523: end if;
524: end;
525: --
526: -- DK Resolve from Table BEN_CMBN_PTIP_F
527: --
528: procedure get_dk_frm_cbp (p_business_group_name in VARCHAR2
529: ,p_source_id in NUMBER
530: ,p_resolve_mapping_id out nocopy NUMBER) is

Line 532: -- cursor to Fetch the DK for BEN_CMBN_PTIP_F.CMBN_PTIP_ID

528: procedure get_dk_frm_cbp (p_business_group_name in VARCHAR2
529: ,p_source_id in NUMBER
530: ,p_resolve_mapping_id out nocopy NUMBER) is
531: --
532: -- cursor to Fetch the DK for BEN_CMBN_PTIP_F.CMBN_PTIP_ID
533: --
534: cursor csr_get_dk_cbp is
535: select name
536: from ben_cmbn_ptip_f

Line 536: from ben_cmbn_ptip_f

532: -- cursor to Fetch the DK for BEN_CMBN_PTIP_F.CMBN_PTIP_ID
533: --
534: cursor csr_get_dk_cbp is
535: select name
536: from ben_cmbn_ptip_f
537: where cmbn_ptip_id = p_source_id;
538:
539: -- Declare local variables
540: l_proc varchar2(72) := g_package || 'get_dk_frm_cbp';

Line 543: l_table_name varchar2(30) := 'BEN_CMBN_PTIP_F';

539: -- Declare local variables
540: l_proc varchar2(72) := g_package || 'get_dk_frm_cbp';
541: l_row_fetched boolean := FALSE;
542: l_table_rec csr_get_dk_cbp%rowtype;
543: l_table_name varchar2(30) := 'BEN_CMBN_PTIP_F';
544: l_column_name varchar2(30) := 'CMBN_PTIP_ID';
545: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
546:
547: begin