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_TWO dependencies on BEN_POPL_ACTN_TYP_F

Line 21186: -- and tr.where_clause = l_BEN_POPL_ACTN_TYP_F

21182: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
21183: pqh_table_route tr
21184: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
21185: and cpe.table_route_id = tr.table_route_id
21186: -- and tr.where_clause = l_BEN_POPL_ACTN_TYP_F
21187: and tr.table_alias = l_table_alias
21188: and cpe.number_of_copies = 1 -- ADDITION
21189: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
21190: order by information1, information2; --added for bug: 5151945

Line 21223: from BEN_POPL_ACTN_TYP_F PAT

21219: c_business_group_id number,
21220: c_new_pk_id number) is
21221: select
21222: PAT.popl_actn_typ_id new_value
21223: from BEN_POPL_ACTN_TYP_F PAT
21224: where NVL(PAT.PGM_ID,-999) = nvl(l_PGM_ID,-999)
21225: and NVL(PAT.PL_ID,-999) = nvl(l_PL_ID ,-999)
21226: and PAT.ACTN_TYP_ID = l_ACTN_TYP_ID
21227: and PAT.business_group_id = c_business_group_id

Line 21235: from BEN_POPL_ACTN_TYP_F PAT1

21231: and effective_end_date ;
21232: --END TEMPIK
21233: /*
21234: and exists ( select null
21235: from BEN_POPL_ACTN_TYP_F PAT1
21236: where NVL(PAT1.PGM_ID,-999) = nvl(l_PGM_ID,-999)
21237: and NVL(PAT1.PL_ID,-999) = nvl(l_PL_ID ,-999)
21238: and PAT1.ACTN_TYP_ID = l_ACTN_TYP_ID
21239: and PAT1.business_group_id = c_business_group_id

Line 21242: from BEN_POPL_ACTN_TYP_F PAT2

21238: and PAT1.ACTN_TYP_ID = l_ACTN_TYP_ID
21239: and PAT1.business_group_id = c_business_group_id
21240: and PAT1.effective_start_date <= c_effective_start_date )
21241: and exists ( select null
21242: from BEN_POPL_ACTN_TYP_F PAT2
21243: where NVL(PAT2.PGM_ID,-999) = nvl(l_PGM_ID,-999)
21244: and NVL(PAT2.PL_ID,-999) = nvl(l_PL_ID ,-999)
21245: and PAT2.ACTN_TYP_ID = l_ACTN_TYP_ID
21246: and PAT2.business_group_id = c_business_group_id

Line 21397: (p_base_table_name => 'BEN_POPL_ACTN_TYP_F',

21393: if c_find_PAT_in_target%found then
21394: --
21395: --TEMPIK
21396: l_dt_rec_found := dt_api.check_min_max_dates
21397: (p_base_table_name => 'BEN_POPL_ACTN_TYP_F',
21398: p_base_key_column => 'POPL_ACTN_TYP_ID',
21399: p_base_key_value => l_new_value,
21400: p_from_date => l_min_esd,
21401: p_to_date => l_max_eed );

Line 21456: hr_utility.set_location(' BEN_POPL_ACTN_TYP_F CREATE_POPL_ACTION_TYPE ',20);

21452: end if;
21453:
21454: if l_first_rec and not l_update then
21455: -- Call Create routine.
21456: hr_utility.set_location(' BEN_POPL_ACTN_TYP_F CREATE_POPL_ACTION_TYPE ',20);
21457: BEN_POPL_ACTION_TYPE_API.CREATE_POPL_ACTION_TYPE(
21458: --
21459: P_VALIDATE => false
21460: ,P_EFFECTIVE_DATE => l_effective_date

Line 21524: hr_utility.set_location(' BEN_POPL_ACTN_TYP_F UPDATE_POPL_ACTION_TYPE ',30);

21520: else
21521: --
21522: -- Call Update routine for the pk_id created in prev run .
21523: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
21524: hr_utility.set_location(' BEN_POPL_ACTN_TYP_F UPDATE_POPL_ACTION_TYPE ',30);
21525: --UPD START
21526: hr_utility.set_location('Before call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
21527: --
21528: if l_update then