APPS.BEN_PD_COPY_TO_BEN_ONE dependencies on BEN_PER_INFO_CHG_CS_LER_F

Line 12386: -- and tr.where_clause = l_BEN_PER_INFO_CHG_CS_LER_F

12382: from ben_copy_entity_results cpe,
12383: pqh_table_route tr
12384: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
12385: and cpe.table_route_id = tr.table_route_id
12386: -- and tr.where_clause = l_BEN_PER_INFO_CHG_CS_LER_F
12387: and tr.table_alias = l_table_alias
12388: and cpe.number_of_copies = 1 --ADDITION
12389: group by cpe.information1,cpe.information2,cpe.information3, cpe.INFORMATION218, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
12390: order by information1, information2; --added for bug: 5151945

Line 12424: from BEN_PER_INFO_CHG_CS_LER_F PSL

12420: c_business_group_id number,
12421: c_new_pk_id number) is
12422: select
12423: PSL.per_info_chg_cs_ler_id new_value
12424: from BEN_PER_INFO_CHG_CS_LER_F PSL
12425: where ( PSL.name = c_PSL_name OR
12426: ( PSL.source_table = l_source_table
12427: and PSL.source_column = l_source_column
12428: and PSL.new_val = nvl(l_new_val,hr_api.g_varchar2)

Line 12438: from BEN_PER_INFO_CHG_CS_LER_F PSL1

12434: and effective_end_date ;
12435: --END TEMPIK
12436: /*TEMPIK
12437: and exists ( select null
12438: from BEN_PER_INFO_CHG_CS_LER_F PSL1
12439: where (PSL1.name = c_PSL_name OR
12440: ( PSL1.source_table = l_source_table
12441: and PSL1.source_column = l_source_column
12442: --and PSL1.new_val = nvl(l_new_val,hr_api.g_varchar2)

Line 12448: from BEN_PER_INFO_CHG_CS_LER_F PSL2

12444: ))
12445: and PSL1.business_group_id = c_business_group_id
12446: and PSL1.effective_start_date <= c_effective_start_date )
12447: and exists ( select null
12448: from BEN_PER_INFO_CHG_CS_LER_F PSL2
12449: where ( PSL2.name = c_PSL_name OR
12450: ( PSL2.source_table = l_source_table
12451: and PSL2.source_column = l_source_column
12452: --and PSL2.new_val = nvl(l_new_val,hr_api.g_varchar2)

Line 12650: (p_base_table_name => 'BEN_PER_INFO_CHG_CS_LER_F',

12646: if c_find_PSL_in_target%found then
12647: --
12648: --TEMPIK
12649: l_dt_rec_found := dt_api.check_min_max_dates
12650: (p_base_table_name => 'BEN_PER_INFO_CHG_CS_LER_F',
12651: p_base_key_column => 'PER_INFO_CHG_CS_LER_ID',
12652: p_base_key_value => l_new_value,
12653: p_from_date => l_min_esd,
12654: p_to_date => l_max_eed );

Line 12705: ben_pd_copy_to_ben_one.ben_chk_col_len('NAME' ,'BEN_PER_INFO_CHG_CS_LER_F',l_prefix || r_PSL.INFORMATION218 || l_suffix);

12701: end if ;
12702: --
12703: l_PER_INFO_CHG_CS_LER_RL := get_fk('FORMULA_ID', r_PSL.INFORMATION260,l_dml_operation);
12704: --
12705: ben_pd_copy_to_ben_one.ben_chk_col_len('NAME' ,'BEN_PER_INFO_CHG_CS_LER_F',l_prefix || r_PSL.INFORMATION218 || l_suffix);
12706: --
12707:
12708: l_effective_date := r_PSL.information2;
12709: if ( ben_pd_copy_to_ben_one.g_copy_effective_date is not null and

Line 12716: hr_utility.set_location(' BEN_PER_INFO_CHG_CS_LER_F CREATE_PERSON_CHANGE_CS_LER ',20);

12712: end if;
12713:
12714: if l_first_rec and not l_update then
12715: -- Call Create routine.
12716: hr_utility.set_location(' BEN_PER_INFO_CHG_CS_LER_F CREATE_PERSON_CHANGE_CS_LER ',20);
12717: BEN_PERSON_CHANGE_CS_LER_API.CREATE_PERSON_CHANGE_CS_LER(
12718: --
12719: P_VALIDATE => false
12720: ,P_EFFECTIVE_DATE => l_effective_date

Line 12817: hr_utility.set_location(' BEN_PER_INFO_CHG_CS_LER_F UPDATE_PERSON_CHANGE_CS_LER ',30);

12813: IF l_update OR l_dml_operation <> 'UPDATE' THEN
12814: --UPD END
12815: -- Call Update routine for the pk_id created in prev run .
12816: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
12817: hr_utility.set_location(' BEN_PER_INFO_CHG_CS_LER_F UPDATE_PERSON_CHANGE_CS_LER ',30);
12818: BEN_PERSON_CHANGE_CS_LER_API.UPDATE_PERSON_CHANGE_CS_LER(
12819: --
12820: P_VALIDATE => false
12821: ,P_EFFECTIVE_DATE => l_effective_date