DBA Data[Home] [Help]

APPS.IGIRRPI dependencies on DUAL

Line 1995: FROM sys.dual;

1991: l_rail.orig_system_ship_contact_id := pp_sc.ship_to_contact_id;
1992: l_rail.primary_salesrep_id := pp_sc.salesrep_id;
1993: SELECT decode(pp_sc.suppress_inv_print,'Y','PRI','NOT')
1994: INTO l_rail.printing_option
1995: FROM sys.dual;
1996: l_rail.quantity := pp_ld.quantity;
1997: l_rail.set_of_books_id := pp_sc.set_of_books_id;
1998: l_rail.receipt_method_id := pp_sc.receipt_method_id;
1999: l_rail.trx_date := pp_sc.next_due_date;

Line 2094: from sys.dual

2090: / ( to_date(to_char(pp_end_date,DEF_DATE_FORMAT)||END_DATE_TIME,RPI_DATE_FORMAT)
2091: - to_date(to_char(pp_actual_start_date,DEF_DATE_FORMAT)||BEGIN_DATE_TIME,RPI_DATE_FORMAT)
2092: )
2093: into l_factor
2094: from sys.dual
2095: ;
2096: return l_factor;
2097: END Get_Days_Ratio;
2098:

Line 2273: FROM sys.dual ;

2269:
2270: BEGIN
2271: SELECT igi_rpi_generate_s.nextval
2272: INTO l_run_sequence
2273: FROM sys.dual ;
2274: END;
2275:
2276: BEGIN
2277: WriteToLogFile(l_state_level, 'igi.plsql.igirrpi.auto_invoice.Msg3',