APPS.JAI_CMN_ST_FORMS_PKG dependencies on JAI_CMN_ST_MATCH_DTLS

Line 506: from JAI_CMN_ST_MATCH_DTLS

502: delete JAI_CMN_ST_FORM_DTLS a
503: where invoice_id = c_invoices.invoice_id
504: and issue_receipt_flag = 'I'
505: and not exists (select '1'
506: from JAI_CMN_ST_MATCH_DTLS
507: where st_hdr_id = a.st_hdr_id
508: and st_dtl_id = a.st_dtl_id
509: );
510:

Line 550: from JAI_CMN_ST_MATCH_DTLS

546: delete JAI_CMN_ST_FORM_DTLS a
547: where invoice_id = c_invoices.invoice_id
548: and issue_receipt_flag = 'I'
549: and not exists (select '1'
550: from JAI_CMN_ST_MATCH_DTLS
551: where st_hdr_id = a.st_hdr_id
552: and st_dtl_id = a.st_dtl_id
553: );
554:

Line 579: from JAI_CMN_ST_MATCH_DTLS

575: delete JAI_CMN_ST_FORM_DTLS a
576: where invoice_id = c_invoices.invoice_id
577: and issue_receipt_flag = 'I'
578: and not exists (select '1'
579: from JAI_CMN_ST_MATCH_DTLS
580: where st_hdr_id = a.st_hdr_id
581: and st_dtl_id = a.st_dtl_id
582: );
583: