APPS.OE_PREPAYMENT_PVT dependencies on DUAL

Line 3030: FROM dual

3026: -- if there exists one receipt that is neither REMITTED nor CLEARED.
3027: --bug5394265 Need to check that receipts other than those for Credit Cards need to be 'CLEARED' for the payment to be assured.
3028: l_sql_stmt := '
3029: SELECT ''Y''
3030: FROM dual
3031: WHERE
3032: (
3033: EXISTS
3034: (

Line 3182: select to_number(oe_sys_parameters.value ('SET_OF_BOOKS_ID')) into l_sob_id from dual;

3178: ,p_change_sequence => l_change_sequence
3179: ,p_source_document_type_id => l_source_document_type_id
3180: ,p_source_document_id => l_source_document_id);
3181:
3182: select to_number(oe_sys_parameters.value ('SET_OF_BOOKS_ID')) into l_sob_id from dual;
3183:
3184: -- MOAC changes
3185: -- select fnd_profile.value('ORG_ID') into l_organization_id from DUAL;
3186: SELECT org_id

Line 3185: -- select fnd_profile.value('ORG_ID') into l_organization_id from DUAL;

3181:
3182: select to_number(oe_sys_parameters.value ('SET_OF_BOOKS_ID')) into l_sob_id from dual;
3183:
3184: -- MOAC changes
3185: -- select fnd_profile.value('ORG_ID') into l_organization_id from DUAL;
3186: SELECT org_id
3187: INTO l_organization_id
3188: FROM oe_order_headers_all
3189: WHERE header_id = p_header_id;