APPS.BEN_PD_COPY_TO_BEN_TWO dependencies on BEN_OIPLIP_F

Line 24642: -- and tr.where_clause = l_BEN_OIPLIP_F

24638: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
24639: pqh_table_route tr
24640: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
24641: and cpe.table_route_id = tr.table_route_id
24642: -- and tr.where_clause = l_BEN_OIPLIP_F
24643: and tr.table_alias = l_table_alias
24644: and cpe.number_of_copies = 1 -- ADDITION
24645: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
24646: order by information1, information2; --added for bug: 5151945

Line 24680: from BEN_OIPLIP_F OPP

24676: c_business_group_id number,
24677: c_new_pk_id number) is
24678: select
24679: OPP.oiplip_id new_value
24680: from BEN_OIPLIP_F OPP
24681: where
24682: OPP.OIPL_ID = l_OIPL_ID and
24683: OPP.PLIP_ID = l_PLIP_ID and
24684: OPP.business_group_id = c_business_group_id

Line 24692: from BEN_OIPLIP_F OPP1

24688: and effective_end_date ;
24689: --END TEMPIK
24690: /*
24691: and exists ( select null
24692: from BEN_OIPLIP_F OPP1
24693: where
24694: OPP1.OIPL_ID = l_OIPL_ID and
24695: OPP1.PLIP_ID = l_PLIP_ID and
24696: OPP1.business_group_id = c_business_group_id

Line 24699: from BEN_OIPLIP_F OPP2

24695: OPP1.PLIP_ID = l_PLIP_ID and
24696: OPP1.business_group_id = c_business_group_id
24697: and OPP1.effective_start_date <= c_effective_start_date )
24698: and exists ( select null
24699: from BEN_OIPLIP_F OPP2
24700: where
24701: OPP2.OIPL_ID = l_OIPL_ID and
24702: OPP2.PLIP_ID = l_PLIP_ID and
24703: OPP2.business_group_id = c_business_group_id

Line 24795: (p_base_table_name => 'BEN_OIPLIP_F',

24791: if c_find_OPP_in_target%found then
24792: --
24793: --TEMPIK
24794: l_dt_rec_found := dt_api.check_min_max_dates
24795: (p_base_table_name => 'BEN_OIPLIP_F',
24796: p_base_key_column => 'OIPLIP_ID',
24797: p_base_key_value => l_new_value,
24798: p_from_date => l_min_esd,
24799: p_to_date => l_max_eed );

Line 24855: hr_utility.set_location(' BEN_OIPLIP_F CREATE_OPTION_IN_PLAN_IN_PGM ',20);

24851: end if;
24852:
24853: if l_first_rec then
24854: -- Call Create routine.
24855: hr_utility.set_location(' BEN_OIPLIP_F CREATE_OPTION_IN_PLAN_IN_PGM ',20);
24856: BEN_OPTION_IN_PLAN_IN_PGM_API.CREATE_OPTION_IN_PLAN_IN_PGM(
24857: --
24858: P_VALIDATE => false
24859: ,P_EFFECTIVE_DATE => l_effective_date

Line 24920: hr_utility.set_location(' BEN_OIPLIP_F UPDATE_OPTION_IN_PLAN_IN_PGM ',30);

24916: else
24917: --
24918: -- Call Update routine for the pk_id created in prev run .
24919: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
24920: hr_utility.set_location(' BEN_OIPLIP_F UPDATE_OPTION_IN_PLAN_IN_PGM ',30);
24921: BEN_OPTION_IN_PLAN_IN_PGM_API.UPDATE_OPTION_IN_PLAN_IN_PGM(
24922: --
24923: P_VALIDATE => false
24924: ,P_EFFECTIVE_DATE => l_effective_date