DBA Data[Home] [Help]

VIEW: APPS.PQH_DE_RR_GRADE_V

Source

View Text - Preformatted

SELECT Pay_Grade , Pay_Grade_Id , Emp_Id , Business_Group_Id , Date_From , Date_To from PQH_DE_RR_GRADE1_V union select Pay_Grade , Pay_Grade_Id , Emp_Id , Business_Group_Id , Date_From , Date_To from PQH_DE_RR_GRADE2_V
View Text - HTML Formatted

SELECT PAY_GRADE
, PAY_GRADE_ID
, EMP_ID
, BUSINESS_GROUP_ID
, DATE_FROM
, DATE_TO
FROM PQH_DE_RR_GRADE1_V UNION SELECT PAY_GRADE
, PAY_GRADE_ID
, EMP_ID
, BUSINESS_GROUP_ID
, DATE_FROM
, DATE_TO
FROM PQH_DE_RR_GRADE2_V