APPS.JE_IT_LISTING_PKG dependencies on JE_IT_LIST_LINES_ALL

Line 689: | This procedure deletes all the rows from JE_IT_LIST_LINES_ALL, |

685: | PROCEDURE |
686: | Purge_trx_data() |
687: | |
688: | DESCRIPTION |
689: | This procedure deletes all the rows from JE_IT_LIST_LINES_ALL, |
690: | JE_IT_LIST_PARTIES_ALL , JE_IT_LIST_HDR_ALL for a given period. |
691: | |
692: | SCOPE - Public |
693: | |

Line 709: DELETE JE_IT_LIST_LINES_ALL

705: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_IT_LISTING_PKG.Insert_tax_data','Start PROCEDURE Purge_trx_data');
706: END IF;
707: g_retcode :=0;
708:
709: DELETE JE_IT_LIST_LINES_ALL
710: WHERE vat_reporting_entity_id = p_vat_reporting_entity_id
711: AND year_of_declaration = p_year_of_declaration;
712:
713: DELETE JE_IT_LIST_PARTIES_ALL

Line 1356: SELECT 'Y' INTO available_flag FROM JE_IT_LIST_LINES_ALL

1352:
1353:
1354:
1355: BEGIN
1356: SELECT 'Y' INTO available_flag FROM JE_IT_LIST_LINES_ALL
1357: WHERE
1358: VAT_REPORTING_ENTITY_ID = P_VAT_REPORTING_ENTITY_ID
1359: AND YEAR_OF_DECLARATION = P_YEAR_OF_DECLARATION
1360: AND APPLICATION_ID = p_app_id

Line 1374: INSERT INTO JE_IT_LIST_LINES_ALL(

1370:
1371: IF available_flag is NULL or available_flag = 'N' THEN
1372:
1373: -- ITEM line insertion
1374: INSERT INTO JE_IT_LIST_LINES_ALL(
1375: VAT_REPORTING_ENTITY_ID,
1376: YEAR_OF_DECLARATION,
1377: APPLICATION_ID,
1378: PARTY_ID,

Line 1443: INSERT INTO JE_IT_LIST_LINES_ALL(

1439: --- Bug 7018923
1440:
1441: -- tax line insertion
1442:
1443: INSERT INTO JE_IT_LIST_LINES_ALL(
1444: VAT_REPORTING_ENTITY_ID,
1445: YEAR_OF_DECLARATION,
1446: APPLICATION_ID,
1447: PARTY_ID,

Line 1635: FROM JE_IT_LIST_LINES_ALL jit,

1631: SUM(jit.CM_TAXABLE_VAT_AMT) tot_taxable_vat_amt_cm, --TAXABLE_VAT_AMT
1632: SUM(jit.CM_TAXABLE_VAT_INV_AMT) tot_taxable_vat_inv_amt_cm, --TAXABLE_VAT_INV_AMT
1633: hzp.jgzz_fiscal_code tax_payer_id, -- Customer Tax Payer ID
1634: DECODE(hzcsu.tax_reference, null,hzp.tax_reference,hzcsu.tax_reference) vat_reg_num-- Customer Tax Registration Number
1635: FROM JE_IT_LIST_LINES_ALL jit,
1636: hz_cust_site_uses_all hzcsu,
1637: hz_cust_acct_sites_all hzcas,
1638: hz_cust_accounts hzca,
1639: hz_parties hzp

Line 1677: FROM je_it_list_lines_all jit,

1673: SUM(jit.CM_TAXABLE_VAT_AMT) tot_taxable_vat_amt_cm, --TAXABLE_VAT_AMT
1674: SUM(jit.CM_TAXABLE_VAT_INV_AMT) tot_taxable_vat_inv_amt_cm, --TAXABLE_VAT_INV_AMT
1675: NVL(papf.national_identifier,NVL(pv.individual_1099,pv.num_1099)), --Supplier Tax Payer ID
1676: NVL(pvs.vat_registration_num, pv.vat_registration_num) --Supplier Tax Registration Number
1677: FROM je_it_list_lines_all jit,
1678: ap_suppliers pv,
1679: ap_supplier_sites_all pvs,
1680: (SELECT distinct person_id
1681: ,national_identifier

Line 1729: FROM JE_IT_LIST_LINES_ALL jit,

1725: SUM(jit.CM_TAXABLE_VAT_AMT) tot_taxable_vat_amt_cm, --TAXABLE_VAT_AMT
1726: SUM(jit.CM_TAXABLE_VAT_INV_AMT) tot_taxable_vat_inv_amt_cm, --TAXABLE_VAT_INV_AMT
1727: hzp.jgzz_fiscal_code tax_payer_id, -- Customer Tax Payer ID
1728: DECODE(hzcsu.tax_reference, null,hzp.tax_reference,hzcsu.tax_reference) vat_reg_num-- Customer Tax Registration Number
1729: FROM JE_IT_LIST_LINES_ALL jit,
1730: hz_cust_site_uses_all hzcsu,
1731: hz_cust_acct_sites_all hzcas,
1732: hz_cust_accounts hzca,
1733: hz_parties hzp

Line 1776: FROM je_it_list_lines_all jit,

1772: SUM(jit.CM_TAXABLE_VAT_AMT) tot_taxable_vat_amt_cm, --TAXABLE_VAT_AMT
1773: SUM(jit.CM_TAXABLE_VAT_INV_AMT) tot_taxable_vat_inv_amt_cm, --TAXABLE_VAT_INV_AMT
1774: NVL(papf.national_identifier,NVL(pv.individual_1099,pv.num_1099)) tax_payer_id, --Supplier Tax Payer ID
1775: NVL(pvs.vat_registration_num, pv.vat_registration_num) vat_reg_num --Supplier Tax Registration Number
1776: FROM je_it_list_lines_all jit,
1777: ap_suppliers pv,
1778: ap_supplier_sites_all pvs,
1779: (SELECT distinct person_id
1780: ,national_identifier