APPS.PSB_WS_POS3 dependencies on DUAL

Line 1451: from dual

1447: l_position_exists BOOLEAN := FALSE;
1448:
1449: cursor c_WS is
1450: select 'Exists'
1451: from dual
1452: where exists
1453: (select 1 from PSB_WS_LINES_POSITIONS wlp, PSB_WS_POSITION_LINES wpl
1454: where wlp.worksheet_id = p_worksheet_id
1455: and wpl.position_line_id = wlp.position_line_id

Line 1460: from dual

1456: and wpl.position_id = p_position_id);
1457:
1458: cursor c_BR is
1459: select 'Exists'
1460: from dual
1461: where exists
1462: (select 1 from PSB_BUDGET_REVISION_POS_LINES brpl, PSB_BUDGET_REVISION_POSITIONS brp
1463: where brpl.budget_revision_id = p_worksheet_id
1464: and brp.budget_revision_pos_line_id = brpl.budget_revision_pos_line_id

Line 4781: from dual

4777: -- Check whether Constraints should be applied for specific Service Packages
4778:
4779: cursor c_SP is
4780: select 'x'
4781: from dual
4782: where exists
4783: (select 'Service Package Exists'
4784: from PSB_WS_SUBMIT_SERVICE_PACKAGES
4785: where worksheet_id = p_worksheet_id);