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_REGN_F

Line 7356: -- and tr.where_clause = l_BEN_REGN_F

7352: from ben_copy_entity_results cpe,
7353: pqh_table_route tr
7354: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
7355: and cpe.table_route_id = tr.table_route_id
7356: -- and tr.where_clause = l_BEN_REGN_F
7357: and tr.table_alias = l_table_alias
7358: and cpe.number_of_copies = 1 --ADDITION
7359: group by cpe.information1,cpe.information2,cpe.information3, cpe.INFORMATION170, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
7360: order by information1, information2; --added for bug: 5151945

Line 7394: from BEN_REGN_F REG

7390: c_business_group_id number,
7391: c_new_pk_id number) is
7392: select
7393: REG.regn_id new_value
7394: from BEN_REGN_F REG
7395: where REG.name = c_REG_name
7396: and REG.business_group_id = c_business_group_id
7397: and REG.regn_id <> c_new_pk_id
7398: --TEMPIK

Line 7404: from BEN_REGN_F REG1

7400: and effective_end_date ;
7401: --END TEMPIK
7402: /*TEMPIK
7403: and exists ( select null
7404: from BEN_REGN_F REG1
7405: where REG1.name = c_REG_name
7406: and REG1.business_group_id = c_business_group_id
7407: and REG1.effective_start_date <= c_effective_start_date )
7408: and exists ( select null

Line 7409: from BEN_REGN_F REG2

7405: where REG1.name = c_REG_name
7406: and REG1.business_group_id = c_business_group_id
7407: and REG1.effective_start_date <= c_effective_start_date )
7408: and exists ( select null
7409: from BEN_REGN_F REG2
7410: where REG2.name = c_REG_name
7411: and REG2.business_group_id = c_business_group_id
7412: and REG2.effective_end_date >= c_effective_end_date )
7413: ;

Line 7496: (p_base_table_name => 'BEN_REGN_F',

7492: if c_find_REG_in_target%found then
7493: --
7494: --TEMPIK
7495: l_dt_rec_found := dt_api.check_min_max_dates
7496: (p_base_table_name => 'BEN_REGN_F',
7497: p_base_key_column => 'REGN_ID',
7498: p_base_key_value => l_new_value,
7499: p_from_date => l_min_esd,
7500: p_to_date => l_max_eed );

Line 7560: ben_pd_copy_to_ben_one.ben_chk_col_len('NAME' ,'BEN_REGN_F',l_prefix || r_REG.INFORMATION170 || l_suffix);

7556: end if ;
7557: --
7558: l_ORGANIZATION_ID := get_fk('ORGANIZATION_ID', r_REG.INFORMATION252);
7559: --
7560: ben_pd_copy_to_ben_one.ben_chk_col_len('NAME' ,'BEN_REGN_F',l_prefix || r_REG.INFORMATION170 || l_suffix);
7561: --
7562:
7563: l_effective_date := r_REG.information2;
7564: if ( ben_pd_copy_to_ben_one.g_copy_effective_date is not null and

Line 7571: hr_utility.set_location(' BEN_REGN_F CREATE_REGULATIONS ',20);

7567: end if;
7568:
7569: if l_first_rec and not l_update then
7570: -- Call Create routine.
7571: hr_utility.set_location(' BEN_REGN_F CREATE_REGULATIONS ',20);
7572: BEN_REGULATIONS_API.CREATE_REGULATIONS(
7573: --
7574: P_VALIDATE => false
7575: ,P_EFFECTIVE_DATE => l_effective_date

Line 7640: hr_utility.set_location(' BEN_REGN_F UPDATE_REGULATIONS ',30);

7636: else
7637: --
7638: -- Call Update routine for the pk_id created in prev run .
7639: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
7640: hr_utility.set_location(' BEN_REGN_F UPDATE_REGULATIONS ',30);
7641: BEN_REGULATIONS_API.UPDATE_REGULATIONS(
7642: --
7643: P_VALIDATE => false
7644: ,P_EFFECTIVE_DATE => l_effective_date