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


VIEW: APPS.PAY_IE_BIK_PREF_LOANS_V

Object Details
Object Name: PAY_IE_BIK_PREF_LOANS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPAY.PAY_IE_BIK_PREF_LOANS_V
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
PPS_NO VARCHAR2 (30)
SURNAME VARCHAR2 (150)
FIRST_NAME VARCHAR2 (150)
ASSIGNMENT_NUMBER VARCHAR2 (30)
LOAN_TYPES VARCHAR2 (60)
LOAN_REFERENCE VARCHAR2 (60)
DATE_LOAN_ACCQUIRED VARCHAR2 (60)
DATE_LOAN_ENDED VARCHAR2 (60)
AMOUNT_OUTSTANDING VARCHAR2 (60)
RATE_PERCENTAGE VARCHAR2 (60)
ANNUAL_INTEREST_CHARGED VARCHAR2 (60)
CUMULATIVE_TAXABLE_VALUE NUMBER

ASSIGNMENT_SET_ID NUMBER

ASSIGNMENT_ID NUMBER

PAYROLL_ID NUMBER

CONSOLIDATION_SET_ID NUMBER

Query Text

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


SELECT PPS_NO
,      SURNAME
,      FIRST_NAME
,      ASSIGNMENT_NUMBER
,      LOAN_TYPES
,      LOAN_REFERENCE
,      DATE_LOAN_ACCQUIRED
,      DATE_LOAN_ENDED
,      AMOUNT_OUTSTANDING
,      RATE_PERCENTAGE
,      ANNUAL_INTEREST_CHARGED
,      CUMULATIVE_TAXABLE_VALUE
,      ASSIGNMENT_SET_ID
,      ASSIGNMENT_ID
,      PAYROLL_ID
,      CONSOLIDATION_SET_ID
FROM APPS.PAY_IE_BIK_PREF_LOANS_V;

Dependencies

[top of page]

APPS.PAY_IE_BIK_PREF_LOANS_V references the following:

SchemaAPPS
PL/SQL PackageHR_GENERAL - show dependent code
PL/SQL PackageHR_PERSON_NAME - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
SynonymPAY_ASSIGNMENT_ACTIONS
SynonymPAY_ELEMENT_TYPES_F
PL/SQL PackagePAY_IE_BIK - show dependent code
SynonymPAY_INPUT_VALUES_F
ViewPAY_PAYROLLS_F
SynonymPAY_PAYROLL_ACTIONS
SynonymPAY_RUN_RESULTS
SynonymPAY_RUN_RESULT_VALUES
ViewPER_ASSIGNMENTS_F
ViewPER_PEOPLE_F

APPS.PAY_IE_BIK_PREF_LOANS_V is not referenced by any database object