APPS.PAY_US_PSD_GENERIC_EXTRACT SQL Statements

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

Line: 600

	SELECT fnd_global.local_chr(13) || fnd_global.local_chr(10) INTO EOL
           FROM dual;

Line: 688

                     select fai.value
                     from   ff_archive_item_contexts faic,
                            ff_contexts              fc,
                            ff_archive_items         fai,
                            ff_database_items        fdi,
                            ff_contexts              fc2,
                            ff_archive_item_contexts faic2
                     where  fdi.user_name        = psd_ue_name
                       and  fdi.user_entity_id   = fai.user_entity_id
                       and  fai.context1         = p_payroll_action_id
                       and  fc.context_name      = 'TAX_UNIT_ID'
                       and  fai.archive_item_id  = faic.archive_item_id
                       and  faic.context_id      = fc.context_id
                       and  faic.context         = to_char(p_tax_unit_id)
                       and  fc2.context_name     = 'JURISDICTION_CODE'
                       and  fai.archive_item_id  = faic2.archive_item_id
                       and  faic2.context_id     = fc2.context_id
                       and  faic2.context         = to_char('39-000000-' ||pay_magtape_generic.get_parameter_value('ER_PSD_CODE'));

Line: 834

/*select pay_us_get_item_data_pkg.GET_CPROG_PARAMETER_VALUE(ppa.payroll_action_id,
																	'TRANSFER_PERIOD_TYPE') into l_period_type
from pay_payroll_Actions ppa where payroll_action_id= p_payroll_action_id;*/

Line: 838

select pay_us_get_item_data_pkg.GET_CPROG_PARAMETER_VALUE(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'),
																	'TRANSFER_PERIOD_TYPE') into l_period_type
from dual;

Line: 1083

    SELECT fnd_global.local_chr(13) || fnd_global.local_chr(10) INTO EOL
       FROM dual;

Line: 1191

        SELECT 	'Y'
          FROM 	hr_organization_information hoi
         WHERE	hoi.organization_id = tax_unit_id AND
                hoi.org_information_context = 'PSD Reporting Rules' AND
                substr(hoi.org_information10,1,6)=psd_code;

Line: 1200

        SELECT  paf.work_at_home
          FROM  per_all_assignments_f paf,
                pay_assignment_actions paa
         WHERE  paa.assignment_action_id= l_assignment_action_id
           AND  paa.assignment_id = paf.assignment_id
           AND  l_effective_date between paf.effective_start_date and paf.effective_end_date;

Line: 1209

        select W2_LOCAL_WAGES,
               W2_LOCAL_INCOME_TAX
        from   PAY_US_LOCALITY_W2_V v
        where v.assignment_action_id = l_assignment_action_id
        and   v.JURISDICTION = l_jd_code;

Line: 1380

/*select pay_us_get_item_data_pkg.GET_CPROG_PARAMETER_VALUE(ppa.payroll_action_id,
																	'TRANSFER_PERIOD_TYPE') into l_period_type
from pay_payroll_Actions ppa where payroll_action_id= p_payroll_action_id;*/

Line: 1385

select pay_us_get_item_data_pkg.GET_CPROG_PARAMETER_VALUE(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'),
																	'TRANSFER_PERIOD_TYPE') into l_period_type
from dual;

Line: 1394

select  substr( p_jurisdiction_code, 4,6) into l_ee_residence_psd_code from dual;

Line: 1395

select  substr( p_jurisdiction_code, 11,6) into l_ee_work_psd_code from dual;

Line: 1405

ltr_ue_name_table.delete;

Line: 1593

                    select SUBSTR(l_status_description || 'Archive Item ' || ltr_ue_name_table(j).ue_name || ' has negative balance(' || trunc(ltr_ue_name_table(j).ue_value)||
                           decode(abs(ltr_ue_name_table(j).ue_value)-abs(trunc(ltr_ue_name_table(j).ue_value)),0,'.00',rpad(abs(ltr_ue_name_table(j).ue_value)-abs(trunc(ltr_ue_name_table(j).ue_value)),3,'0'))||').'
										       ||fnd_global.local_chr(13) || fnd_global.local_chr(10)||'                           	',1,1500) into l_status_description
                    from dual;

Line: 1616

                    select SUBSTR(l_status_description || 'Archive Item ' || ltr_ue_name_table(j).ue_name || ' has negative balance(' || trunc(ltr_ue_name_table(j).ue_value)||
                           decode(abs(ltr_ue_name_table(j).ue_value)-abs(trunc(ltr_ue_name_table(j).ue_value)),0,'.00',rpad(abs(ltr_ue_name_table(j).ue_value)-abs(trunc(ltr_ue_name_table(j).ue_value)),3,'0'))||').'
										       ||fnd_global.local_chr(13) || fnd_global.local_chr(10)||'                           	',1,1500) into l_status_description
                    from dual;

Line: 1637

                    select SUBSTR(l_status_description || 'Archive Item ' || ltr_ue_name_table(j).ue_name || ' has negative balance(' || trunc(ltr_ue_name_table(j).ue_value)||
                           decode(abs(ltr_ue_name_table(j).ue_value)-abs(trunc(ltr_ue_name_table(j).ue_value)),0,'.00',rpad(abs(ltr_ue_name_table(j).ue_value)-abs(trunc(ltr_ue_name_table(j).ue_value)),3,'0'))||').'
										       ||fnd_global.local_chr(13) || fnd_global.local_chr(10)||'                           	',1,1500) into l_status_description
                    from dual;

Line: 1649

										select SUBSTR(l_status_description || 'Archive Item ' || ltr_ue_name_table(j).ue_name || ' has negative balance(' || trunc(ltr_ue_name_table(j).ue_value)||
                           decode(abs(ltr_ue_name_table(j).ue_value)-abs(trunc(ltr_ue_name_table(j).ue_value)),0,'.00',rpad(abs(ltr_ue_name_table(j).ue_value)-abs(trunc(ltr_ue_name_table(j).ue_value)),3,'0'))||').'
										       ||fnd_global.local_chr(13) || fnd_global.local_chr(10)||'                           	',1,1500) into l_status_description
                    from dual;

Line: 1710

    SELECT fnd_global.local_chr(13) || fnd_global.local_chr(10) INTO EOL
       FROM dual;