DBA Data[Home] [Help]

APPS.QA_SOLUTION_DISPOSITION_PKG dependencies on DUAL

Line 171: FROM DUAL;

167: l_source_code VARCHAR2(30);
168:
169: CURSOR group_cur IS
170: SELECT WIP_JOB_SCHEDULE_INTERFACE_S.nextval
171: FROM DUAL;
172:
173: -- Bug 3019869. Changed the below cursor to wip_job cursor.
174: -- Records will not reside in WJSI if the MRP Debug mode
175: -- profile option is set to 'No'. kabalakr

Line 613: FROM DUAL;

609: l_txn_date DATE;
610:
611: CURSOR txn_cur IS
612: SELECT wip_transactions_s.nextval
613: FROM DUAL;
614:
615: CURSOR req_cur IS
616: SELECT request_id
617: FROM FND_CONC_REQ_SUMMARY_V

Line 2540: FROM DUAL;

2536: l_arg VARCHAR2(240);
2537:
2538: CURSOR txn_cur IS
2539: SELECT wip_transactions_s.nextval
2540: FROM DUAL;
2541:
2542: CURSOR req_cur IS
2543: SELECT request_id
2544: FROM FND_CONC_REQ_SUMMARY_V

Line 2886: FROM DUAL;

2882:
2883:
2884: CURSOR group_cur IS
2885: SELECT WIP_JOB_SCHEDULE_INTERFACE_S.nextval
2886: FROM DUAL;
2887:
2888: CURSOR job_cur IS
2889: SELECT wip_entity_id
2890: FROM wip_entities

Line 3807: FROM DUAL;

3803:
3804: /*
3805: CURSOR txn_head_seq IS
3806: SELECT mtl_material_transactions_s.nextval
3807: FROM DUAL;
3808: */
3809:
3810: -- We are not translating the Action_Fired value.
3811: -- Hence commenting the below cursor.

Line 4068: from dual

4064: sql_string :=
4065: 'select code
4066: from
4067: (select ''x'' code, ''x'' description
4068: from dual
4069: where 1 = 2
4070: union
4071: select * from
4072: ( '|| sql_string ||