APPS.BEN_PD_COPY_TO_BEN_TWO dependencies on BEN_PL_GD_OR_SVC_F

Line 6903: -- and tr.where_clause = l_BEN_PL_GD_OR_SVC_F

6899: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
6900: pqh_table_route tr
6901: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
6902: and cpe.table_route_id = tr.table_route_id
6903: -- and tr.where_clause = l_BEN_PL_GD_OR_SVC_F
6904: and tr.table_alias = l_table_alias
6905: and cpe.number_of_copies = 1 -- ADDITION
6906: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
6907: order by information1, information2; --added for bug: 5151945

Line 6941: from BEN_PL_GD_OR_SVC_F VGS

6937: c_business_group_id number,
6938: c_new_pk_id number) is
6939: select
6940: VGS.pl_gd_or_svc_id new_value
6941: from BEN_PL_GD_OR_SVC_F VGS
6942: where
6943: VGS.GD_OR_SVC_TYP_ID = l_GD_OR_SVC_TYP_ID and
6944: VGS.PL_ID = l_PL_ID and
6945: VGS.business_group_id = c_business_group_id

Line 6953: from BEN_PL_GD_OR_SVC_F VGS1

6949: and effective_end_date ;
6950: --END TEMPIK
6951: /*TEMPIK
6952: and exists ( select null
6953: from BEN_PL_GD_OR_SVC_F VGS1
6954: where
6955: VGS1.GD_OR_SVC_TYP_ID = l_GD_OR_SVC_TYP_ID and
6956: VGS1.PL_ID = l_PL_ID and
6957: VGS1.business_group_id = c_business_group_id

Line 6960: from BEN_PL_GD_OR_SVC_F VGS2

6956: VGS1.PL_ID = l_PL_ID and
6957: VGS1.business_group_id = c_business_group_id
6958: and VGS1.effective_start_date <= c_effective_start_date )
6959: and exists ( select null
6960: from BEN_PL_GD_OR_SVC_F VGS2
6961: where
6962: VGS2.GD_OR_SVC_TYP_ID = l_GD_OR_SVC_TYP_ID and
6963: VGS2.PL_ID = l_PL_ID and
6964: VGS2.business_group_id = c_business_group_id

Line 7107: (p_base_table_name => 'BEN_PL_GD_OR_SVC_F',

7103: if c_find_VGS_in_target%found then
7104: --
7105: --TEMPIK
7106: l_dt_rec_found := dt_api.check_min_max_dates
7107: (p_base_table_name => 'BEN_PL_GD_OR_SVC_F',
7108: p_base_key_column => 'PL_GD_OR_SVC_ID',
7109: p_base_key_value => l_new_value,
7110: p_from_date => l_min_esd,
7111: p_to_date => l_max_eed );

Line 7166: hr_utility.set_location(' BEN_PL_GD_OR_SVC_F CREATE_PLAN_GOODS_SERVICES ',20);

7162: end if;
7163:
7164: if l_first_rec and not l_update then
7165: -- Call Create routine.
7166: hr_utility.set_location(' BEN_PL_GD_OR_SVC_F CREATE_PLAN_GOODS_SERVICES ',20);
7167: BEN_PLAN_GOODS_SERVICES_API.CREATE_PLAN_GOODS_SERVICES(
7168: --
7169: P_VALIDATE => false
7170: ,P_EFFECTIVE_DATE => l_effective_date

Line 7236: hr_utility.set_location(' BEN_PL_GD_OR_SVC_F UPDATE_PLAN_GOODS_SERVICES ',30);

7232: else
7233: --
7234: -- Call Update routine for the pk_id created in prev run .
7235: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
7236: hr_utility.set_location(' BEN_PL_GD_OR_SVC_F UPDATE_PLAN_GOODS_SERVICES ',30);
7237: --UPD START
7238: hr_utility.set_location('Before call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
7239: --
7240: if l_update then