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

VIEW: APPS.PAY_IN_SCL_DETAILS_V

Object Details
Object Name: PAY_IN_SCL_DETAILS_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
SEGMENT1 VARCHAR2 (60)
PF_ORGANIZATION VARCHAR2 (4000)
PROFESSIONAL_TAX_ORGANIZATION VARCHAR2 (4000)
ESI_ORGANIZATION VARCHAR2 (4000)
FACTORY VARCHAR2 (4000)
ESTABLISHMENT VARCHAR2 (4000)
COVERED_BY_GRATUITY_ACT VARCHAR2 (4000)
SUBSTANTIAL_INTEREST VARCHAR2 (4000)
DIRECTOR VARCHAR2 (4000)
SPECIFIED_EMPLOYEE VARCHAR2 (4000)
PF_EPS_CONTRIBUTION VARCHAR2 (4000)
RULE_TYPE VARCHAR2 (30)
EFFECTIVE_START_DATE DATE
Yes
EFFECTIVE_END_DATE DATE
Yes
ASSIGNMENT_ID NUMBER (10) Yes
PERSON_ID NUMBER (10) Yes
Query Text

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


SELECT SEGMENT1
,      PF_ORGANIZATION
,      PROFESSIONAL_TAX_ORGANIZATION
,      ESI_ORGANIZATION
,      FACTORY
,      ESTABLISHMENT
,      COVERED_BY_GRATUITY_ACT
,      SUBSTANTIAL_INTEREST
,      DIRECTOR
,      SPECIFIED_EMPLOYEE
,      PF_EPS_CONTRIBUTION
,      RULE_TYPE
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      ASSIGNMENT_ID
,      PERSON_ID
FROM APPS.PAY_IN_SCL_DETAILS_V;

Dependencies

[top of page]

APPS.PAY_IN_SCL_DETAILS_V references the following:

SchemaAPPS
PL/SQL PackageFND_NUMBER - show dependent code
PL/SQL PackageFND_PROFILE - show dependent code
PL/SQL PackageHR_GENERAL - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
SynonymHR_SOFT_CODING_KEYFLEX
PL/SQL PackagePAY_IN_UTILS - show dependent code
SynonymPAY_LEGISLATION_RULES
ViewPER_ASSIGNMENTS_F

APPS.PAY_IN_SCL_DETAILS_V is not referenced by any database object