APPS.JE_ZZ_AUDIT_AP_PKG dependencies on JG_ZZ_VAT_TRX_GT

Line 77: FROM jg_zz_vat_trx_gt;

73:
74:
75: CURSOR company_info IS
76: SELECT DISTINCT jg_info_v5
77: FROM jg_zz_vat_trx_gt;
78:
79: CURSOR C_GENERIC(p_start_date DATE, p_end_date DATE) IS
80: SELECT SUBSTR(ven.vendor_name, 1, 10) ven_name
81: ,SUBSTR(ven.segment1, 1, 8) ven_no

Line 222: FROM JG_ZZ_VAT_TRX_GT

218: ,jg_info_n10 l_real_inv_amt
219: ,jg_info_n11 l_txbl_disc_amt
220: ,jg_info_n12 l_payment_amt
221: ,jg_info_d2 check_void_date
222: FROM JG_ZZ_VAT_TRX_GT
223: WHERE jg_info_v30='JEFRTXDC'
224: GROUP BY jg_info_n8
225: ,jg_info_n7
226: ,jg_info_n1

Line 520: INSERT INTO JG_ZZ_VAT_TRX_GT

516:
517:
518:
519:
520: INSERT INTO JG_ZZ_VAT_TRX_GT
521: (
522: jg_info_n1
523: ,jg_info_v1
524: ,jg_info_v2

Line 626: INTO jg_zz_vat_trx_gt(

622: -- negative for this line
623: --4. Payment amount will be null for a DEB/M invoice
624: --5. A DEB/M prepayment invoice will be picked up if it satisfies conditions 1
625: INSERT
626: INTO jg_zz_vat_trx_gt(
627: jg_info_v2 --ven_name
628: , jg_info_v3 --ven_no
629: , jg_info_n18 --recoverable_tax_amount
630: , jg_info_n2 --rec_per

Line 724: INTO jg_zz_vat_trx_gt(

720: -- line will appear on the invoice with amounts equal to the applied prepayment
721: -- amounts. This is necessary as tax on prepayment has already be reported (in Case 3).
722: -- Case 4 is handled in this query
723: INSERT
724: INTO jg_zz_vat_trx_gt(
725: jg_info_v2 --ven_name
726: , jg_info_v3 --ven_no
727: , jg_info_n18 --recoverable_tax_amount
728: , jg_info_n2 --rec_per

Line 818: INTO jg_zz_vat_trx_gt(

814: --7. Voiding a payment will result in an additional negative line being
815: -- picked up for the invoice. The payment amount, taxable amount and
816: -- recoverable tax amount will be negative for this line
817: INSERT
818: INTO jg_zz_vat_trx_gt(
819: jg_info_v2 --ven_name
820: , jg_info_v3 --ven_no
821: , jg_info_n18 --recoverable_tax_amount
822: , jg_info_n2 --rec_per

Line 929: INTO jg_zz_vat_trx_gt(

925: --
926: -- The first insert is for the positive line, the second insert
927: -- is for the negative line
928: INSERT
929: INTO jg_zz_vat_trx_gt(
930: jg_info_v2 --ven_name
931: , jg_info_v3 --ven_no
932: , jg_info_n18 --recoverable_tax_amount
933: , jg_info_n2 --rec_per

Line 1010: INTO jg_zz_vat_trx_gt(

1006: dis.amount,
1007: inv.cancelled_date,
1008: inv.exchange_rate;
1009: INSERT
1010: INTO jg_zz_vat_trx_gt(
1011: jg_info_v2 --ven_name
1012: , jg_info_v3 --ven_no
1013: , jg_info_n18 --recoverable_tax_amount
1014: , jg_info_n2 --rec_per

Line 1104: INTO jg_zz_vat_trx_gt(

1100: -- taxable amount will be prorated based on prepayment amount
1101: -- Taxable amount = (Original Taxable Amount)*(prepayment Amount/Invoice Amount)
1102: -- Recoverable tax amount = (Original Recoveral tax amount)*(prepayment Amount/Invoice Amount)
1103: INSERT
1104: INTO jg_zz_vat_trx_gt(
1105: jg_info_v2 --ven_name
1106: , jg_info_v3 --ven_no
1107: , jg_info_n18 --recoverable_tax_amount
1108: , jg_info_n2 --rec_per

Line 1211: UPDATE jg_zz_vat_trx_gt

1207: AND fif.id_flex_num = g_struct_num
1208: AND ffv.flex_value = c_balancing_segment.jg_info_v5
1209: AND ffv.flex_value_set_id = fif.flex_value_set_id;
1210:
1211: UPDATE jg_zz_vat_trx_gt
1212: SET jg_info_v10 = l_company_desc
1213: WHERE jg_info_v5 = c_balancing_segment.jg_info_v5;
1214: END LOOP;
1215: CLOSE company_info;

Line 1250: INSERT INTO JG_ZZ_VAT_TRX_GT

1246:
1247: l_acc_no := get_accounting_segment(l_tax_ccid);
1248: l_company := get_balancing_segment(l_trx_ccid, l_company_desc);
1249:
1250: INSERT INTO JG_ZZ_VAT_TRX_GT
1251: (jg_info_v1 --ven_name
1252: ,jg_info_v2 --ven_no
1253: ,jg_info_v3 --inv_type
1254: ,jg_info_n1 --tax_amt