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

VIEW: APPS.CE_PAY_FC_PAYROLL_V

Object Details
Object Name: CE_PAY_FC_PAYROLL_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCE.CE_PAY_FC_PAYROLL_V
Subobject Name:
Status: VALID

View Type

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


The CE_PAY_FC_PAYROLL view contains payments from the Payroll system for forecasting. The Cash Forecasting program uses this view to generate projected cash outflow amounts based on historical payroll expense data. Based on the forecast template definition and forecast submission criteria, the Cash Forecasting program selects only the applicable payroll payment records from this view to determine forecast amounts.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ORG_ID NUMBER (15) Yes Business group identifier
CURRENCY_CODE VARCHAR2 (15) Yes Payroll payment currency
AMOUNT NUMBER
Yes Payment amount
BASE_AMOUNT NUMBER

Payment amount in the base currency
EFFECTIVE_DATE DATE
Yes Payment effective date
ORG_PAYMENT_METHOD_ID NUMBER (9) Yes Payment method identifier
PAYROLL_BANK_ACCOUNT_ID NUMBER (9)
Payroll Bank account identifier
BANK_ACCOUNT_ID NUMBER (15) Yes Bank account identifier
PAYROLL_ID NUMBER (9)
Payroll identifier
TRX_DATE DATE
Yes Transaction date
PAYMENT_METHOD VARCHAR2 (80) Yes Payment Method
REFERENCE_ID NUMBER (15) Yes Reference identifier
Query Text

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


SELECT ORG_ID
,      CURRENCY_CODE
,      AMOUNT
,      BASE_AMOUNT
,      EFFECTIVE_DATE
,      ORG_PAYMENT_METHOD_ID
,      PAYROLL_BANK_ACCOUNT_ID
,      BANK_ACCOUNT_ID
,      PAYROLL_ID
,      TRX_DATE
,      PAYMENT_METHOD
,      REFERENCE_ID
FROM APPS.CE_PAY_FC_PAYROLL_V;

Dependencies

[top of page]

APPS.CE_PAY_FC_PAYROLL_V references the following:

SchemaAPPS
SynonymCE_BANK_ACCT_USES_ALL
SynonymPAY_ASSIGNMENT_ACTIONS
SynonymPAY_ORG_PAYMENT_METHODS_F
SynonymPAY_PAYROLL_ACTIONS
SynonymPAY_PRE_PAYMENTS
APPS.CE_PAY_FC_PAYROLL_V is referenced by following:

SchemaAPPS
ViewCE_CP_DISC_PAY_V
ViewCE_CP_DISC_PRIOR_V
Package BodyCE_CP_PRIORDAY - show dependent code
Package BodyCE_CSH_FCST_POP - show dependent code
ViewCE_FC_PAY_DISC_V