DBA Data[Home] [Help]

APPS.CSTPOYLD dependencies on DUAL

Line 519: FROM dual;

515: x_statement := 60;
516:
517: SELECT wip_transactions_s.nextval
518: INTO x_transaction_id
519: FROM dual;
520:
521: if (l_debug = 'Y') then
522: fnd_file.put_line(fnd_file.log,'Inserting into WT transaction : '||to_char(x_transaction_id));
523: end if;

Line 725: FROM dual;

721: x_statement := 90;
722:
723: SELECT mtl_material_transactions_s.nextval
724: INTO x_transaction_id
725: FROM dual;
726:
727: /* Bug #2840690. Get primary UOM of assembly */
728: SELECT muom.uom_code
729: INTO l_uom

Line 967: FROM dual;

963: x_tl_scrap_out + decode(NVL(x_min_acct_unit, 0), 0, ROUND(x_net_reversal, x_precision),
964: ROUND (x_net_reversal / x_min_acct_unit) * x_min_acct_unit)
965: INTO x_tl_scrap_in,
966: x_tl_scrap_out
967: FROM dual;
968:
969: EXCEPTION
970: WHEN EST_ACCT_NOT_FOUND THEN
971: x_tl_scrap_in := 0;