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

VIEW: APPS.PQH_FR_STAT_SITUATIONS_V

Object Details
Object Name: PQH_FR_STAT_SITUATIONS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPQH.PQH_FR_STAT_SITUATIONS_V
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
STATUTORY_SITUATION_ID NUMBER (15) Yes Primary Key
SITUATION_NAME VARCHAR2 (240) Yes Statutory Situation Name
TYPE_OF_PS VARCHAR2 (30) Yes Type of Public Sector
TYPE_OF_PS_NAME VARCHAR2 (4000)
Type of Public Sector - Name
SITUATION_TYPE VARCHAR2 (30) Yes Situation Type
SITUATION_TYPE_NAME VARCHAR2 (4000)
Situation Type Name
SUB_TYPE VARCHAR2 (30)
Sub Type
SUB_TYPE_NAME VARCHAR2 (4000)
Sub Type Name
SOURCE VARCHAR2 (30)
Source
SOURCE_NAME VARCHAR2 (4000)
Source Name
LOCATION VARCHAR2 (30)
Location
LOCATION_NAME VARCHAR2 (4000)
Location Name
REASON VARCHAR2 (30)
Reason
REASON_NAME VARCHAR2 (4000)
Reason name
DATE_FROM DATE

Active Date from
DATE_TO DATE

Active Date to
REQUEST_TYPE VARCHAR2 (30)
Request Type
REQUEST_TYPE_NAME VARCHAR2 (4000)
Request type Name
EMPLOYEE_AGREEMENT_NEEDED VARCHAR2 (10)
Employee Agreement Needed Flag
MANAGER_AGREEMENT_NEEDED VARCHAR2 (10)
Manager Agreement Needed Flag
PRINT_ARRETTE VARCHAR2 (10)
Print Arrette Flag
RESERVE_POSITION VARCHAR2 (10)
Reserve Position
REMUNERATION_PAID VARCHAR2 (10)
Renumeration Paid
PAY_SHARE NUMBER (5)
Pay share
PAY_PERIODS NUMBER (15)
Pay Periods
FREQUENCY VARCHAR2 (30)
Frequency
FREQUENCY_NAME VARCHAR2 (4000)
Frequency Name
FIRST_PERIOD_MAX_DURATION NUMBER (15)
First Period Max Duration
MIN_DURATION_PER_REQUEST NUMBER (15)
Minimum Duration Per request
MAX_DURATION_PER_REQUEST NUMBER (15)
Maximum Duration per request
MAX_DURATION_WHOLE_CAREER NUMBER (15)
Maximum Duration for whole Career
RENEWABLE_ALLOWED VARCHAR2 (10)
Renewal Allowed Flag
MAX_NO_OF_RENEWALS NUMBER (15)
Maximum Number of Renewals
MAX_DURATION_PER_RENEWAL NUMBER (15)
Maximum Duration Per Renewal
MAX_TOT_CONTINUOUS_DURATION NUMBER (15)
Maximum Total continuos duration
BUSINESS_GROUP_ID NUMBER (15) Yes Business Group Identifier
RULESEXIST VARCHAR2 (4000)
Rule Exists Flag
CREATED_BY NUMBER (15) Yes Standard Who Column
CREATION_DATE DATE
Yes Standard Who Column
LAST_UPDATE_DATE DATE

Standard Who Column
LAST_UPDATED_BY NUMBER (15)
Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
OBJECT_VERSION_NUMBER NUMBER (9)
Object Version Number
DEFAULT_FLAG VARCHAR2 (10)
Default Flag (Y/N)
ALLOW_PROGRESSION_FLAG VARCHAR2 (10)
Allow Progression Flag (Y/N)
EXTEND_PROBATION_PERIOD_FLAG VARCHAR2 (10)
Extend Probation Period Flag (Y/N)
REMUNERATE_ASSIGN_STATUS_ID NUMBER (9)
Remuneration Assignment Status Identifier
REMUNERATE_ASSIGN_STATUS_NAME VARCHAR2 (4000)
Remuneration Assignment Status Name
Query Text

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


SELECT STATUTORY_SITUATION_ID
,      SITUATION_NAME
,      TYPE_OF_PS
,      TYPE_OF_PS_NAME
,      SITUATION_TYPE
,      SITUATION_TYPE_NAME
,      SUB_TYPE
,      SUB_TYPE_NAME
,      SOURCE
,      SOURCE_NAME
,      LOCATION
,      LOCATION_NAME
,      REASON
,      REASON_NAME
,      DATE_FROM
,      DATE_TO
,      REQUEST_TYPE
,      REQUEST_TYPE_NAME
,      EMPLOYEE_AGREEMENT_NEEDED
,      MANAGER_AGREEMENT_NEEDED
,      PRINT_ARRETTE
,      RESERVE_POSITION
,      REMUNERATION_PAID
,      PAY_SHARE
,      PAY_PERIODS
,      FREQUENCY
,      FREQUENCY_NAME
,      FIRST_PERIOD_MAX_DURATION
,      MIN_DURATION_PER_REQUEST
,      MAX_DURATION_PER_REQUEST
,      MAX_DURATION_WHOLE_CAREER
,      RENEWABLE_ALLOWED
,      MAX_NO_OF_RENEWALS
,      MAX_DURATION_PER_RENEWAL
,      MAX_TOT_CONTINUOUS_DURATION
,      BUSINESS_GROUP_ID
,      RULESEXIST
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      DEFAULT_FLAG
,      ALLOW_PROGRESSION_FLAG
,      EXTEND_PROBATION_PERIOD_FLAG
,      REMUNERATE_ASSIGN_STATUS_ID
,      REMUNERATE_ASSIGN_STATUS_NAME
FROM APPS.PQH_FR_STAT_SITUATIONS_V;

Dependencies

[top of page]

APPS.PQH_FR_STAT_SITUATIONS_V references the following:

SchemaAPPS
PL/SQL PackageHR_GENERAL - show dependent code
SynonymPQH_FR_STAT_SITUATIONS
PL/SQL PackagePQH_FR_STAT_SIT_UTIL - show dependent code
APPS.PQH_FR_STAT_SITUATIONS_V is referenced by following:

SchemaAPPS
Package BodyPQH_FR_ASSIGNMENT_CHK - show dependent code
Package BodyPQH_FR_EMP_STAT_SIT_UTILITY - show dependent code
Package BodyPQH_FR_STAT_SIT_UTIL - show dependent code
Package BodyPQH_FR_UTILITY - show dependent code
Package BodyPQH_PSU_BUS - show dependent code