APPS.JE_IT_XML_LISTING_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 4

gn_row_inserted NUMBER := 0;

Line: 33

 SELECT ptp.party_id
 FROM   zx_registrations  reg,
        zx_party_tax_profile ptp
 WHERE  ptp.party_tax_profile_id = reg.party_tax_profile_id
 AND reg.registration_number = c_registration_number
 AND sysdate >= reg.effective_from
 AND (sysdate <= reg.effective_to OR reg.effective_to IS NULL)
 AND ptp.party_type_code = c_party_type_code;  --'THIRD_PARTY'

Line: 101

PROCEDURE insert_into_table (col_data VARCHAR2, appl_id NUMBER)
AS
BEGIN
	INSERT INTO je_it_list_trx_gt
	(je_info_n1,
	je_info_v1)
	VALUES
	(appl_id,
	col_data);

Line: 110

gn_row_inserted := gn_row_inserted + 1;

Line: 111

fnd_file.put_line(fnd_file.log,'Rows Inserted:'||gn_row_inserted);

Line: 115

END insert_into_table;

Line: 126

				insert_into_table(gv_row_val,pn_appl_id);

Line: 138

            SELECT    je.party_id CUST_PARTY_ID
                       ,je.transmission_num  TRANSMISSION_NUM
                       ,hzp.party_name PARTY_NAME
                       ,hzp.party_type PARTY_TYPE
                       ,je.fiscal_id_num  TAX_PAYERID
                       ,je.vat_registration_num VAT_REGISTRATION_NUM
                       ,ROUND(je.taxable_amt) TAXABLE_AMT
                       ,ROUND(je.vat_amt) VAT_AMT
                       ,ROUND(je.non_taxable_amt) NON_TAXABLE_AMT
                       ,ROUND(je.exempt_amt) EXEMPT_AMT
                       ,ROUND(je.taxable_vat_inv_amt) TAXABLE_VAT_INV_AMT
                       ,ROUND(je.cm_taxable_amt) TAXABLE_AMT_CM
                       ,ROUND(je.cm_vat_amt) VAT_AMT_CM
                       ,ROUND(je.cm_non_taxable_amt) NON_TAXABLE_AMT_CM
                       ,ROUND(je.cm_exempt_amt) EXEMPT_AMT_CM
                       ,ROUND(je.cm_taxable_vat_inv_amt) TAXABLE_VAT_INV_AMT_CM
                FROM    je_it_list_parties_all je
                       ,hz_cust_accounts   hzca
 		       ,hz_parties         hzp
                WHERE    je.vat_reporting_entity_id = P_VAT_REPORTING_ENTITY_ID
			AND je.year_of_declaration = P_YEAR_OF_DECLARATION
			AND je.application_id  = 222
	                AND je.transmission_num  = P_PROG_NUM
	                AND je.party_id = hzca.cust_account_id
	  		AND hzca.party_id  = hzp.party_id
                ORDER BY je.party_sequence_num;

Line: 167

        SELECT  je.party_id SUP_PARTY_ID
                ,je.transmission_num TRANSMISSION_NUM
                ,pv.vendor_name				   PARTY_NAME
                ,pv.vendor_type_lookup_code	   PARTY_TYPE
        		,je.fiscal_id_num                  TAX_PAYERID
		      	,je.vat_registration_num	       VAT_REGISTRATION_NUM
                ,ROUND(je.taxable_amt) TAXABLE_AMT
                ,ROUND(je.vat_amt) VAT_AMT
                ,ROUND(je.non_taxable_amt) NON_TAXABLE_AMT
                ,ROUND(je.exempt_amt) EXEMPT_AMT
                ,ROUND(je.taxable_vat_amt) TAXABLE_VAT_AMT
                ,ROUND(je.taxable_vat_inv_amt) TAXABLE_VAT_INV_AMT
                ,ROUND(je.cm_taxable_amt) TAXABLE_AMT_CM
                ,ROUND(je.cm_vat_amt) VAT_AMT_CM
                ,ROUND(je.cm_non_taxable_amt) NON_TAXABLE_AMT_CM
                ,ROUND(je.cm_exempt_amt) EXEMPT_AMT_CM
                ,ROUND(je.cm_taxable_vat_amt) TAXABLE_VAT_AMT_CM
                ,ROUND(je.cm_taxable_vat_inv_amt) TAXABLE_VAT_INV_AMT_CM
        FROM    je_it_list_parties_all je
                ,ap_suppliers pv
        WHERE   je.vat_reporting_entity_id = P_VAT_REPORTING_ENTITY_ID
      	AND je.year_of_declaration = P_YEAR_OF_DECLARATION
        AND je.transmission_num   = P_PROG_NUM
      	AND je.application_id  = 200
      	AND je.party_id  = pv.vendor_id
      ORDER BY je.party_sequence_num;

Line: 272

                insert_into_table(gv_row_val,222);

Line: 360

                insert_into_table(gv_row_val,200);

Line: 773

    SELECT 1
    FROM  ap_suppliers pv,
        (SELECT distinct person_id
	          ,national_identifier
        FROM per_all_people_f
    	 WHERE nvl(effective_end_date,sysdate) >= sysdate ) papf
    WHERE pv.employee_id = papf.person_id (+)
    AND NVL(papf.national_identifier,NVL(pv.individual_1099,pv.num_1099)) = c_taxpayer_id;

Line: 783

SELECT 1 FROM hz_parties
WHERE  jgzz_fiscal_code = c_taxpayer_id;