VIEW: APPS.PQP_PROFESSIONAL_BODY_TEMP_V

Source

View Text - Preformatted

SELECT petf.element_type_id ,petf.business_group_id ,petf.legislation_code ,petf.classification_id ,pec.classification_name ,petf.processing_type ,petf.element_name ,petf.reporting_name ,petf.description ,petei.eei_information1 organization_id ,hou.name professional_body_name ,petei.eei_information2 professional_body_level_bal ,petei.eei_information3 override_amount ,petei.eei_information4 third_party_payment ,petf.last_update_date ,petf.last_updated_by ,petf.last_update_login ,petf.created_by ,petf.creation_date FROM pay_element_types_f petf ,pay_element_type_extra_info petei ,pay_element_classifications pec ,hr_all_organization_units hou ,hr_organization_information hoi ,fnd_sessions ses WHERE petf.element_type_id = petei.element_type_id AND petei.eei_information1 = TO_CHAR(hou.organization_id) AND hou.organization_id = hoi.organization_id AND hoi.org_information_context = 'CLASS' AND hoi.org_information1 = 'PB' AND petei.information_type ='PQP_PROFESSIONAL_BODY_INFO' AND pec.classification_id = petf.classification_id AND ses.session_id = USERENV('sessionid') AND ses.effective_date BETWEEN petf.effective_start_date AND petf.effective_end_date

View Text - HTML Formatted

SELECT PETF.ELEMENT_TYPE_ID
, PETF.BUSINESS_GROUP_ID
, PETF.LEGISLATION_CODE
, PETF.CLASSIFICATION_ID
, PEC.CLASSIFICATION_NAME
, PETF.PROCESSING_TYPE
, PETF.ELEMENT_NAME
, PETF.REPORTING_NAME
, PETF.DESCRIPTION
, PETEI.EEI_INFORMATION1 ORGANIZATION_ID
, HOU.NAME PROFESSIONAL_BODY_NAME
, PETEI.EEI_INFORMATION2 PROFESSIONAL_BODY_LEVEL_BAL
, PETEI.EEI_INFORMATION3 OVERRIDE_AMOUNT
, PETEI.EEI_INFORMATION4 THIRD_PARTY_PAYMENT
, PETF.LAST_UPDATE_DATE
, PETF.LAST_UPDATED_BY
, PETF.LAST_UPDATE_LOGIN
, PETF.CREATED_BY
, PETF.CREATION_DATE
FROM PAY_ELEMENT_TYPES_F PETF
, PAY_ELEMENT_TYPE_EXTRA_INFO PETEI
, PAY_ELEMENT_CLASSIFICATIONS PEC
, HR_ALL_ORGANIZATION_UNITS HOU
, HR_ORGANIZATION_INFORMATION HOI
, FND_SESSIONS SES
WHERE PETF.ELEMENT_TYPE_ID = PETEI.ELEMENT_TYPE_ID
AND PETEI.EEI_INFORMATION1 = TO_CHAR(HOU.ORGANIZATION_ID)
AND HOU.ORGANIZATION_ID = HOI.ORGANIZATION_ID
AND HOI.ORG_INFORMATION_CONTEXT = 'CLASS'
AND HOI.ORG_INFORMATION1 = 'PB'
AND PETEI.INFORMATION_TYPE ='PQP_PROFESSIONAL_BODY_INFO'
AND PEC.CLASSIFICATION_ID = PETF.CLASSIFICATION_ID
AND SES.SESSION_ID = USERENV('SESSIONID')
AND SES.EFFECTIVE_DATE BETWEEN PETF.EFFECTIVE_START_DATE
AND PETF.EFFECTIVE_END_DATE