eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_PD_COPY_TO_BEN_ONE dependencies on BEN_RLTD_PER_CHG_CS_LER_F

Line 8549: -- and tr.where_clause = l_BEN_RLTD_PER_CHG_CS_LER_F

8545: from ben_copy_entity_results cpe,
8546: pqh_table_route tr
8547: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
8548: and cpe.table_route_id = tr.table_route_id
8549: -- and tr.where_clause = l_BEN_RLTD_PER_CHG_CS_LER_F
8550: and tr.table_alias = l_table_alias
8551: and cpe.number_of_copies = 1 --ADDITION
8552: group by cpe.information1,cpe.information2,cpe.information3, cpe.INFORMATION218, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
8553: order by information1, information2; --added for bug: 5151945

Line 8587: from BEN_RLTD_PER_CHG_CS_LER_F RCL

8583: c_business_group_id number,
8584: c_new_pk_id number) is
8585: select
8586: RCL.rltd_per_chg_cs_ler_id new_value
8587: from BEN_RLTD_PER_CHG_CS_LER_F RCL
8588: where RCL.name = c_RCL_name
8589: and RCL.business_group_id = c_business_group_id
8590: and RCL.rltd_per_chg_cs_ler_id <> c_new_pk_id
8591: --TEMPIK

Line 8597: from BEN_RLTD_PER_CHG_CS_LER_F RCL1

8593: and effective_end_date ;
8594: --END TEMPIK
8595: /*TEMPIK
8596: and exists ( select null
8597: from BEN_RLTD_PER_CHG_CS_LER_F RCL1
8598: where RCL1.name = c_RCL_name
8599: and RCL1.business_group_id = c_business_group_id
8600: and RCL1.effective_start_date <= c_effective_start_date )
8601: and exists ( select null

Line 8602: from BEN_RLTD_PER_CHG_CS_LER_F RCL2

8598: where RCL1.name = c_RCL_name
8599: and RCL1.business_group_id = c_business_group_id
8600: and RCL1.effective_start_date <= c_effective_start_date )
8601: and exists ( select null
8602: from BEN_RLTD_PER_CHG_CS_LER_F RCL2
8603: where RCL2.name = c_RCL_name
8604: and RCL2.business_group_id = c_business_group_id
8605: and RCL2.effective_end_date >= c_effective_end_date )
8606: ;

Line 8725: (p_base_table_name => 'BEN_RLTD_PER_CHG_CS_LER_F',

8721: if c_find_RCL_in_target%found then
8722: --
8723: --TEMPIK
8724: l_dt_rec_found := dt_api.check_min_max_dates
8725: (p_base_table_name => 'BEN_RLTD_PER_CHG_CS_LER_F',
8726: p_base_key_column => 'RLTD_PER_CHG_CS_LER_ID',
8727: p_base_key_value => l_new_value,
8728: p_from_date => l_min_esd,
8729: p_to_date => l_max_eed );

Line 8785: ben_pd_copy_to_ben_one.ben_chk_col_len('NAME' ,'BEN_RLTD_PER_CHG_CS_LER_F',l_prefix || r_RCL.INFORMATION218 || l_suffix);

8781: end if ;
8782: --
8783: l_RLTD_PER_CHG_CS_LER_RL := get_fk('FORMULA_ID', r_RCL.INFORMATION260, l_dml_operation);
8784: --
8785: ben_pd_copy_to_ben_one.ben_chk_col_len('NAME' ,'BEN_RLTD_PER_CHG_CS_LER_F',l_prefix || r_RCL.INFORMATION218 || l_suffix);
8786: --
8787:
8788: l_effective_date := r_RCL.information2;
8789: if ( ben_pd_copy_to_ben_one.g_copy_effective_date is not null and

Line 8796: hr_utility.set_location(' BEN_RLTD_PER_CHG_CS_LER_F CREATE_RLTD_PER_CHG_CS_LER ',20);

8792: end if;
8793:
8794: if l_first_rec and not l_update then
8795: -- Call Create routine.
8796: hr_utility.set_location(' BEN_RLTD_PER_CHG_CS_LER_F CREATE_RLTD_PER_CHG_CS_LER ',20);
8797: BEN_RLTD_PER_CHG_CS_LER_API.CREATE_RLTD_PER_CHG_CS_LER(
8798: --
8799: P_VALIDATE => false
8800: ,P_EFFECTIVE_DATE => l_effective_date

Line 8891: hr_utility.set_location(' BEN_RLTD_PER_CHG_CS_LER_F UPDATE_RLTD_PER_CHG_CS_LER ',30);

8887: IF l_update OR l_dml_operation <> 'UPDATE' THEN
8888: --UPD END
8889: -- Call Update routine for the pk_id created in prev run .
8890: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
8891: hr_utility.set_location(' BEN_RLTD_PER_CHG_CS_LER_F UPDATE_RLTD_PER_CHG_CS_LER ',30);
8892: BEN_RLTD_PER_CHG_CS_LER_API.UPDATE_RLTD_PER_CHG_CS_LER(
8893: --
8894: P_VALIDATE => false
8895: ,P_EFFECTIVE_DATE => l_effective_date