DBA Data[Home] [Help]

APPS.AP_PURGE_PKG dependencies on ALL_SEQUENCES

Line 607: FROM all_sequences

603: INTO max_chk_id
604: FROM ap_invoice_payments ; */
605: SELECT last_number
606: INTO max_inv_id
607: FROM all_sequences
608: WHERE sequence_owner = l_sch_name
609: AND sequence_name = 'AP_INVOICES_S' ;
610:
611: SELECT last_number

Line 613: FROM all_sequences

609: AND sequence_name = 'AP_INVOICES_S' ;
610:
611: SELECT last_number
612: INTO max_chk_id
613: FROM all_sequences
614: WHERE sequence_owner = l_sch_name
615: AND sequence_name = 'AP_CHECKS_S' ;
616:
617: IF ( max_inv_id > 2147483647 OR

Line 3580: FROM all_sequences

3576: INTO max_chk_id
3577: FROM ap_invoice_payments ; */
3578: SELECT last_number
3579: INTO max_inv_id
3580: FROM all_sequences
3581: WHERE sequence_owner = l_sch_name
3582: AND sequence_name = 'AP_INVOICES_S' ;
3583:
3584: SELECT last_number

Line 3586: FROM all_sequences

3582: AND sequence_name = 'AP_INVOICES_S' ;
3583:
3584: SELECT last_number
3585: INTO max_chk_id
3586: FROM all_sequences
3587: WHERE sequence_owner = l_sch_name
3588: AND sequence_name = 'AP_CHECKS_S' ;
3589:
3590: IF ( max_inv_id > 2147483647 OR