View: PAY_TRR_PACT_VSET_V

Product:	PAY - Payroll
Description:	-Retrofitted - Retrofitted
Implementation/DBA Data:	APPS.PAY_TRR_PACT_VSET_V

View Text

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

Columns