DBA Data[Home] [Help]

APPS.JAI_AP_ILA_TRIGGER_PKG dependencies on DUAL

Line 461: FROM DUAL

457: THEN
458:
459: SELECT 'Y'
460: INTO lv_rcpt_tax_exists
461: FROM DUAL
462: WHERE EXISTS (SELECT '1'
463: FROM JAI_RCV_LINE_TAXES
464: WHERE shipment_line_id IN (SELECT shipment_line_id
465: FROM RCV_TRANSACTIONS

Line 476: FROM DUAL

472: THEN
473:
474: SELECT 'Y'
475: INTO lv_po_tax_exists
476: FROM DUAL
477: WHERE EXISTS (SELECT '1'
478: FROM JAI_PO_TAXES
479: WHERE po_header_id = pr_new.po_header_id
480: AND po_line_id = pr_new.po_line_id);