eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.PAY_TRR_PACT_VSET_V

Source

View Text - Preformatted


SELECT PACT.EFFECTIVE_DATE , PACT.BUSINESS_GROUP_ID FROM PAY_PAYROLL_ACTIONS PACT , HR_LOOKUPS HL WHERE PACT.ACTION_TYPE IN ('Q','R','V') AND HL.LOOKUP_CODE = PACT.ACTION_TYPE AND HL.LOOKUP_TYPE = 'ACTION_TYPE' GROUP BY PACT.EFFECTIVE_DATE , PACT.BUSINESS_GROUP_ID

View Text - HTML Formatted

SELECT PACT.EFFECTIVE_DATE
, PACT.BUSINESS_GROUP_ID
FROM PAY_PAYROLL_ACTIONS PACT
, HR_LOOKUPS HL
WHERE PACT.ACTION_TYPE IN ('Q'
, 'R'
, 'V')
AND HL.LOOKUP_CODE = PACT.ACTION_TYPE
AND HL.LOOKUP_TYPE = 'ACTION_TYPE' GROUP BY PACT.EFFECTIVE_DATE
, PACT.BUSINESS_GROUP_ID