View: PA_EMPLOYEE_SCHEDULES_LOV_V

Product:	PA - Projects
Description:	This view displays all the defined employee schedule values.
Implementation/DBA Data:	APPS.PA_EMPLOYEE_SCHEDULES_LOV_V

View Text

SELECT BRS.BILL_RATE_SCH_ID
, BRS.STD_BILL_RATE_SCHEDULE
, BRS.RATE_SCH_CURRENCY_CODE
, BRS.SHARE_ACROSS_OU_FLAG
, BRS.ORGANIZATION_ID
, O.NAME
, BRS.ORG_ID
, OU.NAME
FROM PA_STD_BILL_RATE_SCHEDULES_ALL BRS
, HR_ALL_ORGANIZATION_UNITS O
, HR_ALL_ORGANIZATION_UNITS OU
WHERE BRS.ORGANIZATION_ID=O.ORGANIZATION_ID
AND BRS.ORG_ID=OU.ORGANIZATION_ID
AND BRS.SCHEDULE_TYPE='EMPLOYEE'

Columns