APPS.PAY_ZA_ELE_TAX_FILE SQL Statements

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

Line: 20

              '(select ppa.payroll_action_id '||
                 'from pay_payroll_actions ppa '||
                'where ppa.business_group_id = '||P_BUSINESS_GROUP_ID||
                  ' and ppa.action_type = ''X'' '||
                  ' and ppa.report_type = ''ZA_TYE'' '||
                  ' and ppa.action_status = ''C'' '||
                  ' and pay_za_tye_archive_pkg.get_parameter(''TAX_YEAR'',ppa.legislative_parameters)= '||P_TAX_YEAR||
                  ' and NVL(pay_za_tye_archive_pkg.get_parameter(''PERIOD_RECON'',ppa.legislative_parameters),''02'')= NVL('||P_PERIOD_RECON||',''02'')'||
                  ' and pay_za_tye_archive_pkg.get_parameter(''CERT_TYPE'',ppa.legislative_parameters)= '''||P_CERTIFICATE_TYPE||''''||
                  ' and pay_za_tye_archive_pkg.get_parameter(''LEGAL_ENTITY'',ppa.legislative_parameters)= '||P_LEGAL_ENTITY_ID||' ) ';

Line: 40

   select pai.action_information13
     from pay_action_information pai
    where pai.action_context_id = G_ACTION_CONTEXT_ID
	    and pai.action_context_type = 'AAP'
	    and pai.action_information_category = 'ZATYE_EMPLOYEE_TAX_AND_REASONS'
	    and pai.action_information28 is null
	    and pai.action_information1 = G_CERTIFICATE_NUMBER;