APPS.BEN_DM_UPLOAD_DK dependencies on BEN_PLIP_F

Line 1469: -- DK Resolve For Table BEN_PLIP_F

1465: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;
1466: end;
1467:
1468: --
1469: -- DK Resolve For Table BEN_PLIP_F
1470: --
1471: procedure get_dk_frm_cpp is
1472: --
1473: -- cursor to Fetch the DK for BEN_PLIP_F.PLIP_ID

Line 1473: -- cursor to Fetch the DK for BEN_PLIP_F.PLIP_ID

1469: -- DK Resolve For Table BEN_PLIP_F
1470: --
1471: procedure get_dk_frm_cpp is
1472: --
1473: -- cursor to Fetch the DK for BEN_PLIP_F.PLIP_ID
1474: --
1475: cursor csr_get_dk_cpp (c_business_group_id number, c_source_key varchar2
1476: ,c_target_id1 number, c_target_id2 number) is
1477: select plip_id

Line 1478: from ben_plip_f

1474: --
1475: cursor csr_get_dk_cpp (c_business_group_id number, c_source_key varchar2
1476: ,c_target_id1 number, c_target_id2 number) is
1477: select plip_id
1478: from ben_plip_f
1479: where pgm_id = c_target_id1
1480: and pl_id = c_target_id2
1481: and business_group_id = c_business_group_id;
1482:

Line 1486: where table_name = 'BEN_PLIP_F'

1482:
1483: cursor csr_get_all_cpp is
1484: select *
1485: from ben_dm_resolve_mappings
1486: where table_name = 'BEN_PLIP_F'
1487: and target_id is null;
1488:
1489: -- Declare local variables
1490: l_proc varchar2(72) := g_package || 'get_dk_frm_cpp';

Line 1501: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table BEN_PLIP_F

1497:
1498: begin
1499:
1500: --
1501: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table BEN_PLIP_F
1502: --
1503: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;
1504: for x in csr_get_all_cpp loop
1505: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);

Line 3255: -- DK Resolve for Table BEN_PLIP_F

3251:
3252: -- DK Resolve for Table BEN_OIPL_F
3253: get_dk_frm_cop;
3254:
3255: -- DK Resolve for Table BEN_PLIP_F
3256: get_dk_frm_cpp;
3257:
3258: -- DK Resolve for Table BEN_PTIP_F
3259: get_dk_frm_ctp;