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_PLAN_COPY_LOADER dependencies on PQH_COPY_ENTITY_TXNS_S

Line 218: l_start_with pqh_copy_entity_txns.start_with%type := 'BEN_PDC_TRGT_DTL_PAGE';

214: l_transaction_category_id number(15);
215: l_table_route_id number(15);
216: l_business_group_id number(15);
217: --
218: l_start_with pqh_copy_entity_txns.start_with%type := 'BEN_PDC_TRGT_DTL_PAGE';
219: l_status pqh_copy_entity_txns.status%type := 'IMPORTED';
220: l_old_copy_entity_txn_id number ;
221: l_ovn number ;
222: l_datestamp varchar2(30) := to_char(sysdate,'DD-MON-YYYY HH:MI:SS') ;

Line 219: l_status pqh_copy_entity_txns.status%type := 'IMPORTED';

215: l_table_route_id number(15);
216: l_business_group_id number(15);
217: --
218: l_start_with pqh_copy_entity_txns.start_with%type := 'BEN_PDC_TRGT_DTL_PAGE';
219: l_status pqh_copy_entity_txns.status%type := 'IMPORTED';
220: l_old_copy_entity_txn_id number ;
221: l_ovn number ;
222: l_datestamp varchar2(30) := to_char(sysdate,'DD-MON-YYYY HH:MI:SS') ;
223: --

Line 322: select pqh_copy_entity_txns_s.nextval into l_copy_entity_txn_id

318: fetch c3 into l_business_group_id ;
319: close c3;
320: */
321: --
322: select pqh_copy_entity_txns_s.nextval into l_copy_entity_txn_id
323: from dual ;
324: hr_utility.set_location(' Step 50 ',50);
325: --
326: -- Insert the row into: pqh_copy_entity_txns