Product: | PAY - Payroll |
---|---|
Description: | Report view |
Implementation/DBA Data: | APPS.PAY_ASGS_WITHOUT_PAYROLLS_V |
SELECT PER.FULL_NAME
, PER.ORDER_NAME
, PER.EFFECTIVE_START_DATE PERSON_START_DATE
, PER.EFFECTIVE_END_DATE PERSON_END_DATE
, ORG.NAME ORGANIZATION_NAME
, ASG.ASSIGNMENT_NUMBER
, ASG.EFFECTIVE_START_DATE ASSIGN_START_DATE
, ASG.EFFECTIVE_END_DATE ASSIGN_END_DATE
, STA.USER_STATUS USER_STATUS
, LOC.LOCATION_CODE ADDRESS
, PER.PERSON_ID
, ASG.ASSIGNMENT_ID
, ASG.BUSINESS_GROUP_ID
, STA.ASSIGNMENT_STATUS_TYPE_ID
, ORG.ORGANIZATION_ID
, LOC.LOCATION_ID
, TYP.PERSON_TYPE_ID
FROM PER_PEOPLE_F PER
, PER_ASSIGNMENTS_F ASG
, PER_ASSIGNMENT_STATUS_TYPES STA
, HR_ORGANIZATION_UNITS ORG
, HR_LOCATIONS LOC
, PER_PERSON_TYPES TYP
WHERE PER.PERSON_ID = ASG.PERSON_ID
AND PER.PERSON_TYPE_ID = TYP.PERSON_TYPE_ID
AND STA.ASSIGNMENT_STATUS_TYPE_ID = ASG.ASSIGNMENT_STATUS_TYPE_ID
AND ORG.ORGANIZATION_ID = ASG.ORGANIZATION_ID
AND LOC.LOCATION_ID(+)= ASG.LOCATION_ID
AND STA.PAY_SYSTEM_STATUS = 'P'
AND TYP.SYSTEM_PERSON_TYPE IN ('EMP'
, 'EX_EMP'
, 'EMP_APL')
AND ASG.EFFECTIVE_START_DATE <= PER.EFFECTIVE_END_DATE
AND ASG.EFFECTIVE_END_DATE >= PER.EFFECTIVE_START_DATE
AND ASG.PAYROLL_ID IS NULL