DBA Data[Home] [Help]

APPS.JAI_CMN_ST_FORMS_PKG dependencies on JAI_CMN_ST_MATCH_DTLS

Line 616: from JAI_CMN_ST_MATCH_DTLS

612: delete JAI_CMN_ST_FORM_DTLS a
613: where invoice_id = c_invoices.invoice_id
614: and issue_receipt_flag = 'I'
615: and not exists (select '1'
616: from JAI_CMN_ST_MATCH_DTLS
617: where st_hdr_id = a.st_hdr_id
618: and st_dtl_id = a.st_dtl_id
619: );
620:

Line 660: from JAI_CMN_ST_MATCH_DTLS

656: delete JAI_CMN_ST_FORM_DTLS a
657: where invoice_id = c_invoices.invoice_id
658: and issue_receipt_flag = 'I'
659: and not exists (select '1'
660: from JAI_CMN_ST_MATCH_DTLS
661: where st_hdr_id = a.st_hdr_id
662: and st_dtl_id = a.st_dtl_id
663: );
664:

Line 689: from JAI_CMN_ST_MATCH_DTLS

685: delete JAI_CMN_ST_FORM_DTLS a
686: where invoice_id = c_invoices.invoice_id
687: and issue_receipt_flag = 'I'
688: and not exists (select '1'
689: from JAI_CMN_ST_MATCH_DTLS
690: where st_hdr_id = a.st_hdr_id
691: and st_dtl_id = a.st_dtl_id
692: );
693: