APPS.PAY_SE_HCIA_ARCHIVE SQL Statements

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

Line: 86

         SELECT to_number (
                   substr (
                      pay_se_hcia_archive.get_parameter (legislative_parameters, 'LEGAL_EMPLOYER'),
                      1,
                      LENGTH (pay_se_hcia_archive.get_parameter (legislative_parameters, 'LEGAL_EMPLOYER')) - 1
                   )
                ) legal,
                substr (
                   pay_se_hcia_archive.get_parameter (legislative_parameters, 'REQUEST_FOR'),
                   1,
                   LENGTH (pay_se_hcia_archive.get_parameter (legislative_parameters, 'REQUEST_FOR')) - 1
                ) request_for,
                (pay_se_hcia_archive.get_parameter (legislative_parameters, 'EFFECTIVE_START_DATE')) eff_start_date,
                (pay_se_hcia_archive.get_parameter (legislative_parameters, 'EFFECTIVE_END_DATE'))
                      eff_end_date,
                effective_date effective_date, business_group_id bg_id
         FROM   pay_payroll_actions
         WHERE payroll_action_id = p_payroll_action_id;

Line: 142

         SELECT o1.NAME legal_employer_name, hoi2.org_information2 org_number, hoi1.organization_id legal_id
         FROM   hr_organization_units o1, hr_organization_information hoi1, hr_organization_information hoi2
         WHERE o1.business_group_id = g_business_group_id
         AND   hoi1.organization_id = o1.organization_id
         AND   hoi1.organization_id = nvl (csr_v_legal_employer_id, hoi1.organization_id)
         AND   hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'
         AND   hoi1.org_information_context = 'CLASS'
         AND   o1.organization_id = hoi2.organization_id
         AND   hoi2.org_information_context = 'SE_LEGAL_EMPLOYER_DETAILS';

Line: 175

            SELECT count (*)
            FROM   per_all_people_f papf,
                   per_all_assignments_f paaf,
                   hr_soft_coding_keyflex hsc,
                   per_assignment_status_types past,
                   hr_organization_information hoi,
                   per_person_types ppt
            WHERE paaf.person_id = papf.person_id
            AND   paaf.business_group_id = papf.business_group_id
            AND   hsc.soft_coding_keyflex_id = paaf.soft_coding_keyflex_id
            AND   hsc.segment2 = hoi.org_information1
            AND   hoi.organization_id = p_legal_employer_id
            AND   ppt.system_person_type LIKE 'EMP%'
            AND   ppt.person_type_id = papf.person_type_id
            AND   papf.sex = p_gender_type
            AND   paaf.assignment_status_type_id = past.assignment_status_type_id
            AND   past.per_system_status = 'ACTIVE_ASSIGN'
            AND   paaf.primary_flag = 'Y'
            AND   p_effective_date BETWEEN paaf.effective_start_date AND paaf.effective_end_date
            AND   p_effective_date BETWEEN papf.effective_start_date AND papf.effective_end_date;

Line: 231

         'SELECT DISTINCT person_id
            FROM  per_people_f ppf
                 ,pay_payroll_actions ppa
            WHERE ppa.payroll_action_id = :payroll_action_id
            AND   ppa.business_group_id = ppf.business_group_id
            ORDER BY ppf.person_id';

Line: 407

         p_sql := 'select 1 from dual where to_char(:payroll_action_id) = dummy';