DBA Data[Home] [Help] [Dependency Information]


VIEW: APPS.PER_BUSINESS_GROUPS_PERF

Object Details
Object Name: PER_BUSINESS_GROUPS_PERF
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPER.PER_BUSINESS_GROUPS_PERF
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
BUSINESS_GROUP_ID NUMBER (15) Yes
NAME VARCHAR2 (240) Yes
DATE_FROM DATE
Yes
DATE_TO DATE


INTERNAL_ADDRESS_LINE VARCHAR2 (80)

LOCATION_ID NUMBER (15)

COMMENTS CLOB (4000)

SHORT_NAME VARCHAR2 (150)

METHOD_OF_GENERATION_EMP_NUM VARCHAR2 (150)

METHOD_OF_GENERATION_APL_NUM VARCHAR2 (150)

METHOD_OF_GENERATION_CWK_NUM VARCHAR2 (150)
GRADE_STRUCTURE VARCHAR2 (150)

PEOPLE_GROUP_STRUCTURE VARCHAR2 (150)

JOB_STRUCTURE VARCHAR2 (150)

COST_ALLOCATION_STRUCTURE VARCHAR2 (150)

POSITION_STRUCTURE VARCHAR2 (150)

LEGISLATION_CODE VARCHAR2 (150)

CURRENCY_CODE VARCHAR2 (150)

ENABLED_FLAG VARCHAR2 (150)

COMPETENCE_STRUCTURE VARCHAR2 (150)
SECURITY_GROUP_ID VARCHAR2 (150)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT BUSINESS_GROUP_ID
,      NAME
,      DATE_FROM
,      DATE_TO
,      INTERNAL_ADDRESS_LINE
,      LOCATION_ID
,      COMMENTS
,      SHORT_NAME
,      METHOD_OF_GENERATION_EMP_NUM
,      METHOD_OF_GENERATION_APL_NUM
,      METHOD_OF_GENERATION_CWK_NUM
,      GRADE_STRUCTURE
,      PEOPLE_GROUP_STRUCTURE
,      JOB_STRUCTURE
,      COST_ALLOCATION_STRUCTURE
,      POSITION_STRUCTURE
,      LEGISLATION_CODE
,      CURRENCY_CODE
,      ENABLED_FLAG
,      COMPETENCE_STRUCTURE
,      SECURITY_GROUP_ID
FROM APPS.PER_BUSINESS_GROUPS_PERF;

Dependencies

[top of page]

APPS.PER_BUSINESS_GROUPS_PERF references the following:

SchemaAPPS
SynonymHR_ALL_ORGANIZATION_UNITS
SynonymHR_ORGANIZATION_INFORMATION
APPS.PER_BUSINESS_GROUPS_PERF is referenced by following:

SchemaAPPS
Package BodyAME_AYL_BUS - show dependent code
Package BodyAME_ITL_BUS - show dependent code
Package BodyAME_RTL_BUS - show dependent code
Package BodyBEN_ACT_BUS - show dependent code
Package BodyBEN_BCI_BUS - show dependent code
Package BodyBEN_BCM_BUS - show dependent code
Package BodyBEN_BEO_BUS - show dependent code
Package BodyBEN_BEP_BUS - show dependent code
Package BodyBEN_BER_BUS - show dependent code
Package BodyBEN_CPE_BUS - show dependent code
Package BodyBEN_CSO_BUS - show dependent code
Package BodyBEN_CWB_BACKOUT_POST_PROCESS - show dependent code
ViewBEN_CWB_EQUITY_EDGE_ACT_INFO_V
Package BodyBEN_CWB_MASS_NOTIFN_PKG - show dependent code
Package BodyBEN_CWB_POST_PROCESS - show dependent code
ViewBEN_CWB_REPT_COMP_COMPARISON_V
ViewBEN_CWB_REPT_STOCK_DETAIL_V
Package BodyBEN_CWG_BUS - show dependent code
Package BodyBEN_ELEMENT_ENTRY - show dependent code
Package BodyBEN_ESW_BUS - show dependent code
Package BodyBEN_EXTRACT - show dependent code
Package BodyBEN_EXTRACT_SEED - show dependent code
TriggerBEN_EXT_ASG_EVT
Package BodyBEN_EXT_FMT - show dependent code
Package BodyBEN_EXT_PERSON - show dependent code
Package BodyBEN_PDT_BUS - show dependent code
Package BodyBEN_TCS_STMT_PROCESS - show dependent code
Package BodyBEN_XCV_BUS - show dependent code
Package BodyBEN_XDF_BUS - show dependent code
Package BodyBEN_XIC_BUS - show dependent code
Package BodyFFDICT - show dependent code
Package BodyFF_EXEC - show dependent code
Package BodyFF_FCU_BUS - show dependent code
Package BodyFF_FFN_BUS - show dependent code
Package BodyFF_FFP_BUS - show dependent code
Package BodyFF_FFT_BUS - show dependent code
Package BodyFF_FGL_BUS - show dependent code
Package BodyFF_FGT_BUS - show dependent code
Package BodyFF_FORMULA_WEBUI_PKG - show dependent code
Package BodyHRASSACT - show dependent code
Package BodyHRDYNDBI - show dependent code
Package BodyHRENTMNT - show dependent code
Package BodyHR_API - show dependent code
Package BodyHR_APPLICANT_API - show dependent code
Package BodyHR_APPLICANT_INTERNAL - show dependent code
Package BodyHR_ASSIGNMENT_API - show dependent code
Package BodyHR_ASSIGNMENT_INTERNAL - show dependent code
Package BodyHR_BALANCE_FEEDS - show dependent code
ViewHR_CALENDAR_ENTITY_KEYS_V
ViewHR_CAL_PEOPLE_KEYS_V
Package BodyHR_CAU_BUS - show dependent code
Package BodyHR_DATA_PUMP - show dependent code
Package BodyHR_DEI_BUS - show dependent code
Package BodyHR_DYNSQL - show dependent code
ViewHR_EMPLOYEES
ViewHR_EMPLOYEES_CURRENT_V
Package BodyHR_ENTRY_API - show dependent code
Package BodyHR_FI_QUALIFICATION_API - show dependent code
Package BodyHR_FR_PQH_EMPLOYEE_API - show dependent code
Package BodyHR_GENERAL - show dependent code
Package BodyHR_GENERAL2 - show dependent code
Package BodyHR_GRADE_API - show dependent code
Package BodyHR_JP_DATA_MIGRATION_PKG - show dependent code
ViewHR_LEG_ESTABLISHMENTS_V
Package BodyHR_LOC_ABSENCE - show dependent code
Package BodyHR_NMF_SYNC - show dependent code
Package BodyHR_NO_QUALIFICATION_API - show dependent code
Package BodyHR_ORGANIZATION_API - show dependent code
Package BodyHR_ORU_BUS - show dependent code
Package BodyHR_PDC_BUS - show dependent code
Package BodyHR_PDE_BUS - show dependent code
Package BodyHR_PDT_BUS - show dependent code
Package BodyHR_PERSON - show dependent code
Package BodyHR_PERSON_API - show dependent code
Package BodyHR_PERSON_NAME - show dependent code
Package BodyHR_PRE_PAY - show dependent code
PL/SQL PackageHR_PRE_PAY - show dependent code
Package BodyHR_PROCESS_PERSON_SS - show dependent code
Package BodyHR_RATE_VALUES_API - show dependent code
Package BodyHR_SNP_BUS - show dependent code
Package BodyHXC_ERR_BUS - show dependent code
Package BodyHXC_HAN_BUS - show dependent code
Package BodyHXC_HSD_BUS - show dependent code
Package BodyHXC_LCK_BUS - show dependent code
Package BodyHXC_LKR_BUS - show dependent code
PL/SQL PackageHXT_INTERFACE_UTILITIES - show dependent code
Package BodyHXT_INTERFACE_UTILITIES - show dependent code
Package BodyHXT_UTIL - show dependent code
Package BodyICX_POR_EXT_DIAG - show dependent code
Package BodyINVPVDR5 - show dependent code
Package BodyIRC_APS_BUS - show dependent code
Package BodyIRC_CMC_BUS - show dependent code
Package BodyIRC_CMM_BUS - show dependent code
Package BodyIRC_CMP_BUS - show dependent code
Package BodyIRC_CMR_BUS - show dependent code
Package BodyIRC_CMT_BUS - show dependent code
Package BodyIRC_IAD_BUS - show dependent code
Package BodyIRC_IAS_BUS - show dependent code
Package BodyIRC_IAV_BUS - show dependent code
Package BodyIRC_ILC_BUS - show dependent code
Package BodyIRC_IOF_BUS - show dependent code
Package BodyIRC_IOS_BUS - show dependent code
Package BodyIRC_ITA_BUS - show dependent code
Package BodyIRC_PARTY_API - show dependent code
Package BodyOTA_ACI_BUS - show dependent code
Package BodyOTA_ANC_BUS - show dependent code
Package BodyOTA_ANT_BUS - show dependent code
Package BodyOTA_AVT_BUS - show dependent code
Package BodyOTA_BJS_BUS - show dependent code
Package BodyOTA_BJT_BUS - show dependent code
Package BodyOTA_BST_API - show dependent code
Package BodyOTA_CCI_BUS - show dependent code
Package BodyOTA_CFS_BUS - show dependent code
Package BodyOTA_CFT_BUS - show dependent code
Package BodyOTA_CHA_BUS - show dependent code
Package BodyOTA_CHT_BUS - show dependent code
Package BodyOTA_CMB_BUS - show dependent code
Package BodyOTA_CME_BUS - show dependent code
Package BodyOTA_CMS_BUS - show dependent code
Package BodyOTA_COI_BUS - show dependent code
Package BodyOTA_CPE_BUS - show dependent code
Package BodyOTA_CPR_BUS - show dependent code
Package BodyOTA_CRE_BUS - show dependent code
Package BodyOTA_CRT_BUS - show dependent code
Package BodyOTA_CTL_BUS - show dependent code
Package BodyOTA_CTT_BUS - show dependent code
Package BodyOTA_CTU_BUS - show dependent code
Package BodyOTA_CUS_BUS - show dependent code
Package BodyOTA_EVT_BUS - show dependent code
Package BodyOTA_FCE_BUS - show dependent code
Package BodyOTA_FMS_BUS - show dependent code
Package BodyOTA_FMT_BUS - show dependent code
Package BodyOTA_FNS_BUS - show dependent code
Package BodyOTA_FOI_BUS - show dependent code
Package BodyOTA_FRM_BUS - show dependent code
Package BodyOTA_FTS_BUS - show dependent code
Package BodyOTA_FTU_BUS - show dependent code
Package BodyOTA_LCI_BUS - show dependent code
Package BodyOTA_LME_BUS - show dependent code
Package BodyOTA_LPC_BUS - show dependent code
Package BodyOTA_LPE_BUS - show dependent code
Package BodyOTA_LPM_BUS - show dependent code
Package BodyOTA_LPS_BUS - show dependent code
Package BodyOTA_LPT_BUS - show dependent code
Package BodyOTA_LST_BUS - show dependent code
Package BodyOTA_OFF_BUS - show dependent code
Package BodyOTA_ONT_BUS - show dependent code
Package BodyOTA_RUD_BUS - show dependent code
Package BodyOTA_TDB_BUS - show dependent code
Package BodyOTA_TFH_API_BUS - show dependent code
Package BodyOTA_TFL_API_BUS - show dependent code
Package BodyOTA_THG_BUS - show dependent code
Package BodyOTA_TRB_BUS - show dependent code
Package BodyOTA_TSP_BUS - show dependent code
Package BodyOTA_TSR_BUS - show dependent code
Package BodyPAYPLNK - show dependent code
Package BodyPAY_AMO_BUS - show dependent code
Package BodyPAY_AMP_BUS - show dependent code
Package BodyPAY_APM_BUS - show dependent code
Package BodyPAY_APP_BUS - show dependent code
Package BodyPAY_APR_BUS - show dependent code
Package BodyPAY_ASG_PROCESS_GRP_PKG - show dependent code
Package BodyPAY_AU_TAX_INFO_PKG - show dependent code
ViewPAY_BALANCES_V
Package BodyPAY_BALANCE_PKG - show dependent code
Package BodyPAY_BALANCE_TYPES_PKG - show dependent code
Package BodyPAY_BALANCE_UPLOAD - show dependent code
Package BodyPAY_BDT_BUS - show dependent code
Package BodyPAY_BLD_BUS - show dependent code
Package BodyPAY_BLT_BUS - show dependent code
Package BodyPAY_BTT_BUS - show dependent code
Package BodyPAY_CE_RECONCILIATION_PKG - show dependent code
Package BodyPAY_CORE_FF_UDFS - show dependent code
Package BodyPAY_CORE_UPGRADE_PKG - show dependent code
Package BodyPAY_CORE_UTILS - show dependent code
Package BodyPAY_DK_ABSR_PKG - show dependent code
Package BodyPAY_DK_TC_DP_UPLOAD - show dependent code
Package BodyPAY_ECU_BUS - show dependent code
Package BodyPAY_EGU_BUS - show dependent code
Package BodyPAY_ELEMENT_TEMPLATE_UTIL - show dependent code
Package BodyPAY_EST_BUS - show dependent code
Package BodyPAY_ESU_BUS - show dependent code
Package BodyPAY_ETM_BUS - show dependent code
Package BodyPAY_FRR_BUS - show dependent code
Package BodyPAY_FR_BAL_UPLOAD - show dependent code
Package BodyPAY_GB_ENH_RETRO_PAY - show dependent code
Package BodyPAY_GENERIC_UPGRADE - show dependent code
PL/SQL PackagePAY_HR_OTC_RETRIEVAL_INTERFACE - show dependent code
Package BodyPAY_HR_OTC_RETRIEVAL_INTERFACE - show dependent code
Package BodyPAY_INTERPRETER_PKG - show dependent code
Package BodyPAY_ITERATE - show dependent code
Package BodyPAY_JP_BAL_UPLOAD - show dependent code
Package BodyPAY_JP_DATA_MIGRATION_PKG - show dependent code
Package BodyPAY_JP_DEF_ARCHIVE - show dependent code
Package BodyPAY_JP_DEF_REPORT_PKG - show dependent code
Package BodyPAY_JP_DEF_SS - show dependent code
PL/SQL PackagePAY_JP_DEF_SS - show dependent code
Package BodyPAY_JP_DIMENSION_GENERATOR_PKG - show dependent code
Package BodyPAY_JP_FORMULA_FUNCTION_PKG - show dependent code
Package BodyPAY_JP_GENERIC_UPGRADE_PKG - show dependent code
ViewPAY_JP_GEPPEN_SANTEI_MT_V
Package BodyPAY_JP_ISDF_ARCHIVE_PKG - show dependent code
Package BodyPAY_JP_ITWB_ARCHIVE_PKG - show dependent code
Package BodyPAY_JP_ITWB_REPORT_PKG - show dependent code
ViewPAY_JP_SI_CHANGE_OF_ADDRESS_V
ViewPAY_JP_SI_DISQUALIFIED_MT_V
ViewPAY_JP_SI_DISQUALIFIED_V
ViewPAY_JP_SI_QUALIFIED_V
Package BodyPAY_JP_SPR_EFILE_PKG - show dependent code
ViewPAY_JP_UI_V
ViewPAY_KR_ASG_ELEMENTS_V
Package BodyPAY_KR_BAL_INIT_PKG - show dependent code
Package BodyPAY_KR_REPORT_PKG - show dependent code
Package BodyPAY_KR_YEA_PDF_PKG - show dependent code
Package BodyPAY_LIV_BUS - show dependent code
Package BodyPAY_MAG_TAPE - show dependent code
Package BodyPAY_PAYJPBON_XMLP_PKG - show dependent code
Package BodyPAY_PAYROLL_ACTIONS_PKG - show dependent code
Package BodyPAY_PAYROLL_API - show dependent code
Package BodyPAY_PAYWIEEH_PKG - show dependent code
Package BodyPAY_PAYWSDAS_PKG - show dependent code
Package BodyPAY_PAYWSMEE_PKG - show dependent code
Package BodyPAY_PAYWSQEE_PKG - show dependent code
Package BodyPAY_PAY_BUS - show dependent code
Package BodyPAY_PBF_BUS - show dependent code
Package BodyPAY_PCT_BUS - show dependent code
Package BodyPAY_PL_PAYE_API - show dependent code
Package BodyPAY_PL_SII_API - show dependent code
Package BodyPAY_PPD_BUS - show dependent code
Package BodyPAY_PPR_BUS - show dependent code
Package BodyPAY_PRF_BUS - show dependent code
Package BodyPAY_PSD_BUS - show dependent code
Package BodyPAY_PTT_BUS - show dependent code
Package BodyPAY_PURGE_PKG - show dependent code
Package BodyPAY_PUT_BUS - show dependent code
Package BodyPAY_PUT_SHD - show dependent code
Package BodyPAY_QPQ_API - show dependent code
Package BodyPAY_RAN_BUS - show dependent code
Package BodyPAY_RCU_BUS - show dependent code
Package BodyPAY_RETRO_PKG - show dependent code
Package BodyPAY_RETRO_UTILS_PKG - show dependent code
Package BodyPAY_RFM_BUS - show dependent code
Package BodyPAY_SF_BUS - show dependent code
Package BodyPAY_SIMULATOR_PKG - show dependent code
Package BodyPAY_SIMULATOR_SS_PKG - show dependent code
Package BodyPAY_SUB_CLASS_RULES_PKG - show dependent code
Package BodyPAY_TBC_BUS - show dependent code
Package BodyPAY_TDF_BUS - show dependent code
Package BodyPAY_TFU_BUS - show dependent code
Package BodyPAY_TRGL_PKG - show dependent code
Package BodyPAY_TXR_BUS - show dependent code
Package BodyPAY_URT_BUS - show dependent code
Package BodyPER_ABB_BUS - show dependent code
Package BodyPER_ABC_BUS - show dependent code
Package BodyPER_ABSENCE_ATTENDANCES_PKG3 - show dependent code
Package BodyPER_ABT_BUS - show dependent code
Package BodyPER_ASG_BUS1 - show dependent code
Package BodyPER_ASG_BUS2 - show dependent code
Package BodyPER_CAGR_APPLY_RESULTS_PKG - show dependent code
Package BodyPER_CEO_BUS - show dependent code
Package BodyPER_CKL_BUS - show dependent code
Package BodyPER_CNF_BUS - show dependent code
Package BodyPER_CNT_BUS - show dependent code
Package BodyPER_CPO_BUS - show dependent code
Package BodyPER_CTK_BUS - show dependent code
Package BodyPER_DISPLAY_ACCRUAL_BALANCE - show dependent code
Package BodyPER_ENT_BUS - show dependent code
Package BodyPER_ENV_BUS - show dependent code
Package BodyPER_FDL_BUS - show dependent code
Package BodyPER_JP_DEPENDENT_PKG - show dependent code
Package BodyPER_JP_EMPDET_ARCHIVE_PKG - show dependent code
Package BodyPER_PAC_BUS - show dependent code
Package BodyPER_PAT_BUS - show dependent code
Package BodyPER_PDP_BUS - show dependent code
Package BodyPER_PGH_BUS - show dependent code
Package BodyPER_PGN_BUS - show dependent code
Package BodyPER_PGS_BUS - show dependent code
Package BodyPER_PGV_BUS - show dependent code
Package BodyPER_PMS_BUS - show dependent code
Package BodyPER_PPB_BUS - show dependent code
Package BodyPER_PPS_BUS - show dependent code
Package BodyPER_PSH_BUS - show dependent code
Package BodyPER_PSP_BUS - show dependent code
Package BodyPER_QUA_BUS - show dependent code
Package BodyPER_REI_BUS - show dependent code
ViewPER_SECURITY_PROFILES_V
Package BodyPER_SEU_BUS - show dependent code
Package BodyPER_SIP_BUS - show dependent code
Package BodyPER_SPH_BUS - show dependent code
Package BodyPER_SPS_BUS - show dependent code
Package BodyPER_SSD_BUS - show dependent code
ViewPOR_APPROVER_LOV_V
ViewPOR_BUYER_LOV_V
ViewPOR_EMPLOYEE_LOV_V
Package BodyPOR_VIEW_REQS_PKG - show dependent code
ViewPO_BUYERS_ALL_V
ViewPO_BUYERS_VAL_V
Package BodyPO_COPYDOC_SUB - show dependent code
ViewPO_EMPLOYEES_CURRENT_X
Package BodyPO_PDOI_LINE_PROCESS_PVT - show dependent code
Package BodyPO_VAL_LINES2 - show dependent code
Package BodyPQH_CPD_BUS - show dependent code
Package BodyPQH_CRD_BUS - show dependent code
Package BodyPQH_CRE_BUS - show dependent code
Package BodyPQH_CRF_BUS - show dependent code
Package BodyPQH_CRL_BUS - show dependent code
Package BodyPQH_GIN_BUS - show dependent code
Package BodyPQH_GSP_UTILITY - show dependent code
Package BodyPQH_PQUBGTEN_XMLP_PKG - show dependent code
Package BodyPQH_PSU_BUS - show dependent code
Package BodyPQH_RAP_BUS - show dependent code
Package BodyPQH_RBC_LOAD_OBJECTS - show dependent code
Package BodyPQH_RER_BUS - show dependent code
Package BodyPQH_RFE_BUS - show dependent code
Package BodyPQH_RMN_BUS - show dependent code
Package BodyPQH_RMR_BUS - show dependent code
Package BodyPQH_RMV_BUS - show dependent code
Package BodyPQH_RNK_BUS - show dependent code
Package BodyPQH_STR_BUS - show dependent code
Package BodyPQH_STS_BUS - show dependent code
Package BodyPQH_TCD_BUS - show dependent code
Package BodyPQP_AAT_API - show dependent code
Package BodyPQP_ADDRESS_SYNCHRONIZATION - show dependent code
Package BodyPQP_BUDGET_MAINTENANCE - show dependent code
Package BodyPQP_FEDHR_USPAY_INTG_PKG - show dependent code
Package BodyPQP_FFA_BUS - show dependent code
Package BodyPQP_FTE_UTILITIES - show dependent code
Package BodyPQP_FXT_BUS - show dependent code
Package BodyPQP_GAP_BUS - show dependent code
Package BodyPQP_GB_PENSION_SCHEME_UPDATE - show dependent code
Package BodyPQP_GB_TP_EXT_PROCESS - show dependent code
Package BodyPQP_GDA_BUS - show dependent code
Package BodyPQP_GDS_BUS - show dependent code
Package BodyPQP_HROSS_INTEGRATION - show dependent code
Package BodyPQP_HRTCA_SYNCHRONIZATION - show dependent code
Package BodyPQP_ITERATIVE_ARREARAGE - show dependent code
Package BodyPQP_NL_PENSION_EXTRACTS - show dependent code
Package BodyPQP_NL_PGGM_PENSION_EXTRACTS - show dependent code
Package BodyPQP_PCV_BUS - show dependent code
Package BodyPQP_PENSION_EXTRACTS - show dependent code
Package BodyPQP_PENSION_TYPES_API - show dependent code
Package BodyPQP_PERASGADD_RIW - show dependent code
Package BodyPQP_PTY_BUS - show dependent code
Package BodyPQP_RATES_HISTORY_CALC - show dependent code
Package BodyPQP_RIW_GRADE_WRAPPER - show dependent code
PL/SQL PackagePQP_SCHEDULE_CALCULATION_PKG - show dependent code
Package BodyPQP_US_PENSION_EXTRACTS - show dependent code
Package BodyPQP_US_SRS_EXTRACTS - show dependent code
Package BodyPQP_UTILITIES - show dependent code
Package BodyPQP_VAI_BUS - show dependent code
Package BodyPQP_VAL_BUS - show dependent code
Package BodyPQP_VRE_BUS - show dependent code
Package BodyPQP_VRI_BUS - show dependent code
Package BodyPSP_ERA_BUS - show dependent code
Package BodyPSP_ERD_BUS - show dependent code
Package BodyPSP_GENERAL - show dependent code
Package BodyPSP_PEE_BUS - show dependent code
Package BodyPSP_PFB_BUS - show dependent code
Package BodyPSP_PFT_BUS - show dependent code
Package BodyPSP_POA_BUS - show dependent code
Package BodyPSP_PRT_BUS - show dependent code
Package BodyPSP_PSO_BUS - show dependent code
Package BodyPSP_RTD_BUS - show dependent code
Package BodyPY_ROLLBACK_PKG - show dependent code