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

TABLE: HR.PER_PROPOSAL_OFFER_PARAGRAPHS

Object Details
Object Name: PER_PROPOSAL_OFFER_PARAGRAPHS
Object Type: TABLE
Owner: HR
FND Design Data: TablePER.PER_PROPOSAL_OFFER_PARAGRAPHS
Subobject Name:
Status: VALID


PER_PROPOSAL_OFFER_PARAGRAPHS contains the letter text that is used in
generating a web offer candidate letter. If changes are made to the
data in this table, you must ensure that the program that generates
the letter can handle the changes.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: PER_PROPOSAL_OFFER_PARAGRAP_PK
  1. ColumnPARAGRAPH_NO
Indexes
Index Type Uniqueness Tablespace Column
PER_PROPOSAL_OFFER_PARAGRAP_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPARAGRAPH_NO
Columns
Name Datatype Length Mandatory Comments
PARAGRAPH_NO VARCHAR2 (3) Yes A unique key column.
BODY_TEXT VARCHAR2 (2000)
The text of a specific paragraph that will be displayed on the Candidate Offer letter when it is generated.
LAST_UPDATED_BY NUMBER (15)
Standard who column
LAST_UPDATE_DATE DATE

Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
CREATION_DATE DATE

Standard who column
CREATED_BY NUMBER (15)
Standard who column
Query Text

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


SELECT PARAGRAPH_NO
,      BODY_TEXT
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
FROM HR.PER_PROPOSAL_OFFER_PARAGRAPHS;

Dependencies

[top of page]

HR.PER_PROPOSAL_OFFER_PARAGRAPHS does not reference any database object

HR.PER_PROPOSAL_OFFER_PARAGRAPHS is referenced by following:

SchemaAPPS
SynonymPER_PROPOSAL_OFFER_PARAGRAPHS
TriggerPER_PROPOSAL_OFFER_PARAGRA_WHO
SchemaPUBLIC
SynonymPER_PROPOSAL_OFFER_PARAGRAPHS