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.

VIEW: APPS.HR_PAY_INTERFACE_SAL_ADMIN_V

Source

View Text - Preformatted


SELECT
  pp.full_name
, pp.employee_number
, asg.assignment_number
, bgr.name
, org.name
, asg.normal_hours
, pev.screen_entry_value
, pet.input_currency_code
, ppb.pay_annualization_factor
, prl.payroll_name
, ptp.number_per_fiscal_year
, ppp.proposed_salary*NVL(ppb.pay_annualization_factor,
                          ptp.number_per_fiscal_year)
, ppp.proposed_salary
, ppp.change_date
, pp.attribute1
, pp.attribute2
, pp.attribute3
, asg.ass_attribute1
, asg.ass_attribute2
, asg.ass_attribute3
, ppp.attribute1
, ppp.attribute2
, ppp.attribute3
, ppp.attribute4
, ppp.attribute5
, ppp.attribute6
, ppp.attribute7
, ppp.attribute8
, ppp.attribute9
, ppp.attribute10
, ppp.attribute11
, ppp.attribute12
, ppp.attribute13
, ppp.attribute14
, ppp.attribute15
, ppp.attribute16
, ppp.attribute17
, ppp.attribute18
, ppp.attribute19
, ppp.attribute20
, pp.person_id
, asg.assignment_id
, bgr.organization_id
, org.organization_id
, GREATEST(
   GREATEST(NVL(pp.last_update_date,
           TO_DATE('1900/01/01','YYYY/MM/DD'))
          ,pp.effective_start_date)
, GREATEST(NVL(asg.last_update_date,
           TO_DATE('1900/01/01','YYYY/MM/DD'))
           ,asg.effective_start_date)
, GREATEST(NVL(ppp.last_update_date,
           TO_DATE('1900/01/01','YYYY/MM/DD'))
           ,ppp.change_date)
	   )
, GREATEST(NVL(pp.last_update_date,
           TO_DATE('1900/01/01','YYYY/MM/DD'))
          ,pp.effective_start_date)
, GREATEST(NVL(asg.last_update_date,
           TO_DATE('1900/01/01','YYYY/MM/DD'))
           ,asg.effective_start_date)
, GREATEST(NVL(pee.creation_date,
           TO_DATE('1900/01/01','YYYY/MM/DD'))
           ,pee.effective_start_date)
FROM
  per_all_people_f           pp
, per_all_assignments_f      asg
, hr_all_organization_units  bgr
, hr_all_organization_units  org
, per_pay_bases              ppb
, per_pay_proposals          ppp
, pay_all_payrolls_f         prl
, per_time_period_types      ptp
, pay_input_values_f         piv
, pay_element_types_f        pet
, pay_element_links_f        pel
, pay_element_entries_f      pee
, pay_element_entry_values_f pev
WHERE
    pp.person_id = asg.person_id
and asg.business_group_id + 0 = bgr.organization_id
and asg.organization_id =  org.organization_id
and asg.payroll_id = prl.payroll_id
and prl.period_type = ptp.period_type
and ppp.assignment_id = asg.assignment_id
-- and ppp.approved = 'Y'
and asg.pay_basis_id = ppb.pay_basis_id
and ppb.input_value_id = piv.input_value_id
and piv.element_type_id = pet.element_type_id
and pet.element_type_id = pel.element_type_id
and pel.element_link_id = pee.element_link_id
and asg.assignment_id   = pee.assignment_id
and pee.creator_type = 'SP'
and pee.element_entry_id= pev.element_entry_id
and pev.input_value_id  = piv.input_value_id
and asg.effective_start_date BETWEEN
    prl.effective_start_date and prl.effective_end_date
and HR_PAY_INTERFACE_PKG.GET_EXTRACT_DATE BETWEEN
    pp.effective_start_date AND pp.effective_end_date
and asg.effective_start_date = (select max(asg2.effective_start_date)
				from per_all_assignments_f asg2
                                where asg2.assignment_id = asg.assignment_id
                                  and asg2.effective_start_date <=
                                      HR_PAY_INTERFACE_PKG.GET_EXTRACT_DATE )
AND piv.effective_start_date BETWEEN
    pet.effective_start_date AND pet.effective_end_date
AND NVL(ppp.change_date, asg.effective_start_date) between
    piv.effective_start_date AND piv.effective_end_date
and ppp.change_date = pee.effective_start_date
and HR_PAY_INTERFACE_PKG.GET_EXTRACT_DATE BETWEEN
    pet.effective_start_date AND pet.effective_end_date
and HR_PAY_INTERFACE_PKG.GET_EXTRACT_DATE BETWEEN
    pel.effective_start_date AND pel.effective_end_date
and HR_PAY_INTERFACE_PKG.GET_EXTRACT_DATE BETWEEN
    pee.effective_start_date AND pee.effective_end_date
and HR_PAY_INTERFACE_PKG.GET_EXTRACT_DATE BETWEEN
    pev.effective_start_date AND pev.effective_end_date

View Text - HTML Formatted

SELECT PP.FULL_NAME
, PP.EMPLOYEE_NUMBER
, ASG.ASSIGNMENT_NUMBER
, BGR.NAME
, ORG.NAME
, ASG.NORMAL_HOURS
, PEV.SCREEN_ENTRY_VALUE
, PET.INPUT_CURRENCY_CODE
, PPB.PAY_ANNUALIZATION_FACTOR
, PRL.PAYROLL_NAME
, PTP.NUMBER_PER_FISCAL_YEAR
, PPP.PROPOSED_SALARY*NVL(PPB.PAY_ANNUALIZATION_FACTOR
, PTP.NUMBER_PER_FISCAL_YEAR)
, PPP.PROPOSED_SALARY
, PPP.CHANGE_DATE
, PP.ATTRIBUTE1
, PP.ATTRIBUTE2
, PP.ATTRIBUTE3
, ASG.ASS_ATTRIBUTE1
, ASG.ASS_ATTRIBUTE2
, ASG.ASS_ATTRIBUTE3
, PPP.ATTRIBUTE1
, PPP.ATTRIBUTE2
, PPP.ATTRIBUTE3
, PPP.ATTRIBUTE4
, PPP.ATTRIBUTE5
, PPP.ATTRIBUTE6
, PPP.ATTRIBUTE7
, PPP.ATTRIBUTE8
, PPP.ATTRIBUTE9
, PPP.ATTRIBUTE10
, PPP.ATTRIBUTE11
, PPP.ATTRIBUTE12
, PPP.ATTRIBUTE13
, PPP.ATTRIBUTE14
, PPP.ATTRIBUTE15
, PPP.ATTRIBUTE16
, PPP.ATTRIBUTE17
, PPP.ATTRIBUTE18
, PPP.ATTRIBUTE19
, PPP.ATTRIBUTE20
, PP.PERSON_ID
, ASG.ASSIGNMENT_ID
, BGR.ORGANIZATION_ID
, ORG.ORGANIZATION_ID
, GREATEST( GREATEST(NVL(PP.LAST_UPDATE_DATE
, TO_DATE('1900/01/01'
, 'YYYY/MM/DD'))
, PP.EFFECTIVE_START_DATE)
, GREATEST(NVL(ASG.LAST_UPDATE_DATE
, TO_DATE('1900/01/01'
, 'YYYY/MM/DD'))
, ASG.EFFECTIVE_START_DATE)
, GREATEST(NVL(PPP.LAST_UPDATE_DATE
, TO_DATE('1900/01/01'
, 'YYYY/MM/DD'))
, PPP.CHANGE_DATE) )
, GREATEST(NVL(PP.LAST_UPDATE_DATE
, TO_DATE('1900/01/01'
, 'YYYY/MM/DD'))
, PP.EFFECTIVE_START_DATE)
, GREATEST(NVL(ASG.LAST_UPDATE_DATE
, TO_DATE('1900/01/01'
, 'YYYY/MM/DD'))
, ASG.EFFECTIVE_START_DATE)
, GREATEST(NVL(PEE.CREATION_DATE
, TO_DATE('1900/01/01'
, 'YYYY/MM/DD'))
, PEE.EFFECTIVE_START_DATE) FROM PER_ALL_PEOPLE_F PP
, PER_ALL_ASSIGNMENTS_F ASG
, HR_ALL_ORGANIZATION_UNITS BGR
, HR_ALL_ORGANIZATION_UNITS ORG
, PER_PAY_BASES PPB
, PER_PAY_PROPOSALS PPP
, PAY_ALL_PAYROLLS_F PRL
, PER_TIME_PERIOD_TYPES PTP
, PAY_INPUT_VALUES_F PIV
, PAY_ELEMENT_TYPES_F PET
, PAY_ELEMENT_LINKS_F PEL
, PAY_ELEMENT_ENTRIES_F PEE
, PAY_ELEMENT_ENTRY_VALUES_F PEV WHERE PP.PERSON_ID = ASG.PERSON_ID AND ASG.BUSINESS_GROUP_ID + 0 = BGR.ORGANIZATION_ID AND ASG.ORGANIZATION_ID = ORG.ORGANIZATION_ID AND ASG.PAYROLL_ID = PRL.PAYROLL_ID AND PRL.PERIOD_TYPE = PTP.PERIOD_TYPE AND PPP.ASSIGNMENT_ID = ASG.ASSIGNMENT_ID --
AND PPP.APPROVED = 'Y' AND ASG.PAY_BASIS_ID = PPB.PAY_BASIS_ID AND PPB.INPUT_VALUE_ID = PIV.INPUT_VALUE_ID AND PIV.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID AND PET.ELEMENT_TYPE_ID = PEL.ELEMENT_TYPE_ID AND PEL.ELEMENT_LINK_ID = PEE.ELEMENT_LINK_ID AND ASG.ASSIGNMENT_ID = PEE.ASSIGNMENT_ID AND PEE.CREATOR_TYPE = 'SP' AND PEE.ELEMENT_ENTRY_ID= PEV.ELEMENT_ENTRY_ID AND PEV.INPUT_VALUE_ID = PIV.INPUT_VALUE_ID AND ASG.EFFECTIVE_START_DATE BETWEEN PRL.EFFECTIVE_START_DATE
AND PRL.EFFECTIVE_END_DATE AND HR_PAY_INTERFACE_PKG.GET_EXTRACT_DATE BETWEEN PP.EFFECTIVE_START_DATE
AND PP.EFFECTIVE_END_DATE AND ASG.EFFECTIVE_START_DATE = (SELECT MAX(ASG2.EFFECTIVE_START_DATE) FROM PER_ALL_ASSIGNMENTS_F ASG2
WHERE ASG2.ASSIGNMENT_ID = ASG.ASSIGNMENT_ID
AND ASG2.EFFECTIVE_START_DATE <= HR_PAY_INTERFACE_PKG.GET_EXTRACT_DATE ) AND PIV.EFFECTIVE_START_DATE BETWEEN PET.EFFECTIVE_START_DATE
AND PET.EFFECTIVE_END_DATE AND NVL(PPP.CHANGE_DATE
, ASG.EFFECTIVE_START_DATE) BETWEEN PIV.EFFECTIVE_START_DATE
AND PIV.EFFECTIVE_END_DATE AND PPP.CHANGE_DATE = PEE.EFFECTIVE_START_DATE AND HR_PAY_INTERFACE_PKG.GET_EXTRACT_DATE BETWEEN PET.EFFECTIVE_START_DATE
AND PET.EFFECTIVE_END_DATE AND HR_PAY_INTERFACE_PKG.GET_EXTRACT_DATE BETWEEN PEL.EFFECTIVE_START_DATE
AND PEL.EFFECTIVE_END_DATE AND HR_PAY_INTERFACE_PKG.GET_EXTRACT_DATE BETWEEN PEE.EFFECTIVE_START_DATE
AND PEE.EFFECTIVE_END_DATE AND HR_PAY_INTERFACE_PKG.GET_EXTRACT_DATE BETWEEN PEV.EFFECTIVE_START_DATE
AND PEV.EFFECTIVE_END_DATE