eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JG_ZZ_SUMMARY_ALL_PKG dependencies on JG_ZZ_VAT_REP_STATUS

Line 174: JG_ZZ_VAT_REP_STATUS JZVRS

170: IS
171: SELECT
172: JZVRS.REPORTING_STATUS_ID
173: FROM
174: JG_ZZ_VAT_REP_STATUS JZVRS
175: WHERE
176: JZVRS.SOURCE='AP'
177: AND JZVRS.VAT_REPORTING_ENTITY_ID = P_VAT_REP_ENTITY_ID
178: AND JZVRS.TAX_CALENDAR_PERIOD = P_PERIOD;

Line 186: JG_ZZ_VAT_REP_STATUS JZVRS

182: SELECT
183: JLMT.VAT_AGGREGATE_LIMIT_AMT
184: FROM
185: JE_IL_VAT_LIMITS JLMT,
186: JG_ZZ_VAT_REP_STATUS JZVRS
187: WHERE
188: JZVRS.VAT_REPORTING_ENTITY_ID = P_VAT_REP_ENTITY_ID
189: AND JZVRS.TAX_CALENDAR_PERIOD = P_PERIOD
190: AND JZVRS.TAX_CALENDAR_NAME = JLMT.PERIOD_SET_NAME

Line 729: , Jg_Zz_Vat_Rep_Status Jzvrs

725: , jg_zz_vat_alloc_rules alr
726: , jg_zz_vat_trx_details JG
727: , fnd_lookup_values TLOOKUP
728: , fnd_lookup_values TBLLOOKUP
729: , Jg_Zz_Vat_Rep_Status Jzvrs
730: , ZX_lines zx
731: WHERE
732: NVL(AL.taxable_box, '99') = TBLLOOKUP.lookup_code
733: AND NVL(AL.tax_box, '99') = TLOOKUP.lookup_code

Line 780: period_year jg_zz_vat_rep_status.tax_calendar_year%type --NUMBER

776: */
777:
778: TYPE r_box_amounts IS RECORD
779: (
780: period_year jg_zz_vat_rep_status.tax_calendar_year%type --NUMBER
781: ,period_name jg_zz_vat_rep_status.tax_calendar_period%type --VARCHAR2(10)
782: ,tax_box jg_zz_vat_box_allocs.tax_box%type
783: ,taxable_box jg_zz_vat_box_allocs.taxable_box%type --VARCHAR2(10)
784: ,taxablebox_description fnd_lookup_values.description%type --VARCHAR2(250)

Line 781: ,period_name jg_zz_vat_rep_status.tax_calendar_period%type --VARCHAR2(10)

777:
778: TYPE r_box_amounts IS RECORD
779: (
780: period_year jg_zz_vat_rep_status.tax_calendar_year%type --NUMBER
781: ,period_name jg_zz_vat_rep_status.tax_calendar_period%type --VARCHAR2(10)
782: ,tax_box jg_zz_vat_box_allocs.tax_box%type
783: ,taxable_box jg_zz_vat_box_allocs.taxable_box%type --VARCHAR2(10)
784: ,taxablebox_description fnd_lookup_values.description%type --VARCHAR2(250)
785: ,taxbox_description fnd_lookup_values.description%type --VARCHAR2(250)

Line 809: period_year jg_zz_vat_rep_status.tax_calendar_year%type --NUMBER

805: );
806:
807: TYPE r_vatbox_amounts IS RECORD
808: (
809: period_year jg_zz_vat_rep_status.tax_calendar_year%type --NUMBER
810: ,period_name jg_zz_vat_rep_status.tax_calendar_period%type --VARCHAR2(10)
811: ,vat_report_box jg_zz_vat_box_allocs.tax_box%type --VARCHAR2(10)
812: ,vat_box_description fnd_lookup_values.description%type --VARCHAR2(250)
813: ,source jg_zz_vat_trx_details.extract_source_ledger%type -- VARCHAR2(10)

Line 810: ,period_name jg_zz_vat_rep_status.tax_calendar_period%type --VARCHAR2(10)

806:
807: TYPE r_vatbox_amounts IS RECORD
808: (
809: period_year jg_zz_vat_rep_status.tax_calendar_year%type --NUMBER
810: ,period_name jg_zz_vat_rep_status.tax_calendar_period%type --VARCHAR2(10)
811: ,vat_report_box jg_zz_vat_box_allocs.tax_box%type --VARCHAR2(10)
812: ,vat_box_description fnd_lookup_values.description%type --VARCHAR2(250)
813: ,source jg_zz_vat_trx_details.extract_source_ledger%type -- VARCHAR2(10)
814: ,document_seq_name jg_zz_vat_trx_details.doc_seq_name%type -- VARCHAR2(60)

Line 1112: , jg_zz_vat_rep_status JZVRS

1108: , ALLOCBOX.tax_recoverable_flag TAX_RECOVERABLE_FLAG
1109: , JG.extract_source_ledger EXTRACT_SOURCE_LEDGER
1110: , AllOCBOX.allocation_rule_id ALLOCATION_RULE_ID
1111: FROM jg_zz_vat_trx_details JG
1112: , jg_zz_vat_rep_status JZVRS
1113: , jg_zz_vat_box_allocs AllOCBOX
1114: , jg_zz_vat_alloc_rules ALLOCRUL
1115: WHERE JZVRS.reporting_status_id = JG.reporting_status_id
1116: AND JZVRS.vat_reporting_entity_id = p_vat_rep_entity_id

Line 1343: , jg_zz_vat_rep_status JZVRS

1339: 101,JG.prl_no) TAX_CLASS
1340: ,JG.extract_source_ledger EXTRACT_SOURCE_LEDGER
1341: ,JG.reporting_code REPORTING_CODE
1342: FROM jg_zz_vat_trx_details JG
1343: , jg_zz_vat_rep_status JZVRS
1344: , jg_zz_vat_box_allocs AL
1345: WHERE decode(JG.extract_source_ledger,'AP',NVL(JG.tax_recoverable_flag,'N'),'Y') ='Y' -- Bug 5561879
1346: AND JZVRS.reporting_status_id = JG.reporting_status_id
1347: AND AL.vat_transaction_id = JG.vat_transaction_id

Line 1492: , jg_zz_vat_rep_status JZVRS

1488: , applied_to_trx_id APPLIED_TO_TRX_ID -- bug 12691340
1489: , JZVRS.mapping_vat_rep_entity_id MAPPING_VAT_REP_ENTITY_ID
1490: FROM
1491: jg_zz_vat_trx_details JG
1492: , jg_zz_vat_rep_status JZVRS
1493: WHERE JZVRS.reporting_status_id = JG.reporting_status_id
1494: AND JZVRS.vat_reporting_entity_id = p_vat_rep_entity_id
1495: AND JZVRS.tax_calendar_period = p_period ;
1496:

Line 1502: jg_zz_vat_rep_status JZVRS

1498: CURSOR c_get_last_process_date IS
1499: SELECT
1500: max(JZVRS.period_end_date)
1501: FROM
1502: jg_zz_vat_rep_status JZVRS
1503: WHERE
1504: JZVRS.vat_reporting_entity_id = p_vat_rep_entity_id
1505: AND JZVRS.period_end_date <
1506: (SELECT max(JZVRS1.period_end_date)

Line 1507: FROM jg_zz_vat_rep_status JZVRS1

1503: WHERE
1504: JZVRS.vat_reporting_entity_id = p_vat_rep_entity_id
1505: AND JZVRS.period_end_date <
1506: (SELECT max(JZVRS1.period_end_date)
1507: FROM jg_zz_vat_rep_status JZVRS1
1508: WHERE JZVRS1.tax_calendar_period = p_period
1509: AND JZVRS1.vat_reporting_entity_id = p_vat_rep_entity_id
1510: --AND JZVRS1.final_reporting_status_flag = 'S'
1511: )

Line 1518: FROM jg_zz_vat_rep_status JZVRS

1514:
1515: CURSOR c_get_balance ( pn_last_process_date DATE) IS
1516: SELECT
1517: JZVRS.CREDIT_BALANCE_AMT
1518: FROM jg_zz_vat_rep_status JZVRS
1519: WHERE JZVRS.vat_reporting_entity_id = p_vat_rep_entity_id
1520: AND JZVRS.tax_calendar_period =( SELECT JZVRS1.tax_calendar_period
1521: FROM jg_zz_vat_rep_status JZVRS1
1522: WHERE

Line 1521: FROM jg_zz_vat_rep_status JZVRS1

1517: JZVRS.CREDIT_BALANCE_AMT
1518: FROM jg_zz_vat_rep_status JZVRS
1519: WHERE JZVRS.vat_reporting_entity_id = p_vat_rep_entity_id
1520: AND JZVRS.tax_calendar_period =( SELECT JZVRS1.tax_calendar_period
1521: FROM jg_zz_vat_rep_status JZVRS1
1522: WHERE
1523: JZVRS1.vat_reporting_entity_id = p_vat_rep_entity_id
1524: AND TRUNC(JZVRS1.period_end_date) = pn_last_process_date
1525: AND ROWNUM =1)

Line 1688: ,JG_ZZ_VAT_REP_STATUS JZVRS

1684: ,SUM(NVL(JZVTD.TAX_AMT_FUNCL_CURR,JZVTD.TAX_AMT)) VAT_AMOUNT_STANDARD
1685: ,SUM(NVL(JZVTD.TAXABLE_AMT_FUNCL_CURR, JZVTD.TAXABLE_AMT)) TAXABLE_AMOUNT_STANDARD
1686: FROM
1687: JG_ZZ_VAT_TRX_DETAILS JZVTD
1688: ,JG_ZZ_VAT_REP_STATUS JZVRS
1689: ,AP_INVOICES_ALL AP
1690: WHERE
1691: JZVRS.VAT_REPORTING_ENTITY_ID in
1692: (p_vat_rep_entity_id, p_vat_rep_entity_id2,

Line 1737: JG_ZZ_VAT_REP_STATUS JZVRS,

1733: TO_DATE(APINVL.GLOBAL_ATTRIBUTE13, 'DD-MM-RRRR')),'RRRRMMDD') IMP_DOC_DATE_IMPORT,
1734: SUM(NVL(JZVTD.TAX_AMT_FUNCL_CURR,JZVTD.TAX_AMT)) VAT_AMOUNT_IMPORT,
1735: SUM(NVL(JZVTD.TAXABLE_AMT_FUNCL_CURR, JZVTD.TAXABLE_AMT)) TAXABLE_AMOUNT_IMPORT
1736: FROM JG_ZZ_VAT_TRX_DETAILS JZVTD,
1737: JG_ZZ_VAT_REP_STATUS JZVRS,
1738: AP_INVOICES_ALL APINV,
1739: AP_INVOICE_LINES_ALL APINVL,
1740: ZX_LINES ZXL
1741: WHERE JZVRS.SOURCE = 'AP'

Line 1789: JG_ZZ_VAT_REP_STATUS JZVRS,

1785: JZVTD.TRX_ID TRX_ID,
1786: SUM(NVL(JZVTD.TAX_AMT_FUNCL_CURR,JZVTD.TAX_AMT)) VAT_AMOUNT,
1787: SUM(NVL(JZVTD.TAXABLE_AMT_FUNCL_CURR, JZVTD.TAXABLE_AMT)) TAXABLE_AMOUNT
1788: FROM JG_ZZ_VAT_TRX_DETAILS JZVTD,
1789: JG_ZZ_VAT_REP_STATUS JZVRS,
1790: AP_INVOICES_ALL APINV
1791: WHERE JZVRS.SOURCE = 'AP'
1792: AND JZVRS.VAT_REPORTING_ENTITY_ID in
1793: (p_vat_rep_entity_id, p_vat_rep_entity_id2,

Line 1800: FROM JG_ZZ_VAT_REP_STATUS JZVRS

1796: p_vat_rep_entity_id7, p_vat_rep_entity_id8,
1797: p_vat_rep_entity_id9, p_vat_rep_entity_id10)
1798: AND JZVTD.IL_VAT_REP_STATUS_ID in (
1799: SELECT JZVRS.REPORTING_STATUS_ID
1800: FROM JG_ZZ_VAT_REP_STATUS JZVRS
1801: WHERE JZVRS.SOURCE='AP'
1802: AND JZVRS.VAT_REPORTING_ENTITY_ID in (
1803: p_vat_rep_entity_id, p_vat_rep_entity_id2,
1804: p_vat_rep_entity_id3, p_vat_rep_entity_id4,

Line 1838: JG_ZZ_VAT_REP_STATUS JZVRS,

1834: DECODE(JZVTD.REPORTING_CODE, 'VAT-Y', 0, SUM(NVL(JZVTD.TAX_AMT_FUNCL_CURR, JZVTD.TAX_AMT))) VAT_AMOUNT,
1835: SUM(NVL(JZVTD.TAXABLE_AMT_FUNCL_CURR, JZVTD.TAXABLE_AMT)) TAXABLE_AMOUNT
1836: FROM
1837: JG_ZZ_VAT_TRX_DETAILS JZVTD,
1838: JG_ZZ_VAT_REP_STATUS JZVRS,
1839: RA_CUSTOMER_TRX_ALL AR,
1840: RA_CUSTOMER_TRX_LINES_ALL ARL
1841: WHERE
1842: JZVRS.REPORTING_STATUS_ID = JZVTD.REPORTING_STATUS_ID

Line 1884: JG_ZZ_VAT_REP_STATUS JZVRS,

1880: DECODE(JZVTD.REPORTING_CODE, 'VAT-S', SUM(NVL(JZVTD.TAX_AMT_FUNCL_CURR, JZVTD.TAX_AMT)) , 0) VAT_AMOUNT,
1881: SUM(NVL(JZVTD.TAXABLE_AMT_FUNCL_CURR, JZVTD.TAXABLE_AMT)) TAXABLE_AMOUNT
1882: FROM
1883: JG_ZZ_VAT_TRX_DETAILS JZVTD,
1884: JG_ZZ_VAT_REP_STATUS JZVRS,
1885: RA_CUSTOMER_TRX_ALL AR
1886: WHERE
1887: JZVRS.REPORTING_STATUS_ID = JZVTD.REPORTING_STATUS_ID
1888: AND JZVRS.SOURCE = 'AR'

Line 1927: JG_ZZ_VAT_REP_STATUS JZVRS,

1923: 'VAT-S', SUM(NVL(JZVTD.TAX_AMT_FUNCL_CURR, JZVTD.TAX_AMT)), 0) VAT_AMOUNT,
1924: SUM(NVL(JZVTD.TAXABLE_AMT_FUNCL_CURR, JZVTD.TAXABLE_AMT)) TAXABLE_AMOUNT
1925: FROM
1926: JG_ZZ_VAT_TRX_DETAILS JZVTD,
1927: JG_ZZ_VAT_REP_STATUS JZVRS,
1928: RA_CUSTOMER_TRX_ALL AR
1929: WHERE
1930: JZVRS.REPORTING_STATUS_ID = JZVTD.REPORTING_STATUS_ID
1931: AND JZVRS.SOURCE = 'AR'

Line 1975: JG_ZZ_VAT_REP_STATUS JZVRS,

1971: SUM(NVL(JZVTD.TAX_AMT_FUNCL_CURR, JZVTD.TAX_AMT)) VAT_AMOUNT,
1972: SUM(NVL(JZVTD.TAXABLE_AMT_FUNCL_CURR, JZVTD.TAXABLE_AMT)) TAXABLE_AMOUNT
1973: FROM
1974: JG_ZZ_VAT_TRX_DETAILS JZVTD,
1975: JG_ZZ_VAT_REP_STATUS JZVRS,
1976: RA_CUSTOMER_TRX_ALL AR
1977: WHERE
1978: JZVRS.REPORTING_STATUS_ID = JZVTD.REPORTING_STATUS_ID
1979: AND JZVRS.SOURCE = 'AR'

Line 2027: FROM JG_ZZ_VAT_REP_STATUS

2023:
2024: BEGIN
2025: SELECT REPORTING_STATUS_ID
2026: INTO l_rep_status
2027: FROM JG_ZZ_VAT_REP_STATUS
2028: WHERE SOURCE='AP'
2029: AND VAT_REPORTING_ENTITY_ID = P_VAT_REP_ENTITY_ID
2030: AND TAX_CALENDAR_PERIOD = P_PERIOD;
2031: EXCEPTION

Line 2042: FROM JG_ZZ_VAT_REP_STATUS

2038:
2039: BEGIN
2040: SELECT REPORTING_STATUS_ID
2041: INTO l_rep_status
2042: FROM JG_ZZ_VAT_REP_STATUS
2043: WHERE SOURCE='AP'
2044: AND VAT_REPORTING_ENTITY_ID = P_VAT_REP_ENTITY_ID2
2045: AND TAX_CALENDAR_PERIOD = P_PERIOD;
2046: EXCEPTION

Line 2058: FROM JG_ZZ_VAT_REP_STATUS

2054:
2055: BEGIN
2056: SELECT REPORTING_STATUS_ID
2057: INTO l_rep_status
2058: FROM JG_ZZ_VAT_REP_STATUS
2059: WHERE SOURCE='AP'
2060: AND VAT_REPORTING_ENTITY_ID = P_VAT_REP_ENTITY_ID3
2061: AND TAX_CALENDAR_PERIOD = P_PERIOD;
2062: EXCEPTION

Line 2074: FROM JG_ZZ_VAT_REP_STATUS

2070:
2071: BEGIN
2072: SELECT REPORTING_STATUS_ID
2073: INTO l_rep_status
2074: FROM JG_ZZ_VAT_REP_STATUS
2075: WHERE SOURCE='AP'
2076: AND VAT_REPORTING_ENTITY_ID = P_VAT_REP_ENTITY_ID4
2077: AND TAX_CALENDAR_PERIOD = P_PERIOD;
2078: EXCEPTION

Line 2090: FROM JG_ZZ_VAT_REP_STATUS

2086:
2087: BEGIN
2088: SELECT REPORTING_STATUS_ID
2089: INTO l_rep_status
2090: FROM JG_ZZ_VAT_REP_STATUS
2091: WHERE SOURCE='AP'
2092: AND VAT_REPORTING_ENTITY_ID = P_VAT_REP_ENTITY_ID5
2093: AND TAX_CALENDAR_PERIOD = P_PERIOD;
2094: EXCEPTION

Line 2106: FROM JG_ZZ_VAT_REP_STATUS

2102:
2103: BEGIN
2104: SELECT REPORTING_STATUS_ID
2105: INTO l_rep_status
2106: FROM JG_ZZ_VAT_REP_STATUS
2107: WHERE SOURCE='AP'
2108: AND VAT_REPORTING_ENTITY_ID = P_VAT_REP_ENTITY_ID6
2109: AND TAX_CALENDAR_PERIOD = P_PERIOD;
2110: EXCEPTION

Line 2122: FROM JG_ZZ_VAT_REP_STATUS

2118:
2119: BEGIN
2120: SELECT REPORTING_STATUS_ID
2121: INTO l_rep_status
2122: FROM JG_ZZ_VAT_REP_STATUS
2123: WHERE SOURCE='AP'
2124: AND VAT_REPORTING_ENTITY_ID = P_VAT_REP_ENTITY_ID7
2125: AND TAX_CALENDAR_PERIOD = P_PERIOD;
2126: EXCEPTION

Line 2138: FROM JG_ZZ_VAT_REP_STATUS

2134:
2135: BEGIN
2136: SELECT REPORTING_STATUS_ID
2137: INTO l_rep_status
2138: FROM JG_ZZ_VAT_REP_STATUS
2139: WHERE SOURCE='AP'
2140: AND VAT_REPORTING_ENTITY_ID = P_VAT_REP_ENTITY_ID8
2141: AND TAX_CALENDAR_PERIOD = P_PERIOD;
2142: EXCEPTION

Line 2154: FROM JG_ZZ_VAT_REP_STATUS

2150:
2151: BEGIN
2152: SELECT REPORTING_STATUS_ID
2153: INTO l_rep_status
2154: FROM JG_ZZ_VAT_REP_STATUS
2155: WHERE SOURCE='AP'
2156: AND VAT_REPORTING_ENTITY_ID = P_VAT_REP_ENTITY_ID9
2157: AND TAX_CALENDAR_PERIOD = P_PERIOD;
2158: EXCEPTION

Line 2170: FROM JG_ZZ_VAT_REP_STATUS

2166:
2167: BEGIN
2168: SELECT REPORTING_STATUS_ID
2169: INTO l_rep_status
2170: FROM JG_ZZ_VAT_REP_STATUS
2171: WHERE SOURCE='AP'
2172: AND VAT_REPORTING_ENTITY_ID = P_VAT_REP_ENTITY_ID10
2173: AND TAX_CALENDAR_PERIOD = P_PERIOD;
2174: EXCEPTION

Line 2192: JG_ZZ_VAT_REP_STATUS STA

2188: TO_CHAR(sta.period_end_date,'RRRRMMDD') LAST_DAY_TAX_PERIOD
2189: INTO var_system_date, var_tax_period, var_last_day_tax_period
2190: FROM
2191: JE_IL_VAT_LIMITS JLMT,
2192: JG_ZZ_VAT_REP_STATUS STA
2193: WHERE
2194: STA.VAT_REPORTING_ENTITY_ID = P_VAT_REP_ENTITY_ID
2195: AND STA.TAX_CALENDAR_PERIOD = p_period
2196: AND JLMT.PERIOD_SET_NAME = STA.TAX_CALENDAR_NAME

Line 2685: FROM JG_ZZ_VAT_REP_STATUS RPS

2681: BEGIN
2682: -- Get the date for the period
2683: SELECT DISTINCT RPS.period_start_date
2684: INTO l_period_date
2685: FROM JG_ZZ_VAT_REP_STATUS RPS
2686: WHERE RPS.TAX_CALENDAR_PERIOD = P_PERIOD
2687: AND RPS.VAT_REPORTING_ENTITY_ID = P_VAT_REP_ENTITY_ID;
2688:
2689: l_starting_limit := 0;

Line 2719: FROM JG_ZZ_VAT_REP_STATUS RPS

2715: BEGIN
2716: -- Get the date for the period
2717: SELECT DISTINCT RPS.period_start_date
2718: INTO l_period_date
2719: FROM JG_ZZ_VAT_REP_STATUS RPS
2720: WHERE RPS.TAX_CALENDAR_PERIOD = P_PERIOD
2721: AND RPS.VAT_REPORTING_ENTITY_ID = P_VAT_REP_ENTITY_ID;
2722:
2723: l_adjustment_limit := 0;

Line 2777: FROM jg_zz_vat_rep_status JZVRS

2773: SELECT
2774: JZVRS.CREDIT_BALANCE_AMT,
2775: JZVRS.FINAL_REPORTING_STATUS_FLAG,
2776: jg_zz_vat_rep_utility.get_last_processed_date(p_vat_rep_entity_id,'ALL','FINAL REPORTING') LAST_PROCESS_DATE
2777: FROM jg_zz_vat_rep_status JZVRS
2778: WHERE JZVRS.vat_reporting_entity_id = p_vat_rep_entity_id
2779: AND JZVRS.tax_calendar_period = p_period
2780: AND ROWNUM = 1;
2781: Bug:8237932*/

Line 2794: jg_zz_vat_rep_status JZVRS

2790: SELECT
2791: max(JZVRS.period_end_date)
2792:
2793: FROM
2794: jg_zz_vat_rep_status JZVRS
2795: WHERE
2796: JZVRS.vat_reporting_entity_id = p_vat_rep_entity_id
2797: AND JZVRS.period_end_date <
2798: (SELECT max(JZVRS1.period_end_date)

Line 2799: FROM jg_zz_vat_rep_status JZVRS1

2795: WHERE
2796: JZVRS.vat_reporting_entity_id = p_vat_rep_entity_id
2797: AND JZVRS.period_end_date <
2798: (SELECT max(JZVRS1.period_end_date)
2799: FROM jg_zz_vat_rep_status JZVRS1
2800: WHERE JZVRS1.tax_calendar_period = p_period
2801: AND JZVRS1.vat_reporting_entity_id = p_vat_rep_entity_id
2802: --AND JZVRS1.final_reporting_status_flag = 'S'
2803: )

Line 2810: FROM jg_zz_vat_rep_status JZVRS

2806:
2807: CURSOR c_get_balance ( pn_last_process_date DATE) IS
2808: SELECT
2809: JZVRS.CREDIT_BALANCE_AMT
2810: FROM jg_zz_vat_rep_status JZVRS
2811: WHERE JZVRS.vat_reporting_entity_id = p_vat_rep_entity_id
2812: AND JZVRS.tax_calendar_period =( SELECT JZVRS1.tax_calendar_period
2813: FROM jg_zz_vat_rep_status JZVRS1
2814: WHERE

Line 2813: FROM jg_zz_vat_rep_status JZVRS1

2809: JZVRS.CREDIT_BALANCE_AMT
2810: FROM jg_zz_vat_rep_status JZVRS
2811: WHERE JZVRS.vat_reporting_entity_id = p_vat_rep_entity_id
2812: AND JZVRS.tax_calendar_period =( SELECT JZVRS1.tax_calendar_period
2813: FROM jg_zz_vat_rep_status JZVRS1
2814: WHERE
2815: JZVRS1.vat_reporting_entity_id = p_vat_rep_entity_id
2816: AND TRUNC(JZVRS1.period_end_date) = pn_last_process_date
2817: AND ROWNUM =1)

Line 2823: FROM jg_zz_vat_rep_status JZVRS

2819:
2820: CURSOR c_get_flag IS
2821: SELECT
2822: JZVRS.FINAL_REPORTING_STATUS_FLAG
2823: FROM jg_zz_vat_rep_status JZVRS
2824: WHERE JZVRS.vat_reporting_entity_id = p_vat_rep_entity_id
2825: AND JZVRS.tax_calendar_period = p_period
2826: AND ROWNUM = 1;
2827:

Line 2898: UPDATE jg_zz_vat_rep_status SET CREDIT_BALANCE_AMT=CARRY_OVER

2894: END IF;
2895:
2896: IF TEMP_FLAG = 0 THEN
2897:
2898: UPDATE jg_zz_vat_rep_status SET CREDIT_BALANCE_AMT=CARRY_OVER
2899: WHERE vat_reporting_entity_id = p_vat_rep_entity_id
2900: AND tax_calendar_period = p_period;
2901:
2902: TEMP_FLAG := 1;

Line 2930: FROM jg_zz_vat_rep_status JZVRS

2926: --LOG_MESSAGE VARCHAR2(240);
2927: CURSOR c_get_details IS
2928: SELECT
2929: JZVRS.FINAL_REPORTING_STATUS_FLAG
2930: FROM jg_zz_vat_rep_status JZVRS
2931: WHERE JZVRS.vat_reporting_entity_id = p_vat_rep_entity_id
2932: AND JZVRS.tax_calendar_period = p_period
2933: AND ROWNUM = 1;
2934: BEGIN

Line 2954: UPDATE jg_zz_vat_rep_status SET CREDIT_BALANCE_AMT=CARRY_OVER

2950: fnd_file.put_line(fnd_file.log,'In JEITPSSR_AMOUNT_TO_PAY_UPDATE CARRY_OVER:'||TO_CHAR(CARRY_OVER));
2951:
2952: IF TEMP_FLAG = 0 THEN
2953:
2954: UPDATE jg_zz_vat_rep_status SET CREDIT_BALANCE_AMT=CARRY_OVER
2955: WHERE vat_reporting_entity_id = p_vat_rep_entity_id
2956: AND tax_calendar_period = p_period;
2957:
2958: TEMP_FLAG := 1;