DBA Data[Home] [Help]

VIEW: APPS.PA_EMPLOYEE_SCHEDULES_LOV_V

Source

View Text - Preformatted

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'
View Text - HTML Formatted

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'