APPS.BEN_CWB_RSGN_EMP dependencies on DUAL

Line 741: --select BEN_CWB_WF_NTF_S.NEXTVAL into l_itemkey from dual;

737: l_error varchar2(5000);
738: l_for_period VARCHAR2(30);
739: Begin
740:
741: --select BEN_CWB_WF_NTF_S.NEXTVAL into l_itemkey from dual;
742:
743: hr_utility.set_location('Entering '||l_package ,30);
744:
745: hr_utility.set_location ('Seeded Rsgn Process Name'||l_process_name ,55);

Line 871: select BEN_TRANSACTION_S.NEXTVAL into l_transaction_id from dual;

867: fetch get_top_person_id into l_top_person_id;
868:
869: close get_top_person_id;
870:
871: select BEN_TRANSACTION_S.NEXTVAL into l_transaction_id from dual;
872:
873: insert into ben_transaction(transaction_id,
874: transaction_type,
875: attribute1,

Line 1086: /*select BEN_CWB_WF_NTF_S.NEXTVAL into l_itemkey from dual;*/

1082: l_prop_ws_manager_user varchar2(240);
1083: l_transaction_id number;
1084:
1085: Begin
1086: /*select BEN_CWB_WF_NTF_S.NEXTVAL into l_itemkey from dual;*/
1087: hr_utility.set_location('Entering '||l_package ,30);
1088: wf_engine.createProcess( ItemType => l_itemtype,
1089: ItemKey => l_itemkey,
1090:

Line 1181: select BEN_TRANSACTION_S.NEXTVAL into l_transaction_id from dual;

1177:
1178:
1179: -- Make entry to make notification header
1180:
1181: select BEN_TRANSACTION_S.NEXTVAL into l_transaction_id from dual;
1182:
1183: insert into ben_transaction(transaction_id,
1184: transaction_type,
1185: attribute1,

Line 1294: select BEN_TRANSACTION_S.NEXTVAL into l_transaction_id from dual;

1290: open requestor_name(p_requestor_id);
1291: fetch requestor_name into l_requestor_first_name , l_requestor_last_name ;
1292: close requestor_name;
1293:
1294: select BEN_TRANSACTION_S.NEXTVAL into l_transaction_id from dual;
1295:
1296: insert into ben_transaction(transaction_id,
1297: transaction_type,
1298: attribute1,