APPS.OE_PREPAYMENT_PVT dependencies on DUAL

Line 3164: FROM dual

3160: -- if there exists one receipt that is neither REMITTED nor CLEARED.
3161: --bug5394265 Need to check that receipts other than those for Credit Cards need to be 'CLEARED' for the payment to be assured.
3162: l_sql_stmt := '
3163: SELECT ''Y''
3164: FROM dual
3165: WHERE
3166: (
3167: EXISTS
3168: (

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

3312: ,p_change_sequence => l_change_sequence
3313: ,p_source_document_type_id => l_source_document_type_id
3314: ,p_source_document_id => l_source_document_id);
3315:
3316: select to_number(oe_sys_parameters.value ('SET_OF_BOOKS_ID')) into l_sob_id from dual;
3317:
3318: -- MOAC changes
3319: -- select fnd_profile.value('ORG_ID') into l_organization_id from DUAL;
3320: SELECT org_id

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

3315:
3316: select to_number(oe_sys_parameters.value ('SET_OF_BOOKS_ID')) into l_sob_id from dual;
3317:
3318: -- MOAC changes
3319: -- select fnd_profile.value('ORG_ID') into l_organization_id from DUAL;
3320: SELECT org_id
3321: INTO l_organization_id
3322: FROM oe_order_headers_all
3323: WHERE header_id = p_header_id;