APPS.JAI_AR_CR_TRIGGER_PKG dependencies on JAI_CMN_DOCUMENT_TAXES

Line 67: UPDATE jai_cmn_document_taxes

63: SET cash_receipt_id = pr_new.cash_receipt_id,
64: temp_sequence_id = NULL
65: WHERE loc_cash_receipt_id = r_check_tmp_data.loc_cash_receipt_id;
66:
67: UPDATE jai_cmn_document_taxes
68: SET source_doc_id = pr_new.cash_receipt_id,
69: source_doc_line_id = NULL
70: WHERE source_doc_line_id = r_check_tmp_data.loc_cash_receipt_id
71: AND source_table_name = 'JAI_AR_CASH_RECEIPTS_ALL';

Line 134: DELETE jai_cmn_document_taxes

130: pr_old.reversal_date IS NULL AND pr_new.reversal_date is NOT NULL THEN
131:
132: IF NVL(r_ar_cash_receipts.confirm_flag,'N') IN ('N','I') THEN
133:
134: DELETE jai_cmn_document_taxes
135: WHERE source_table_name = 'JAI_AR_CASH_RECEIPTS_ALL'
136: AND source_doc_id = pr_old.cash_receipt_id;
137:
138: DELETE jai_ar_cash_receipts_all

Line 195: DELETE jai_cmn_document_taxes

191: FETCH c_ar_cash_receipts INTO r_ar_cash_receipts;
192: CLOSE c_ar_cash_receipts;
193:
194: IF NVL(r_ar_cash_receipts.confirm_flag,'N') IN ('N','I') THEN
195: DELETE jai_cmn_document_taxes
196: WHERE source_table_name = 'JAI_AR_CASH_RECEIPTS_ALL'
197: AND source_doc_id = pr_old.cash_receipt_id;
198:
199: DELETE jai_ar_cash_receipts_all