APPS.JE_IT_LISTING_PKG dependencies on JE_IT_LIST_PARTIES_ALL

Line 400: FROM JE_IT_LIST_PARTIES_ALL

396: IF l_gen_efile THEN
397: BEGIN
398: SELECT NVL(MAX(TRANSMISSION_NUM),0) --Bug:8274173
399: INTO l_eft_count
400: FROM JE_IT_LIST_PARTIES_ALL
401: WHERE vat_reporting_entity_id = P_VAT_REPORTING_ENTITY_ID
402: AND year_of_declaration = P_YEAR_OF_DECLARATION;
403: EXCEPTION
404: WHEN OTHERS THEN

Line 690: | JE_IT_LIST_PARTIES_ALL , JE_IT_LIST_HDR_ALL for a given period. |

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: | |
694: | NOTES |

Line 713: DELETE JE_IT_LIST_PARTIES_ALL

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
714: WHERE vat_reporting_entity_id = p_vat_reporting_entity_id
715: AND year_of_declaration = p_year_of_declaration;
716:
717: DELETE JE_IT_LIST_HDR_ALL

Line 1589: | This procedure populates the tables JE_IT_LIST_PARTIES_ALL |

1585: /*===========================================================================+
1586: | PROCEDURE |
1587: | GENERATE_TRX_HEADERS |
1588: | DESCRIPTION |
1589: | This procedure populates the tables JE_IT_LIST_PARTIES_ALL |
1590: | and JE_IT_LIST_HDR_ALL |
1591: | SCOPE - Private |
1592: | |
1593: | NOTES |

Line 1841: INSERT INTO JE_IT_LIST_PARTIES_ALL

1837: l_transnum := l_transnum + 1;
1838: l_count :=1;
1839: END IF;
1840:
1841: INSERT INTO JE_IT_LIST_PARTIES_ALL
1842: (VAT_REPORTING_ENTITY_ID,
1843: YEAR_OF_DECLARATION,
1844: TRANSMISSION_NUM,
1845: APPLICATION_ID,

Line 1915: INSERT INTO JE_IT_LIST_PARTIES_ALL

1911: l_transnum := l_transnum + 1;
1912: l_count :=1;
1913: END IF;
1914:
1915: INSERT INTO JE_IT_LIST_PARTIES_ALL
1916: (VAT_REPORTING_ENTITY_ID,
1917: YEAR_OF_DECLARATION,
1918: TRANSMISSION_NUM,
1919: APPLICATION_ID,