VIEW: APPS.PSB_POSITION_ASSIGN_ELEMENT_V

Source

View Text - Preformatted

SELECT pas.rowid, pas.position_assignment_id, pas.element_value_type, pas.data_extract_id, pas.worksheet_id, pas.position_id, pas.assignment_type, pas.pay_element_id, pas.pay_element_option_id, pas.pay_element_rate_id, pas.effective_start_date, pas.effective_end_date, pas.element_value, pas.global_default_flag, pas.assignment_default_rule_id, pas.modify_flag, pas.pay_basis, pas.currency_code, pas.employee_id, pas.last_update_date, pas.last_updated_by, pas.last_update_login, pas.created_by, pas.creation_date, pe.overwrite_flag, pe.salary_type, pe.option_flag, pe.name, peo.name, peo.grade_step, pe.salary_flag, peo.sequence_number from psb_position_assignments_v pas, psb_pay_elements pe, psb_pay_element_options peo where pas.assignment_type = 'ELEMENT' and pas.pay_element_id = pe.pay_element_id and pas.pay_element_option_id = peo.pay_element_option_id (+)

View Text - HTML Formatted

SELECT PAS.ROWID
, PAS.POSITION_ASSIGNMENT_ID
, PAS.ELEMENT_VALUE_TYPE
, PAS.DATA_EXTRACT_ID
, PAS.WORKSHEET_ID
, PAS.POSITION_ID
, PAS.ASSIGNMENT_TYPE
, PAS.PAY_ELEMENT_ID
, PAS.PAY_ELEMENT_OPTION_ID
, PAS.PAY_ELEMENT_RATE_ID
, PAS.EFFECTIVE_START_DATE
, PAS.EFFECTIVE_END_DATE
, PAS.ELEMENT_VALUE
, PAS.GLOBAL_DEFAULT_FLAG
, PAS.ASSIGNMENT_DEFAULT_RULE_ID
, PAS.MODIFY_FLAG
, PAS.PAY_BASIS
, PAS.CURRENCY_CODE
, PAS.EMPLOYEE_ID
, PAS.LAST_UPDATE_DATE
, PAS.LAST_UPDATED_BY
, PAS.LAST_UPDATE_LOGIN
, PAS.CREATED_BY
, PAS.CREATION_DATE
, PE.OVERWRITE_FLAG
, PE.SALARY_TYPE
, PE.OPTION_FLAG
, PE.NAME
, PEO.NAME
, PEO.GRADE_STEP
, PE.SALARY_FLAG
, PEO.SEQUENCE_NUMBER
FROM PSB_POSITION_ASSIGNMENTS_V PAS
, PSB_PAY_ELEMENTS PE
, PSB_PAY_ELEMENT_OPTIONS PEO
WHERE PAS.ASSIGNMENT_TYPE = 'ELEMENT'
AND PAS.PAY_ELEMENT_ID = PE.PAY_ELEMENT_ID
AND PAS.PAY_ELEMENT_OPTION_ID = PEO.PAY_ELEMENT_OPTION_ID (+)