DBA Data[Home] [Help]
Skip to content

VIEW: HR.PAY_GB_FPS_DETAILS#

Source

View Text - Preformatted

select PAYROLL_EFFECTIVE_DATE PAYROLL_EFFECTIVE_DATE, PAYROLL_PAY_ACT_ID PAYROLL_PAY_ACT_ID, PAYROLL_ASG_ACT_ID PAYROLL_ASG_ACT_ID, PREPAY_EFFECTIVE_DATE PREPAY_EFFECTIVE_DATE, PREPAY_PAY_ACT_ID PREPAY_PAY_ACT_ID, PREPAY_ASG_ACT_ID PREPAY_ASG_ACT_ID, FPS_EFFECTIVE_DATE FPS_EFFECTIVE_DATE, FPS_PAY_ACT_ID FPS_PAY_ACT_ID, FPS_ASG_ACT_ID FPS_ASG_ACT_ID, PERSON_ID PERSON_ID, ASSIGNMENT_ID ASSIGNMENT_ID from "HR"."PAY_GB_FPS_DETAILS"
View Text - HTML Formatted

SELECT PAYROLL_EFFECTIVE_DATE PAYROLL_EFFECTIVE_DATE
, PAYROLL_PAY_ACT_ID PAYROLL_PAY_ACT_ID
, PAYROLL_ASG_ACT_ID PAYROLL_ASG_ACT_ID
, PREPAY_EFFECTIVE_DATE PREPAY_EFFECTIVE_DATE
, PREPAY_PAY_ACT_ID PREPAY_PAY_ACT_ID
, PREPAY_ASG_ACT_ID PREPAY_ASG_ACT_ID
, FPS_EFFECTIVE_DATE FPS_EFFECTIVE_DATE
, FPS_PAY_ACT_ID FPS_PAY_ACT_ID
, FPS_ASG_ACT_ID FPS_ASG_ACT_ID
, PERSON_ID PERSON_ID
, ASSIGNMENT_ID ASSIGNMENT_ID
FROM "HR"."PAY_GB_FPS_DETAILS"