View: PAY_PAYAUTAX_AUS_INF_V

Product:	PER - Human Resources
Description:
Implementation/DBA Data:	APPS.PAY_PAYAUTAX_AUS_INF_V

View Text

SELECT /* $HEADER: PERVIEW.LDT 115.53 2002/06/11 11:28:39 PKM SHIP $ */ ASG.PERSON_ID
, ASG.ASSIGNMENT_ID
, SCL.SEGMENT2
, SCL.SEGMENT1
FROM PER_ALL_ASSIGNMENTS_F ASG
, HR_SOFT_CODING_KEYFLEX SCL
WHERE SCL.SOFT_CODING_KEYFLEX_ID = ASG.SOFT_CODING_KEYFLEX_ID
AND ( ASG.EFFECTIVE_START_DATE <= ( SELECT TRUNC(FS.EFFECTIVE_DATE)
FROM FND_SESSIONS FS
WHERE FS.SESSION_ID = USERENV('SESSIONID') ) AND ASG.EFFECTIVE_END_DATE >= ( SELECT TRUNC(FS.EFFECTIVE_DATE)
FROM FND_SESSIONS FS
WHERE FS.SESSION_ID = USERENV('SESSIONID') ) )

Columns