APPS.PAY_MX_UTILITY SQL Statements

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

Line: 24

      select pbt.balance_type_id, pbt.balance_uom
      from   pay_balance_types pbt,
             pay_defined_balances pdb,
             pay_balance_attributes pba,
             pay_bal_attribute_definitions pbad
      where  pbad.attribute_name      = 'Earnings Days'
      and    pbad.business_group_id is null
      and    pbad.legislation_code    = 'MX'
      and    pba.attribute_id         = pbad.attribute_id
      and    pdb.defined_balance_id   = pba.defined_balance_id
      and    pbt.balance_type_id      = pdb.balance_type_id
      and    pbt.base_balance_type_id = cp_balance_type_id;

Line: 106

      select pbt.balance_type_id, pbt.balance_uom
      from   pay_balance_types pbt,
             pay_defined_balances pdb,
             pay_balance_attributes pba,
             pay_bal_attribute_definitions pbad
      where  pbad.attribute_name      = 'Earnings Hours'
      and    pbad.business_group_id is null
      and    pbad.legislation_code    = 'MX'
      and    pba.attribute_id         = pbad.attribute_id
      and    pdb.defined_balance_id   = pba.defined_balance_id
      and    pbt.balance_type_id      = pdb.balance_type_id
      and    pbt.base_balance_type_id = cp_balance_type_id;

Line: 211

      SELECT period_type, legislation_info2
      FROM   per_time_period_types ptpt,
             pay_mx_legislation_info_f pmli
      WHERE  legislation_info_type = 'MX Annualization Factor'
      AND    instr(period_type,legislation_info1) > 0;

Line: 218

      SELECT period_type
      FROM   pay_payrolls_f
      WHERE  payroll_id = cp_payroll_id;

Line: 315

      SELECT fnd_number.canonical_to_number(nvl(org_information8,'-999')),
             fnd_number.canonical_to_number(nvl(org_information9,'-999'))
      FROM   hr_organization_information
      WHERE  organization_id         = cp_organization_id
      AND    org_information_context = 'MX_SOC_SEC_DETAILS';

Line: 322

      SELECT fnd_number.canonical_to_number(nvl(org_information4,'-999')),
             fnd_number.canonical_to_number(nvl(org_information5,'-999'))
      FROM   hr_organization_information
      WHERE  organization_id         = cp_organization_id
      AND    org_information_context = 'MX_TAX_REGISTRATION';

Line: 444

    SELECT TO_NUMBER(TO_CHAR(LAST_DAY(effective_date),'DD'))
    FROM fnd_sessions
    WHERE session_id = USERENV('SESSIONID') ;

Line: 638

      SELECT period_type
      FROM   pay_payrolls_f
      WHERE  payroll_id = cp_payroll_id;

Line: 643

      SELECT to_number(to_char(effective_date,'DD')),
             to_number(to_char(last_day(effective_date),'DD'))
      from fnd_sessions
      where session_id = USERENV('sessionid') ;

Line: 747

       SELECT  to_number(to_char(last_day(ADD_MONTHS(effective_date,-1)),'DD')) +
               to_number(to_char(last_day(effective_date),'DD'))
       from fnd_sessions
       where session_id = USERENV('sessionid') ;

Line: 787

      SELECT classification_id
      FROM   pay_element_classifications
      WHERE  legislation_code     = 'MX'
      AND    classification_name  = cp_classification_name;

Line: 828

    SELECT COUNT(*)
    INTO   ln_exists
    FROM   pay_ele_tmplt_class_usages
    WHERE  classification_id = p_classification_id
    AND    template_id       = p_template_id;

Line: 838

       SELECT pay_ele_tmplt_class_usg_s.nextval
       INTO   ln_ele_tmplt_class_id
       FROM   dual;

Line: 844

       INSERT INTO pay_ele_tmplt_class_usages
                 ( ele_template_classification_id
                  ,classification_id
                  ,template_id
                  ,display_process_mode
                  ,display_arrearage )
        VALUES   ( ln_ele_tmplt_class_id
                  ,p_classification_id
                  ,p_template_id
                  ,p_display_process_mode
                  ,p_display_arrearage );

Line: 963

       SELECT fnd_date.canonical_to_date(legislation_info1)
       FROM   pay_mx_legislation_info_f
       WHERE  legislation_info_type = 'MX Social Security Reporting' ;

Line: 1101

       SELECT legislative_parameters
       FROM   pay_payroll_actions
       WHERE  payroll_action_id = p_cntx_payroll_action_id;

Line: 1136

        SELECT hoi.org_information7
          FROM hr_organization_units hou,
               hr_organization_information hoi
         WHERE hou.organization_id = hoi.organization_id
           AND hoi.org_information_context = 'MX_SOC_SEC_DETAILS'
           AND hou.organization_id = P_CTX_TAX_UNIT_ID
           AND P_CTX_DATE_EARNED BETWEEN hou.date_from
                                    AND NVL(hou.date_to, hr_general.end_of_time);

Line: 1173

	SELECT  fnd_number.canonical_to_number(legislation_info2)  FROM PAY_MX_LEGISLATION_INFO_F WHERE
    legislation_info1=
    DECODE(P_ECON_ZONE,'NONE','GMW','MW'||P_ECON_ZONE) AND
    legislation_info_type = 'MX Minimum Wage Information'
    AND P_CTX_DATE_EARNED BETWEEN  effective_start_date AND effective_end_date;