APPS.JAI_AR_CR_TRIGGER_PKG dependencies on JAI_CMN_DOCUMENT_TAXES

Line 91: UPDATE jai_cmn_document_taxes

87: SET cash_receipt_id = pr_new.cash_receipt_id,
88: temp_sequence_id = NULL
89: WHERE loc_cash_receipt_id = r_check_tmp_data.loc_cash_receipt_id;
90:
91: UPDATE jai_cmn_document_taxes
92: SET source_doc_id = pr_new.cash_receipt_id,
93: source_doc_line_id = NULL
94: WHERE source_doc_line_id = r_check_tmp_data.loc_cash_receipt_id
95: AND source_table_name = 'JAI_AR_CASH_RECEIPTS_ALL';

Line 158: DELETE jai_cmn_document_taxes

154: pr_old.reversal_date IS NULL AND pr_new.reversal_date is NOT NULL THEN
155:
156: IF NVL(r_ar_cash_receipts.confirm_flag,'N') IN ('N','I') THEN
157:
158: DELETE jai_cmn_document_taxes
159: WHERE source_table_name = 'JAI_AR_CASH_RECEIPTS_ALL'
160: AND source_doc_id = pr_old.cash_receipt_id;
161:
162: DELETE jai_ar_cash_receipts_all

Line 220: DELETE jai_cmn_document_taxes

216: FETCH c_ar_cash_receipts INTO r_ar_cash_receipts;
217: CLOSE c_ar_cash_receipts;
218:
219: IF NVL(r_ar_cash_receipts.confirm_flag,'N') IN ('N','I') THEN
220: DELETE jai_cmn_document_taxes
221: WHERE source_table_name = 'JAI_AR_CASH_RECEIPTS_ALL'
222: AND source_doc_id = pr_old.cash_receipt_id;
223:
224: DELETE jai_ar_cash_receipts_all