APPS.PAY_SE_ALECTA_UPLOAD SQL Statements

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

Line: 40

        SELECT legislation_code, name
        FROM per_business_groups
        WHERE business_group_id = v_bg_id;

Line: 47

	INSERT INTO fnd_sessions(SESSION_ID , EFFECTIVE_DATE )
	VALUES(userenv('SESSIONID'),fnd_date.canonical_to_date(p_effective_date)) ;

Line: 285

              SELECT COUNT ('1') INTO l_record_found
              FROM pay_action_information
              WHERE action_information_category      = 'EMEA REPORT INFORMATION'
              AND action_information1          = 'PYSEALEA'
              AND l_org_number = action_information5
              AND l_cost_centre = action_information6
              AND l_agreed_product_id = action_information7
              AND l_person_number = action_information8
              AND l_last_name = action_information10
              AND l_first_name = action_information11
              AND l_salary IN (action_information14, action_information13)
              AND fnd_date.date_to_canonical(to_date(l_time_of_event, 'YYYY/MM/DD')) = action_information9;

Line: 305

                SELECT COUNT ('1') INTO l_record_found
                FROM pay_action_information
                WHERE action_information_category      = 'EMEA REPORT INFORMATION'
                AND action_information1          = 'PYSEALEA'
                AND l_org_number = action_information5
                AND l_cost_centre = action_information6
                AND l_agreed_product_id = action_information7
                AND l_person_number = action_information8
                AND l_salary IN (action_information12, action_information11)
                AND fnd_date.date_to_canonical(to_date(l_time_of_event, 'YYYY/MM/DD')) = action_information9;

Line: 322

                SELECT COUNT ('1') INTO l_record_found
                FROM pay_action_information
                WHERE action_information_category      = 'EMEA REPORT INFORMATION'
                AND action_information1          = 'PYSEALEA'
                AND l_org_number = action_information5
                AND l_cost_centre = action_information6
                AND l_person_number = action_information7
                AND l_salary IN (action_information11, action_information10)
                AND fnd_date.date_to_canonical(to_date(l_time_of_event, 'YYYY/MM/DD')) = action_information8;

Line: 338

                SELECT COUNT ('1') INTO l_record_found
                FROM pay_action_information
                WHERE action_information_category      = 'EMEA REPORT INFORMATION'
                AND action_information1          = 'PYSEALEA'
                AND l_org_number = action_information5
                AND l_cost_centre = action_information6
                AND l_person_number = action_information7
                AND fnd_date.date_to_canonical(to_date(l_time_of_event, 'YYYY/MM/DD')) = action_information8 ;