VIEW: APPS.PA_CC_TP_BILL_SCH_ORGZN_V

Source

View Text - Preformatted

SELECT distinct h.name, b.ORGANIZATION_id, b.ORG_id, b.schedule_type, b.bill_rate_sch_id, b.std_bill_rate_schedule FROM pa_std_bill_rate_schedules_all b, hr_ORGANIZATION_units h WHERE h.ORGANIZATION_id = b.ORGANIZATION_id

View Text - HTML Formatted

SELECT DISTINCT H.NAME
, B.ORGANIZATION_ID
, B.ORG_ID
, B.SCHEDULE_TYPE
, B.BILL_RATE_SCH_ID
, B.STD_BILL_RATE_SCHEDULE
FROM PA_STD_BILL_RATE_SCHEDULES_ALL B
, HR_ORGANIZATION_UNITS H
WHERE H.ORGANIZATION_ID = B.ORGANIZATION_ID