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

VIEW: APPS.PAY_HOURS_BY_RATE_V

Object Details
Object Name: PAY_HOURS_BY_RATE_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPAY.PAY_HOURS_BY_RATE_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


The view returns the run assignment_action_id, element_type_id, element name, rate, Hours and multiplier for an Hours by Rate Element


[View Source]

Columns
Name Datatype Length Mandatory Comments
ASSIGNMENT_ACTION_ID NUMBER (15)
Assignment Action ID
ELEMENT_TYPE_ID NUMBER

Element Type ID
ELEMENT_NAME VARCHAR2 (80)
Element Name
LEGISLATION_CODE VARCHAR2 (30)
Legislation Code
PROCESSING_PRIORITY NUMBER (9) Yes Processing Priority
RATE NUMBER

Rate
MULTIPLE NUMBER

Multiplier
HOURS NUMBER

No. of Hours
AMOUNT NUMBER

Total Amount
Query Text

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


SELECT ASSIGNMENT_ACTION_ID
,      ELEMENT_TYPE_ID
,      ELEMENT_NAME
,      LEGISLATION_CODE
,      PROCESSING_PRIORITY
,      RATE
,      MULTIPLE
,      HOURS
,      AMOUNT
FROM APPS.PAY_HOURS_BY_RATE_V;

Dependencies

[top of page]

APPS.PAY_HOURS_BY_RATE_V references the following:

SchemaAPPS
SynonymFND_SESSIONS
SynonymPAY_ELEMENT_TYPES_F
SynonymPAY_ELEMENT_TYPES_F_TL
PL/SQL PackagePAY_HOURS_BY_RATE - show dependent code
SynonymPAY_INPUT_VALUES_F
SynonymPAY_RUN_RESULTS
SynonymPAY_RUN_RESULT_VALUES
APPS.PAY_HOURS_BY_RATE_V is referenced by following:

SchemaAPPS
Package BodyPAY_AC_ACTION_ARCH - show dependent code
Package BodyPAY_US_ACTION_ARCH - show dependent code
Package BodyPAY_US_PAYSLIP_SIMULATION_MAIN - show dependent code