VIEW: APPS.PAY_PAYAUTAX_AUS_INF_V

Source

View Text - Preformatted

SELECT /* $Header: perau.odf 120.5.12020000.2 2012/07/04 21:30:14 amnaraya 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') ) )

View Text - HTML Formatted

SELECT /* $HEADER: PERAU.ODF 120.5.12020000.2 2012/07/04 21:30:14 AMNARAYA 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') ) )