FND Design Data [Home] [Help]

Table: PA_STD_BILL_RATE_SCHEDULES_ALL

Product: PA - Projects
Description: Sets of standard bill rates that can be assigned as groups to projects and tasks
Implementation/DBA Data: TablePA.PA_STD_BILL_RATE_SCHEDULES_ALL
Primary Key: PA_STD_BILL_RATE_SCHEDULES_PK
  1. ColumnORGANIZATION_ID
  2. ColumnSTD_BILL_RATE_SCHEDULE
  3. ColumnORG_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
PA_STD_BILL_RATE_SCHEDULES_ALL FK Joins to TableHR_ALL_ORGANIZATION_UNITS PA_STD_BILL_RATE_SCHEDULES_ALL.ORGANIZATION_ID
PA_STD_BILL_RATE_SCHEDULES_ALL FK Joins to TableFND_CURRENCIES PA_STD_BILL_RATE_SCHEDULES_ALL.RATE_SCH_CURRENCY_CODE
TablePA_BILL_RATES_ALL FK Joins to PA_STD_BILL_RATE_SCHEDULES_ALL PA_BILL_RATES_ALL.BILL_RATE_ORGANIZATION_ID
PA_BILL_RATES_ALL.STD_BILL_RATE_SCHEDULE
PA_BILL_RATES_ALL.ORG_ID
TablePA_PROJECTS_ALL FK Joins to PA_STD_BILL_RATE_SCHEDULES_ALL PA_PROJECTS_ALL.LABOR_BILL_RATE_ORG_ID
PA_PROJECTS_ALL.LABOR_STD_BILL_RATE_SCHDL
PA_PROJECTS_ALL.ORG_ID
TablePA_PROJECTS_ALL FK Joins to PA_STD_BILL_RATE_SCHEDULES_ALL PA_PROJECTS_ALL.NON_LABOR_BILL_RATE_ORG_ID
PA_PROJECTS_ALL.NON_LABOR_STD_BILL_RATE_SCHDL
PA_PROJECTS_ALL.ORG_ID
TablePA_PROJECT_TYPES_ALL FK Joins to PA_STD_BILL_RATE_SCHEDULES_ALL PA_PROJECT_TYPES_ALL.LABOR_BILL_RATE_ORG_ID
PA_PROJECT_TYPES_ALL.LABOR_STD_BILL_RATE_SCHDL
PA_PROJECT_TYPES_ALL.ORG_ID
TablePA_PROJECT_TYPES_ALL FK Joins to PA_STD_BILL_RATE_SCHEDULES_ALL PA_PROJECT_TYPES_ALL.NON_LABOR_BILL_RATE_ORG_ID
PA_PROJECT_TYPES_ALL.NON_LABOR_STD_BILL_RATE_SCHDL
PA_PROJECT_TYPES_ALL.ORG_ID