eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_MULTIASG SQL Statements

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

Line: 74


SELECT nvl(prl_information5, 'N')
FROM pay_all_payrolls_f
WHERE  payroll_id    = p_payroll_id
AND    p_date_earned BETWEEN effective_start_date
                         AND effective_end_date;

Line: 81


SELECT  DISTINCT ASG1.assignment_id
FROM    per_assignments_f               ASG1,
        per_assignments_f               ASG,
        hr_soft_coding_keyflex          SK
WHERE   ASG.assignment_id             = p_asst_id
AND     ASG.payroll_id                = p_payroll_id
AND     ASG.person_id                 = ASG1.person_id
AND     ASG.payroll_id                = ASG1.payroll_id
AND     ASG1.soft_coding_keyflex_id   = SK.soft_coding_keyflex_id
AND     SK.segment1                   = to_char(p_tax_unit_id)
AND     p_date_earned       BETWEEN  ASG.effective_start_date
                                AND  ASG.effective_end_date
AND     p_date_earned       BETWEEN  ASG1.effective_start_date
                                AND  ASG1.effective_end_date;

Line: 97


SELECT MIN (fffunc.cn(decode(decode(INPUTV.uom,'M','N','N','N','I','N',null),'N',
            decode(INPUTV.hot_default_flag,'Y',nvl(EEV.screen_entry_value,
            nvl(LIV.default_value,INPUTV.default_value)),'N',EEV.screen_entry_value),null)))
FROM
        pay_element_entry_values_f               EEV,
        pay_element_entries_f                    EE,
        pay_link_input_values_f                  LIV,
        pay_input_values_f                       INPUTV,
        pay_element_types_f                      E

WHERE   p_date_earned    BETWEEN INPUTV.effective_start_date
                             AND INPUTV.effective_end_date
AND     INPUTV.element_type_id + 0             = E.element_type_id
AND     LIV.input_value_id                     = INPUTV.input_value_id
AND     p_date_earned BETWEEN LIV.effective_start_date
                             AND LIV.effective_end_date
AND     EEV.input_value_id + 0                 = INPUTV.input_value_id
AND     EEV.element_entry_id                   = EE.element_entry_id
AND     EEV.effective_start_date               = EE.effective_start_date
AND     EEV.effective_end_date                 = EE.effective_end_date
AND     EE.element_link_id                     = LIV.element_link_id
AND     EE.assignment_id                       = p_assign_id
AND     p_date_earned BETWEEN EE.effective_start_date
                             AND EE.effective_end_date
AND     nvl(EE.ENTRY_TYPE, 'E')              = 'E'
AND     E.element_name                       = 'Regular Salary'
AND     E.legislation_code                   = 'CA'
AND     p_date_earned BETWEEN E.effective_start_date
                          AND E.effective_end_date
AND     INPUTV.name                          = 'Periodic Salary'
AND     INPUTV.legislation_code              = 'CA';

Line: 131


SELECT PTP.start_date
FROM
            per_time_periods ptp,
            pay_payroll_actions ppa
WHERE ppa.date_earned BETWEEN ptp.START_DATE
AND                           ptp.END_DATE
AND   ppa.payroll_action_id = p_payroll_action_id
AND   ptp.payroll_id        = ppa.payroll_id;

Line: 142


SELECT PTP.end_date
FROM
            per_time_periods ptp,
            pay_payroll_actions ppa
WHERE ppa.date_earned BETWEEN ptp.START_DATE
AND                           ptp.END_DATE
AND   ppa.payroll_action_id = p_payroll_action_id
AND   ptp.payroll_id        = ppa.payroll_id;

Line: 153


SELECT target.SEGMENT4
FROM
       hr_soft_coding_keyflex                 target,
       per_assignments_f                      ASSIGN
WHERE  p_date_earned BETWEEN ASSIGN.effective_start_date
                         AND ASSIGN.effective_end_date
AND    ASSIGN.assignment_id                  = p_assign_id
AND    target.soft_coding_keyflex_id         = ASSIGN.soft_coding_keyflex_id
AND    target.enabled_flag                   = 'Y'
AND    target.id_flex_num                    = 15;

Line: 166


SELECT sum(decode(INPUTV.hot_default_flag,
                  'Y',nvl(EEV.screen_entry_value,nvl(LIV.default_value,INPUTV.default_value)),
                  'N',EEV.screen_entry_value))
FROM
        pay_element_entry_values_f               EEV,
        pay_element_entries_f                    EE,
        pay_link_input_values_f                  LIV,
        pay_input_values_f                       INPUTV,
        pay_element_types_f                      E

WHERE   p_date_earned BETWEEN INPUTV.effective_start_date
                          AND INPUTV.effective_end_date
AND     INPUTV.element_type_id + 0             = E.element_type_id
AND     LIV.input_value_id                     = INPUTV.input_value_id
AND     p_date_earned BETWEEN LIV.effective_start_date
                          AND LIV.effective_end_date
AND     EEV.input_value_id + 0                 = INPUTV.input_value_id
AND     EEV.element_entry_id                   = EE.element_entry_id
AND     EEV.effective_start_date               = EE.effective_start_date
AND     EEV.effective_end_date                 = EE.effective_end_date
AND     EE.element_link_id                     = LIV.element_link_id
AND     EE.assignment_id                       = p_assign_id
AND     p_date_earned BETWEEN EE.effective_start_date
                          AND EE.effective_end_date
AND     nvl(EE.ENTRY_TYPE, 'E')              = 'E'
AND     E.element_name                       = 'Time Entry Wages'
AND     E.legislation_code                   = 'CA'
AND     p_date_earned BETWEEN E.effective_start_date
                          AND E.effective_end_date
AND     INPUTV.name                          = 'Hours'
AND     INPUTV.legislation_code              = 'CA';

Line: 200


SELECT min (fffunc.cn(decode(
    decode(INPUTV.uom,'M','N','N','N','I','N',null),'N',decode(INPUTV.hot_default_flag,'Y',nvl(EEV.screen_entry_value,nvl(LIV.default_value,INPUTV.default_value)),'N',EEV.screen_entry_value),null)))
FROM
        pay_element_entry_values_f               EEV,
        pay_element_entries_f                    EE,
        pay_link_input_values_f                  LIV,
        pay_input_values_f                       INPUTV,
        pay_element_types_f                      E

WHERE   p_date_earned BETWEEN INPUTV.effective_start_date
                          AND INPUTV.effective_end_date
AND     INPUTV.element_type_id + 0             = E.element_type_id
AND     LIV.input_value_id                     = INPUTV.input_value_id
AND     p_date_earned BETWEEN LIV.effective_start_date
                          AND LIV.effective_end_date
AND     EEV.input_value_id + 0                 = INPUTV.input_value_id
AND     EEV.element_entry_id                   = EE.element_entry_id
AND     EEV.effective_start_date               = EE.effective_start_date
AND     EEV.effective_end_date                 = EE.effective_end_date
AND     EE.element_link_id                     = LIV.element_link_id
AND     EE.assignment_id                       = p_assign_id
AND     p_date_earned BETWEEN EE.effective_start_date
                          AND EE.effective_end_date
AND     nvl(EE.ENTRY_TYPE, 'E')              = 'E'
AND     E.element_name                       = 'Regular Wages'
AND     E.legislation_code                   = 'CA'
AND     p_date_earned BETWEEN E.effective_start_date
                          AND E.effective_end_date
AND     INPUTV.name                          = 'Rate'
AND     INPUTV.legislation_code              = 'CA';

Line: 233


SELECT min (decode(INPUTV.hot_default_flag,'Y',nvl(EEV.screen_entry_value,
nvl(LIV.default_value,INPUTV.default_value)),'N',EEV.screen_entry_value))
FROM
        pay_element_entry_values_f               EEV,
        pay_element_entries_f                    EE,
        pay_link_input_values_f                  LIV,
        pay_input_values_f                       INPUTV,
        pay_element_types_f                      E

WHERE   p_date_earned BETWEEN INPUTV.effective_start_date
                          AND INPUTV.effective_end_date
AND     INPUTV.element_type_id + 0             = E.element_type_id
AND     LIV.input_value_id                     = INPUTV.input_value_id
AND     p_date_earned BETWEEN LIV.effective_start_date
                          AND LIV.effective_end_date
AND     EEV.input_value_id + 0                 = INPUTV.input_value_id
AND     EEV.element_entry_id                   = EE.element_entry_id
AND     EEV.effective_start_date               = EE.effective_start_date
AND     EEV.effective_end_date                 = EE.effective_end_date
AND     EE.element_link_id                     = LIV.element_link_id
AND     EE.assignment_id                       = p_assign_id
AND     p_date_earned BETWEEN EE.effective_start_date
                          AND EE.effective_end_date
AND     nvl(EE.ENTRY_TYPE, 'E')              = 'E'
AND     E.element_name                       = 'Regular Wages'
AND     E.legislation_code                   = 'CA'
AND     p_date_earned BETWEEN E.effective_start_date
                          AND E.effective_end_date
AND     INPUTV.name                          = 'Rate Code'
AND     INPUTV.legislation_code              = 'CA';

Line: 266


SELECT ASSIGN.normal_hours
FROM
        per_all_assignments_f         ASSIGN,
        hr_lookups                    HR3
WHERE   p_date_earned BETWEEN ASSIGN.effective_start_date
                          AND ASSIGN.effective_end_date
AND     ASSIGN.assignment_id                = p_assign_id
AND     HR3.application_id               (+)= 800
AND     HR3.lookup_code                  (+)= ASSIGN.frequency
AND     HR3.lookup_type                  (+)= 'FREQUENCY';

Line: 278


SELECT BASES.pay_basis
FROM
        per_assignments_f                      ASSIGN
,       per_pay_bases                          BASES
,       pay_input_values_f                     INPUTV
,       pay_element_types_f                    ETYPE
,       pay_rates                              RATE
,       hr_lookups                             HR1
,       hr_lookups                             HR2
WHERE   p_date_earned BETWEEN ASSIGN.effective_start_date
                          AND ASSIGN.effective_end_date
AND     ASSIGN.assignment_id                 = p_assign_id
AND     BASES.pay_basis_id                (+)= ASSIGN.pay_basis_id
AND     INPUTV.input_value_id             (+)= BASES.input_value_id
AND     p_date_earned BETWEEN nvl (INPUTV.effective_start_date, p_date_earned)
                          AND nvl (INPUTV.effective_end_date, p_date_earned)
AND     ETYPE.element_type_id             (+)= INPUTV.element_type_id
AND     p_date_earned BETWEEN nvl (ETYPE.effective_start_date, p_date_earned)
                          AND nvl (ETYPE.effective_end_date, p_date_earned)
AND     RATE.rate_id                      (+)= BASES.rate_id
AND     HR1.lookup_code                   (+)= BASES.pay_basis
AND     HR1.lookup_type                   (+)= 'PAY_BASIS'
AND     HR1.application_id                (+)= 800
AND     HR2.lookup_code                   (+)= BASES.rate_basis
AND     HR2.application_id                (+)= 800
AND     HR2.lookup_type                   (+)= 'PAY_BASIS';

Line: 306


SELECT HR3.lookup_code
FROM
        per_all_assignments_f         ASSIGN,
        hr_lookups                    HR3
WHERE   p_date_earned BETWEEN ASSIGN.effective_start_date
                          AND ASSIGN.effective_end_date
AND     ASSIGN.assignment_id                = p_assign_id
AND     HR3.application_id               (+)= 800
AND     HR3.lookup_code                  (+)= ASSIGN.frequency
AND     HR3.lookup_type                  (+)= 'FREQUENCY';

Line: 318


SELECT ETYPE.element_name
FROM
        per_assignments_f                      ASSIGN
,       per_pay_bases                          BASES
,       pay_input_values_f                     INPUTV
,       pay_element_types_f                    ETYPE
,       pay_rates                              RATE
,       hr_lookups                             HR1
,       hr_lookups                             HR2
WHERE   p_date_earned BETWEEN ASSIGN.effective_start_date
                          AND ASSIGN.effective_end_date
AND     ASSIGN.assignment_id                 = p_assign_id
AND     BASES.pay_basis_id                (+)= ASSIGN.pay_basis_id
AND     INPUTV.input_value_id             (+)= BASES.input_value_id
AND     p_date_earned BETWEEN nvl (INPUTV.effective_start_date, p_date_earned)
                          AND nvl (INPUTV.effective_end_date, p_date_earned)
AND     ETYPE.element_type_id             (+)= INPUTV.element_type_id
AND     p_date_earned BETWEEN nvl (ETYPE.effective_start_date, p_date_earned)
                          AND nvl (ETYPE.effective_end_date, p_date_earned)
AND     RATE.rate_id                      (+)= BASES.rate_id
AND     HR1.lookup_code                   (+)= BASES.pay_basis
AND     HR1.lookup_type                   (+)= 'PAY_BASIS'
AND     HR1.application_id                (+)= 800
AND     HR2.lookup_code                   (+)= BASES.rate_basis
AND     HR2.application_id                (+)= 800
AND     HR2.lookup_type                   (+)= 'PAY_BASIS';

Line: 346


SELECT fnd_number.canonical_to_number (EEV.screen_entry_value)
FROM
        per_assignments_f                      ASSIGN
,       per_pay_bases                          BASES
,       pay_element_entries_f                  EE
,       pay_element_entry_values_f             EEV
WHERE   p_date_earned BETWEEN ASSIGN.effective_start_date
                          AND ASSIGN.effective_end_date
AND     ASSIGN.assignment_id                 = p_assign_id
AND     BASES.pay_basis_id                +0 = ASSIGN.pay_basis_id
AND     EEV.input_value_id                   = BASES.input_value_id
AND     p_date_earned BETWEEN EEV.effective_start_date
                          AND EEV.effective_end_date
AND     EE.assignment_id                     = ASSIGN.assignment_id
AND     EE.entry_type = 'E'
AND     p_date_earned BETWEEN EE.effective_start_date
                          AND EE.effective_end_date
AND     EEV.element_entry_id                 = EE.element_entry_id;