APPS.CN_WKSHT_GET_PUB dependencies on DUAL

Line 182: SELECT 'Y' FROM dual WHERE exists

178: FROM cn_payruns WHERE payrun_id = p_payrun_id;
179:
180: -- cursor to check if the worksheet is pre-1158 release.
181: CURSOR view_ced_cur (l_payment_worksheet_id cn_worksheet_qg_dtls.payment_worksheet_id%TYPE) IS
182: SELECT 'Y' FROM dual WHERE exists
183: (SELECT 1 FROM cn_worksheet_qg_dtls
184: WHERE payment_worksheet_id = l_payment_worksheet_id);
185:
186: -- cursor to check if thenote exist

Line 188: SELECT 'Y' FROM dual WHERE exists

184: WHERE payment_worksheet_id = l_payment_worksheet_id);
185:
186: -- cursor to check if thenote exist
187: CURSOR view_notes_cur (l_payment_worksheet_id cn_worksheet_qg_dtls.payment_worksheet_id%TYPE) IS
188: SELECT 'Y' FROM dual WHERE exists
189: (SELECT 1
190: FROM JTF_NOTES_B WHERE SOURCE_OBJECT_CODE = 'CN_PAYMENT_WORKSHEETS'
191: AND SOURCE_OBJECT_ID = l_payment_worksheet_id
192: );

Line 263: SELECT 1 INTO l_tmp FROM dual WHERE exists

259: IF l_tmp = 1 THEN
260: -- Check if login user in payment analyst hierarchy for this
261: -- pay period
262: BEGIN
263: SELECT 1 INTO l_tmp FROM dual WHERE exists
264: (SELECT 1
265: FROM jtf_rs_resource_extns re1,
266: cn_period_statuses pr,
267: jtf_rs_group_usages u1,

Line 377: FROM dual;

373: SELECT substrb(l_select,1,2000),substrb(l_select,2001,2000),
374: p_payrun_id || '*' || c_salesrep_name ||'*'|| c_employee_number ||'*'||
375: c_worksheet_status ||'*'|| c_analyst_name ||'*'|| l_b7 ||'*'|| l_b8
376: ||'*'|| l_b9
377: FROM dual;
378: */
379:
380: OPEN wksht_cur FOR l_select using p_payrun_id,
381: c_salesrep_name, c_employee_number, c_worksheet_status,