APPS.BEN_PD_COPY_TO_BEN_ONE dependencies on BEN_PL_TYP_OPT_TYP_F

Line 15968: -- and tr.where_clause = l_BEN_PL_TYP_OPT_TYP_F

15964: from ben_copy_entity_results cpe,
15965: pqh_table_route tr
15966: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
15967: and cpe.table_route_id = tr.table_route_id
15968: -- and tr.where_clause = l_BEN_PL_TYP_OPT_TYP_F
15969: and tr.table_alias = l_table_alias
15970: and cpe.number_of_copies = 1 --ADDITION
15971: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
15972: order by information1, information2; --added for bug: 5151945

Line 16006: from BEN_PL_TYP_OPT_TYP_F PON

16002: c_business_group_id number,
16003: c_new_pk_id number) is
16004: select
16005: PON.pl_typ_opt_typ_id new_value
16006: from BEN_PL_TYP_OPT_TYP_F PON
16007: where
16008: PON.OPT_ID = l_OPT_ID and
16009: PON.PL_TYP_ID = l_PL_TYP_ID and
16010: PON.business_group_id = c_business_group_id

Line 16018: from BEN_PL_TYP_OPT_TYP_F PON1

16014: and effective_end_date ;
16015: --END TEMPIK
16016: /*TEMPIK
16017: and exists ( select null
16018: from BEN_PL_TYP_OPT_TYP_F PON1
16019: where
16020: PON1.OPT_ID = l_OPT_ID and
16021: PON1.PL_TYP_ID = l_PL_TYP_ID and
16022: PON1.business_group_id = c_business_group_id

Line 16025: from BEN_PL_TYP_OPT_TYP_F PON2

16021: PON1.PL_TYP_ID = l_PL_TYP_ID and
16022: PON1.business_group_id = c_business_group_id
16023: and PON1.effective_start_date <= c_effective_start_date )
16024: and exists ( select null
16025: from BEN_PL_TYP_OPT_TYP_F PON2
16026: where
16027: PON2.OPT_ID = l_OPT_ID and
16028: PON2.PL_TYP_ID = l_PL_TYP_ID and
16029: PON2.business_group_id = c_business_group_id

Line 16175: (p_base_table_name => 'BEN_PL_TYP_OPT_TYP_F',

16171: if c_find_PON_in_target%found then
16172: --
16173: --TEMPIK
16174: l_dt_rec_found := dt_api.check_min_max_dates
16175: (p_base_table_name => 'BEN_PL_TYP_OPT_TYP_F',
16176: p_base_key_column => 'PL_TYP_OPT_TYP_ID',
16177: p_base_key_value => l_new_value,
16178: p_from_date => l_min_esd,
16179: p_to_date => l_max_eed );

Line 16236: hr_utility.set_location(' BEN_PL_TYP_OPT_TYP_F CREATE_PLAN_TYPE_OPTION_TYPE ',20);

16232: end if;
16233:
16234: if l_first_rec and not l_update then
16235: -- Call Create routine.
16236: hr_utility.set_location(' BEN_PL_TYP_OPT_TYP_F CREATE_PLAN_TYPE_OPTION_TYPE ',20);
16237: BEN_PLAN_TYPE_OPTION_TYPE_API.CREATE_PLAN_TYPE_OPTION_TYPE(
16238: --
16239: P_VALIDATE => false
16240: ,P_EFFECTIVE_DATE => l_effective_date

Line 16327: hr_utility.set_location(' BEN_PL_TYP_OPT_TYP_F UPDATE_PLAN_TYPE_OPTION_TYPE ',30);

16323: hr_utility.set_location('After call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
16324: --
16325: IF l_update OR l_dml_operation <> 'UPDATE' THEN
16326: --UPD END
16327: hr_utility.set_location(' BEN_PL_TYP_OPT_TYP_F UPDATE_PLAN_TYPE_OPTION_TYPE ',30);
16328: BEN_PLAN_TYPE_OPTION_TYPE_API.UPDATE_PLAN_TYPE_OPTION_TYPE(
16329: --
16330: P_VALIDATE => false
16331: ,P_EFFECTIVE_DATE => l_effective_date