APPS.PSA_AP_BC_PVT dependencies on DUAL

Line 222: SELECT 'Encumbered line exist' from dual

218:
219: /* Check for a event wheter if there is a line which is encumbered */
220: CURSOR c_exists_encumline (p_event_id NUMBER,
221: p_invoice_id NUMBER) IS
222: SELECT 'Encumbered line exist' from dual
223: WHERE EXISTS
224: (SELECT '1' FROM ap_invoice_distributions_all
225: WHERE bc_event_id = p_event_id
226: AND invoice_id = p_invoice_id

Line 1141: FROM dual;

1137: 'PREPAYMENT','PREPAYMENT',
1138: 'INVOICE')||' '||
1139: decode(p_calling_mode,'CANCEL','CANCELLED','VALIDATED')
1140: INTO l_event_type_code
1141: FROM dual;
1142: END IF;
1143:
1144: psa_utils.debug_other_string(g_state_level,l_api_name,'Event Type Code:'||l_event_type_code );
1145: psa_utils.debug_other_string(g_state_level,l_api_name,'End of procedure get_event_type_code');