Product: | PSP - Labor Distribution |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT PPS.PAYROLL_SUB_LINE_ID
, PPS.SUB_LINE_START_DATE
, PPS.SUB_LINE_END_DATE
, PPS.ASSIGNMENT_END_DATE
, '_LA:REASON_CODE:PSP_LOOKUPS:PSP_SUBLINE_REASONS:MEANING'
, PPS.PAY_AMOUNT
, PPS.DAILY_RATE
, PPS.SALARY_USED
, PPS.CURRENT_SALARY
, PPS.FTE
, PPS.EMPLOYMENT_BEGIN_DATE
, PPS.EMPLOYMENT_END_DATE
, PPS.EMPLOYEE_STATUS_INACTIVE_DATE
, PPS.EMPLOYEE_STATUS_ACTIVE_DATE
, PPS.ASSIGNMENT_BEGIN_DATE
, PPS.ORGANIZATION_ID
, PPS.JOB_ID
, PPS.POSITION_ID
, PPS.PAYROLL_LINE_ID
, PPS.LAST_UPDATE_DATE
, PPS.LAST_UPDATED_BY
, PPS.CREATED_BY
, PPS.CREATION_DATE
, HOU.NAME
, PJ.NAME
, PP.NAME
FROM PSP_PAYROLL_SUB_LINES PPS
, HR_ORGANIZATION_UNITS HOU
, PER_JOBS PJ
, PER_POSITIONS PP
WHERE PPS.ORGANIZATION_ID = HOU.ORGANIZATION_ID(+)
AND (PPS.JOB_ID = PJ.JOB_ID(+)
AND PPS.SUB_LINE_END_DATE BETWEEN PJ.DATE_FROM(+)
AND PJ.DATE_TO(+))
AND (PPS.POSITION_ID = PP.POSITION_ID(+)
AND PPS.SUB_LINE_END_DATE BETWEEN PP.DATE_EFFECTIVE(+)
AND DATE_END(+))
AND '_SEC:PPS.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY