APPS.BEN_PD_COPY_TO_BEN_TWO dependencies on BEN_PLIP_F

Line 8406: -- and tr.where_clause = l_BEN_PLIP_F

8402: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
8403: pqh_table_route tr
8404: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
8405: and cpe.table_route_id = tr.table_route_id
8406: -- and tr.where_clause = l_BEN_PLIP_F
8407: and tr.table_alias = l_table_alias
8408: and cpe.number_of_copies = 1 -- ADDITION
8409: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
8410: order by cpe.information1, cpe.information2 /* Bug 5076363 */;

Line 8444: from BEN_PLIP_F CPP

8440: c_business_group_id number,
8441: c_new_pk_id number) is
8442: select
8443: CPP.plip_id new_value
8444: from BEN_PLIP_F CPP
8445: where
8446: -- nvl(CPP.CMBN_PLIP_ID,-999) = nvl(l_CMBN_PLIP_ID,-999) and
8447: CPP.PGM_ID = l_PGM_ID and
8448: CPP.PL_ID = l_PL_ID and

Line 8457: from BEN_PLIP_F CPP1

8453: --END TEMPIK
8454: /*TEMPIK
8455: and CPP.plip_id <> c_new_pk_id
8456: and exists ( select null
8457: from BEN_PLIP_F CPP1
8458: where
8459: -- nvl(CPP1.CMBN_PLIP_ID,-999) = nvl(l_CMBN_PLIP_ID,-999) and
8460: CPP1.PGM_ID = l_PGM_ID and
8461: CPP1.PL_ID = l_PL_ID and

Line 8465: from BEN_PLIP_F CPP2

8461: CPP1.PL_ID = l_PL_ID and
8462: CPP1.business_group_id = c_business_group_id
8463: and CPP1.effective_start_date <= c_effective_start_date )
8464: and exists ( select null
8465: from BEN_PLIP_F CPP2
8466: where
8467: -- nvl(CPP2.CMBN_PLIP_ID,-999) = nvl(l_CMBN_PLIP_ID,-999) and
8468: CPP2.PGM_ID = l_PGM_ID and
8469: CPP2.PL_ID = l_PL_ID and

Line 8626: (p_base_table_name => 'BEN_PLIP_F',

8622: if c_find_CPP_in_target%found then
8623: --
8624: --TEMPIK
8625: l_dt_rec_found := dt_api.check_min_max_dates
8626: (p_base_table_name => 'BEN_PLIP_F',
8627: p_base_key_column => 'PLIP_ID',
8628: p_base_key_value => l_new_value,
8629: p_from_date => l_min_esd,
8630: p_to_date => l_max_eed );

Line 8686: hr_utility.set_location(' BEN_PLIP_F CREATE_PLAN_IN_PROGRAM ',20);

8682:
8683: if l_first_rec and not l_update then
8684:
8685: -- Call Create routine.
8686: hr_utility.set_location(' BEN_PLIP_F CREATE_PLAN_IN_PROGRAM ',20);
8687: BEN_PLAN_IN_PROGRAM_API.CREATE_PLAN_IN_PROGRAM(
8688: --
8689: P_VALIDATE => false
8690: ,P_EFFECTIVE_DATE => l_effective_date

Line 8804: hr_utility.set_location(' BEN_PLIP_F UPDATE_PLAN_IN_PROGRAM ',30);

8800: else
8801: --
8802: -- Call Update routine for the pk_id created in prev run .
8803: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
8804: hr_utility.set_location(' BEN_PLIP_F UPDATE_PLAN_IN_PROGRAM ',30);
8805: --UPD START
8806: hr_utility.set_location('Before call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
8807: --
8808: if l_update then

Line 24827: -- NEVER CREATE HERE. THIS IS DONE IN BEN_PLIP_F and BEN_OIPL_F apis.

24823: -- end if ;
24824: --
24825: close c_OPP_min_max_dates ;
24826: --
24827: -- NEVER CREATE HERE. THIS IS DONE IN BEN_PLIP_F and BEN_OIPL_F apis.
24828: /*
24829: if not l_object_found_in_target then
24830: --
24831: l_current_pk_id := r_OPP.information1;

Line 25223: -- NEVER CREATE HERE. THIS IS DONE IN BEN_OIPL_F, BEN_PLIP_F, BEN_OPT_F and BEN_PTIP_F apis.

25219: end if;
25220: -- end if ;
25221: --
25222: close c_OTP_min_max_dates ;
25223: -- NEVER CREATE HERE. THIS IS DONE IN BEN_OIPL_F, BEN_PLIP_F, BEN_OPT_F and BEN_PTIP_F apis.
25224: /*
25225: if not l_object_found_in_target then
25226: --
25227: l_current_pk_id := r_OTP.information1;