[Home] [Help]
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"
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"
|
|
|
|