APPS.PAY_IN_SOE SQL Statements

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

Line: 38

      SELECT org_information7 template
            ,org_information8 chunk_size
      FROM   hr_organization_information_v
      WHERE organization_id        = p_business_group_id
      AND   org_information_context= 'PER_IN_PRINTED_PAYSLIP';

Line: 257

    SELECT  DECODE(element_classification
                  ,'Earnings', element_reporting_name
                  ,'Paid Monetary Perquisite', SUBSTR(element_reporting_name, 0,
                                               LENGTH(element_reporting_name) - 8)) ename
           ,current_amount         amt
    FROM  pay_apac_payslip_elements_v
    WHERE action_context_id      = p_action_context_id
    AND   (element_classification = p_classification_name
        OR element_classification = 'Paid Monetary Perquisite');

Line: 270

    SELECT  element_reporting_name ename
           ,current_amount         amt
    FROM  pay_apac_payslip_elements_v
    WHERE action_context_id      = p_action_context_id
    AND   element_classification = p_classification_name;

Line: 416

    SELECT  sum(current_amount) amt
    FROM  pay_apac_payslip_elements_v
    WHERE action_context_id      = p_action_context_id
    AND   element_classification = p_classification_name;

Line: 535

    SELECT narrative bname
          ,ytd_amount ytd
    FROM  pay_apac_payslip_balances_v
    WHERE action_context_id = p_action_context_id;

Line: 612

    SELECT  narrative
           ,amount
    FROM   pay_emea_usr_ele_action_info_v
    WHERE  action_context_id = p_action_context_id;

Line: 711

      SELECT accrual_plan_name plan_name
            ,uom
            ,balance
      FROM   pay_apac_payslip_accruals_v
      WHERE  action_context_id = p_action_context_id;

Line: 807

      SELECT absence_type absence_name
            ,start_date
            ,end_date
            ,absence_value
      FROM pay_apac_payslip_absences_v
      WHERE action_context_id = p_action_context_id;

Line: 908

      SELECT DISTINCT info_type
            ,name
            ,value_type
            ,value
      FROM pay_emp_others_action_info_v
      WHERE action_context_id = p_action_context_id
      AND info_type = 'MESG';

Line: 982

    SELECT  narrative
           ,value
    FROM   pay_apac_bals_action_info_v
    WHERE  action_context_id = p_action_context_id;

Line: 1073

    SELECT org_payment_method_name payment_method
          ,segment1                bank_name
          ,segment3                account_number
          ,value
    FROM pay_emp_net_dist_action_info_v pendv
    WHERE pendv.action_context_id = p_action_context_id;

Line: 1291

    l_stmt := ' SELECT piaav.assignment_action_id action_context_id
                      ,peaiv.action_information10 employee_number
                      ,peaiv.action_information14 assignment_number
                      ,peaiv.action_information18 gre_name
                      ,pay_us_employee_payslip_web.format_to_date(peaiv.action_information13) dob
                      ,pay_us_employee_payslip_web.format_to_date(peaiv.action_information11) joining_date
                      ,peaiv.action_information8 ptn
                      ,peaiv.action_information24 pf_number
                      ,peaiv.action_information6  esi_number
                      ,peaiv.action_information1  emp_name
                      ,peaiv.action_information23 pay_month
                      ,peaiv.action_information30 er_location
                      ,peaiv.action_information17 job
                      ,peaiv.action_information19 position
                      ,peaiv.action_information7  grade
                      ,peaiv.action_information25 pan
                      ,peaiv.action_information27 superannuation
		      ,peaiv.action_information1  full_name
		      ,peaiv.action_information30 location_name
		      ,peaiv.action_information15 organization_name
                FROM   pay_in_arch_actions_v piaav
                      ,pay_action_information peaiv
                WHERE  piaav.business_group_id = :bg_id
                AND    piaav.effective_date BETWEEN :start_date
                                            AND     :end_date
                AND  ( :payroll_id = -1 OR :payroll_id =  piaav.payroll_id)
                AND  ( :cons_set_id = -1 OR :cons_set_id =
                       piaav.consolidation_set_id)
                AND  peaiv.action_context_id = piaav.assignment_action_id
                AND  peaiv.action_context_type = ''AAP''
                AND  peaiv.action_information_category = ''EMPLOYEE DETAILS'' ';