APPS.BEN_CWB_RSGN_EMP dependencies on DUAL

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

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

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

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

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

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

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

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

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

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