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


VIEW: APPS.BEN_CWB_PP_ENH_AUDIT_DN_V

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

View Type

A Web view designed to simplify access from Oracle Self-Service Web Applications.


View for providing content into the Compensation Workbench Post Process Enhanced Audit download.


[View Source]

Columns
Name Datatype Length Mandatory Comments
DLSECUREDNAMEPR VARCHAR2 (240)
Person's full name
DLNUMPR VARCHAR2 (30)
Employee Number
DLSTATUSPR VARCHAR2 (7)
Status
DLMESSAGEPR VARCHAR2 (2000)
Error Message
DLCOUNTRYPR VARCHAR2 (80)
Country
DLBGNAMEPR VARCHAR2 (240)
Business group
DLLOCALPLANPR VARCHAR2 (240)
Local Plan
DLELIGPR VARCHAR2 (80)
Eligibility (Y or N)
DLEVTPR VARCHAR2 (80)
Life event status
DLNAMESALPL VARCHAR2 (240)
Plan Name
DLCURRENCYPL VARCHAR2 (80)
Currency
DLBASESALARYPL NUMBER

Base Salary
DLELIGSALARYPL NUMBER

Eligible Salary
DLCWBAMTPL NUMBER

Amount
DLPERCENTPL NUMBER

Percent
DLBASISPL VARCHAR2 (30)
Base Salary Frequency
DLPAYFACTORPL NUMBER

Pay Annualization Factor
DLPLANFACTORPL NUMBER

Annualization factor defined for plan
DLFACTORPL NUMBER

Conversion Factor
DLADJAMTPL NUMBER

Adjusted amount
DLPREVSALPL NUMBER

Previous salary
DLCHANGEPL NUMBER

Amount Posted
DLNEWSALPL NUMBER

New Salary
DLXRATEPL NUMBER

Exchange Rate for the plan
DLCORPBASESALPL NUMBER

Base Salary in Preferred Currency
DLCORPELIGSALPL NUMBER

Eligible Salary in Preferred Currency
DLCORPCWBAMTPL NUMBER

Amount in Preferred Currency
DLCORPADJAMTPL NUMBER

Adjusted amount in Preferred Currency
DLCORPPREVSALPL NUMBER

Previous Salary in Preferred Currency
DLCORPCHANGEPL NUMBER

Amount posted in preferred currency
DLCORPNEWSALPL NUMBER

New Salary in preferred currency
DLREASONPL VARCHAR2 (80)
Reason
DLEFFECTIVEDTPL DATE

Effective date
DLOPTELIGPL VARCHAR2 (80)
Eligible (Y or N) for Option
DLFTEFACTORPL NUMBER

FTE factor for plan
DLNAMESALOPT1 VARCHAR2 (240)
Option 1 Name
DLCURRENCYOPT1 VARCHAR2 (80)
Currency for option 1
DLBASESALARYOPT1 NUMBER

Base salary for option 1
DLELIGSALARYOPT1 NUMBER

Eligible salary for option 1
DLCWBAMTOPT1 NUMBER

Amount for option 1
DLPERCENTOPT1 NUMBER

Percent for option 1
DLBASISOPT1 VARCHAR2 (30)
Base salary frequency for option 1
DLPAYFACTOROPT1 NUMBER

Pay annualization factor for option 1
DLPLANFACTOROPT1 NUMBER

Plan annualization factor for option 1
DLFACTOROPT1 NUMBER

Conversion factor for option 1
DLADJAMTOPT1 NUMBER

Adjusted amount for option 1
DLPREVSALOPT1 NUMBER

Previous salary for option 1
DLCHANGEOPT1 NUMBER

Amount posted for option 1
DLNEWSALOPT1 NUMBER

New salary for option 1
DLXRATEOPT1 NUMBER

Exchange rate for option 1
DLCORPBASESALOPT1 NUMBER

Base salary in preferred currency for option 1
DLCORPELIGSALOPT1 NUMBER

Eligible salary in preferred currency for option 1
DLCORPCWBAMTOPT1 NUMBER

Amount in preferred currency for option 1
DLCORPADJAMTOPT1 NUMBER

Adjusted amount in preferred currency for option 1
DLCORPPREVSALOPT1 NUMBER

Previous salary in preferred currency for option 1
DLCORPCHANGEOPT1 NUMBER

Amount posted in preferred currency for option 1
DLCORPNEWSALOPT1 NUMBER

New salary in preferred currency for option 1
DLREASONOPT1 VARCHAR2 (80)
Reason for option 1
DLEFFECTIVEDTOPT1 DATE

Effective date for option 1
DLOPTELIGOPT1 VARCHAR2 (80)
Eligible for Option 1
DLFTEFACTOROPT1 NUMBER

FTE Factor for option 1
DLNAMESALOPT2 VARCHAR2 (240)
Option 2 Name
DLCURRENCYOPT2 VARCHAR2 (80)
Currency for option 2
DLBASESALARYOPT2 NUMBER

Base salary for option 2
DLELIGSALARYOPT2 NUMBER

Eligible salary for option 2
DLCWBAMTOPT2 NUMBER

Amount for option 2
DLPERCENTOPT2 NUMBER

Percent for option 2
DLBASISOPT2 VARCHAR2 (30)
Base salary frequency for option 2
DLPAYFACTOROPT2 NUMBER

Pay annualization factor for option 2
DLPLANFACTOROPT2 NUMBER

Plan annualization factor for option 2
DLFACTOROPT2 NUMBER

Conversion factor for option 2
DLADJAMTOPT2 NUMBER

Adjusted amount for option 2
DLPREVSALOPT2 NUMBER

Previous salary for option 2
DLCHANGEOPT2 NUMBER

Amount posted for option 2
DLNEWSALOPT2 NUMBER

New salary for option 2
DLXRATEOPT2 NUMBER

Exchange rate for option 2
DLCORPBASESALOPT2 NUMBER

Base salary in preferred currency for option 2
DLCORPELIGSALOPT2 NUMBER

Eligible salary in preferred currency for option 2
DLCORPCWBAMTOPT2 NUMBER

Amount in preferred currency for option 2
DLCORPADJAMTOPT2 NUMBER

Adjusted amount in preferred currency for option 2
DLCORPPREVSALOPT2 NUMBER

Previous salary in preferred currency for option 2
DLCORPCHANGEOPT2 NUMBER

Amount posted in preferred currency for option 2
DLCORPNEWSALOPT2 NUMBER

New salary in preferred currency for option 2
DLREASONOPT2 VARCHAR2 (80)
Reason for option 2
DLEFFECTIVEDTOPT2 DATE

Effective date for option 2
DLOPTELIGOPT2 VARCHAR2 (80)
Eligible for Option 2
DLFTEFACTOROPT2 NUMBER

FTE Factor for option 2
DLNAMESALOPT3 VARCHAR2 (240)
Option 3 Name
DLCURRENCYOPT3 VARCHAR2 (80)
Currency for option 3
DLBASESALARYOPT3 NUMBER

Base salary for option 3
DLELIGSALARYOPT3 NUMBER

Eligible salary for option 3
DLCWBAMTOPT3 NUMBER

Amount for option 3
DLPERCENTOPT3 NUMBER

Percent for option 3
DLBASISOPT3 VARCHAR2 (30)
Base salary frequency for option 3
DLPAYFACTOROPT3 NUMBER

Pay annualization factor for option 3
DLPLANFACTOROPT3 NUMBER

Plan annualization factor for option 3
DLFACTOROPT3 NUMBER

Conversion factor for option 3
DLADJAMTOPT3 NUMBER

Adjusted amount for option 3
DLPREVSALOPT3 NUMBER

Previous salary for option 3
DLCHANGEOPT3 NUMBER

Amount posted for option 3
DLNEWSALOPT3 NUMBER

New salary for option 3
DLXRATEOPT3 NUMBER

Exchange rate for option 3
DLCORPBASESALOPT3 NUMBER

Base salary in preferred currency for option 3
DLCORPELIGSALOPT3 NUMBER

Eligible salary in preferred currency for option 3
DLCORPCWBAMTOPT3 NUMBER

Amount in preferred currency for option 3
DLCORPADJAMTOPT3 NUMBER

Adjusted amount in preferred currency for option 3
DLCORPPREVSALOPT3 NUMBER

Previous salary in preferred currency for option 3
DLCORPCHANGEOPT3 NUMBER

Amount posted in preferred currency for option 3
DLCORPNEWSALOPT3 NUMBER

New salary in preferred currency for option 3
DLREASONOPT3 VARCHAR2 (80)
Reason for option 3
DLEFFECTIVEDTOPT3 DATE

Effective date for option 3
DLOPTELIGOPT3 VARCHAR2 (80)
Eligible for Option 3
DLFTEFACTOROPT3 NUMBER

FTE Factor for option 3
DLNAMESALOPT4 VARCHAR2 (240)
Option 4 Name
DLCURRENCYOPT4 VARCHAR2 (80)
Currency for option 4
DLBASESALARYOPT4 NUMBER

Base salary for option 4
DLELIGSALARYOPT4 NUMBER

Eligible salary for option 4
DLCWBAMTOPT4 NUMBER

Amount for option 4
DLPERCENTOPT4 NUMBER

Percent for option 4
DLBASISOPT4 VARCHAR2 (30)
Base salary frequency for option 4
DLPAYFACTOROPT4 NUMBER

Pay annualization factor for option 4
DLPLANFACTOROPT4 NUMBER

Plan annualization factor for option 4
DLFACTOROPT4 NUMBER

Conversion factor for option 4
DLADJAMTOPT4 NUMBER

Adjusted amount for option 4
DLPREVSALOPT4 NUMBER

Previous salary for option 4
DLCHANGEOPT4 NUMBER

Amount posted for option 4
DLNEWSALOPT4 NUMBER

New salary for option 4
DLXRATEOPT4 NUMBER

Exchange rate for option 4
DLCORPBASESALOPT4 NUMBER

Base salary in preferred currency for option 4
DLCORPELIGSALOPT4 NUMBER

Eligible salary in preferred currency for option 4
DLCORPCWBAMTOPT4 NUMBER

Amount in preferred currency for option 4
DLCORPADJAMTOPT4 NUMBER

Adjusted amount in preferred currency for option 4
DLCORPPREVSALOPT4 NUMBER

Previous salary in preferred currency for option 3
DLCORPCHANGEOPT4 NUMBER

Amount posted in preferred currency for option 4
DLCORPNEWSALOPT4 NUMBER

New salary in preferred currency for option 4
DLREASONOPT4 VARCHAR2 (80)
Reason for option 4
DLEFFECTIVEDTOPT4 DATE

Effective date for option 4
DLOPTELIGOPT4 VARCHAR2 (80)
Eligible for Option 4
DLFTEFACTOROPT4 NUMBER

FTE Factor for option 4
DLNAMENONSALPL VARCHAR2 (240)
Non Salary Plan name
DLNONSALCURRENCYPL VARCHAR2 (80)
Currency
DLNONSALELIGSALPL NUMBER

Eligible salary
DLNONSALCWBAMTPL NUMBER

Amount
DLNONSALPERCENTSALPL NUMBER

Percent of eligible salary
DLELEMENTAMTPL NUMBER

Amount posted
DLNONSALXRATEPL NUMBER

Exchange rate
DLNONSALCORPELIGSALPL NUMBER

Eligible salary in preferred currency for option 2
DLNONSALCORPCWBAMTPL NUMBER

Non salary amount in preferred currency
DLNONSALCORPAMTPOSTEDPL NUMBER

Amount posted in preferred currency
DLELEMENTINPUTPL VARCHAR2 (80)
Input value
DLNONSALEFFDATEPL DATE

Effective date
DLNONSALELIGPL VARCHAR2 (80)
Eligible
DLNAMENONSALOPT1 VARCHAR2 (240)
Option 1 name
DLNONSALCURRENCYOPT1 VARCHAR2 (80)
Currency
DLNONSALELIGSALOPT1 NUMBER

Eligible salary
DLNONSALCWBAMTOPT1 NUMBER

Amount
DLNONSALPERCENTSALOPT1 NUMBER

Percent
DLELEMENTAMTOPT1 NUMBER

Amount posted
DLNONSALXRATEOPT1 NUMBER

Exchange rate
DLNONSALCORPELIGSALOPT1 NUMBER

Eligible salary in preferred currency
DLNONSALCORPCWBAMTOPT1 NUMBER

Amount in preferred currency
DLNONSALCORPAMTPOSTEDOPT1 NUMBER

Amount Posted in preferred currency
DLELEMENTINPUTOPT1 VARCHAR2 (80)
Input value
DLNONSALEFFDATEOPT1 DATE

Effective date
DLNONSALELIGOPT1 VARCHAR2 (80)
Eligible
DLNAMENONSALOPT2 VARCHAR2 (240)
Option 2 name
DLNONSALCURRENCYOPT2 VARCHAR2 (80)
Currency
DLNONSALELIGSALOPT2 NUMBER

Eligible Salary
DLNONSALCWBAMTOPT2 NUMBER

Amount
DLNONSALPERCENTSALOPT2 NUMBER

Percent
DLELEMENTAMTOPT2 NUMBER

Amount posted
DLNONSALXRATEOPT2 NUMBER

Exchange rate
DLNONSALCORPELIGSALOPT2 NUMBER

Eligible salary in preferred currency
DLNONSALCORPCWBAMTOPT2 NUMBER

Amount in preferred currency
DLNONSALCORPAMTPOSTEDOPT2 NUMBER

Amount posted in preferred currency
DLELEMENTINPUTOPT2 VARCHAR2 (80)
Input value
DLNONSALEFFDATEOPT2 DATE

Effective date
DLNONSALELIGOPT2 VARCHAR2 (80)
Eligible
DLNAMENONSALOPT3 VARCHAR2 (240)
Option 3 name
DLNONSALCURRENCYOPT3 VARCHAR2 (80)
Currency
DLNONSALELIGSALOPT3 NUMBER

Eligible salary
DLNONSALCWBAMTOPT3 NUMBER

Amount
DLNONSALPERCENTSALOPT3 NUMBER

Percent
DLELEMENTAMTOPT3 NUMBER

Amount posted
DLNONSALXRATEOPT3 NUMBER

Exchange rate
DLNONSALCORPELIGSALOPT3 NUMBER

Eligible salary in preferred currency
DLNONSALCORPCWBAMTOPT3 NUMBER

Amount in preferred currency
DLNONSALCORPAMTPOSTEDOPT3 NUMBER

Amount posted in preferred currency
DLELEMENTINPUTOPT3 VARCHAR2 (80)
Input value
DLNONSALEFFDATEOPT3 DATE

Effective date
DLNONSALELIGOPT3 VARCHAR2 (80)
Eligible
DLNAMENONSALOPT4 VARCHAR2 (240)
Option 4 name
DLNONSALCURRENCYOPT4 VARCHAR2 (80)
Currency
DLNONSALELIGSALOPT4 NUMBER

Eligible salary
DLNONSALCWBAMTOPT4 NUMBER

Amount
DLNONSALPERCENTSALOPT4 NUMBER

Percent
DLELEMENTAMTOPT4 NUMBER

Amount posted
DLNONSALXRATEOPT4 NUMBER

Exchange rate
DLNONSALCORPELIGSALOPT4 NUMBER

Eligible salary in preferred currency
DLNONSALCORPCWBAMTOPT4 NUMBER

Amount in preferred currency
DLNONSALCORPAMTPOSTEDOPT4 NUMBER

Amount posted in preferred currency
DLELEMENTINPUTOPT4 VARCHAR2 (80)
Input value
DLNONSALEFFDATEOPT4 DATE

Effective date
DLNONSALELIGOPT4 VARCHAR2 (80)
Eligible
DLNAMENONMONPL VARCHAR2 (240)
Non Monetary Plan name
DLNONMONUOMPL VARCHAR2 (30)
Non monetary unit of measure
DLNONMONCWBAMTPL NUMBER

Non monetary amount
DLNONMONAMTPOSTEDPL NUMBER

Amount posted
DLNONMONELINPUTPL VARCHAR2 (80)
Input value
DLNONMONEFFDATEPL DATE

Effective date
DLNONMONELIGPL VARCHAR2 (80)
Eligible
DLNAMENONMONOPT1 VARCHAR2 (240)
Option 1 name
DLNONMONUOMOPT1 VARCHAR2 (30)
Unit of measure
DLNONMONCWBAMTOPT1 NUMBER

Amount
DLNONMONAMTPOSTEDOPT1 NUMBER

Amount posted
DLNONMONELINPUTOPT1 VARCHAR2 (80)
Input value
DLNONMONEFFDATEOPT1 DATE

Effective date
DLNONMONELIGOPT1 VARCHAR2 (80)
Eligible
DLNAMENONMONOPT2 VARCHAR2 (240)
Option 2 name
DLNONMONUOMOPT2 VARCHAR2 (30)
Unit of measure
DLNONMONCWBAMTOPT2 NUMBER

Amount
DLNONMONAMTPOSTEDOPT2 NUMBER

Amount posted
DLNONMONELINPUTOPT2 VARCHAR2 (80)
Input value
DLNONMONEFFDATEOPT2 DATE

Effective date
DLNONMONELIGOPT2 VARCHAR2 (80)
Eligible
DLNAMENONMONOPT3 VARCHAR2 (240)
Option 3 name
DLNONMONUOMOPT3 VARCHAR2 (30)
Unit of measure
DLNONMONCWBAMTOPT3 NUMBER

Amount
DLNONMONAMTPOSTEDOPT3 NUMBER

Amount posted
DLNONMONELINPUTOPT3 VARCHAR2 (80)
Input value
DLNONMONEFFDATEOPT3 DATE

Effective date
DLNONMONELIGOPT3 VARCHAR2 (80)
Eligible
DLNAMENONMONOPT4 VARCHAR2 (240)
Option 4 name
DLNONMONUOMOPT4 VARCHAR2 (30)
Unit of measure
DLNONMONCWBAMTOPT4 NUMBER

Amount
DLNONMONAMTPOSTEDOPT4 NUMBER

Amount posted
DLNONMONELINPUTOPT4 VARCHAR2 (80)
Input value
DLNONMONEFFDATEOPT4 DATE

Effective date
DLNONMONELIGOPT4 VARCHAR2 (80)
Eligible
DLNAMERECURPL VARCHAR2 (240)
Plan name
DLRECURCURRENCYPL VARCHAR2 (80)
Currency
DLRECURELIGSALPL NUMBER

Eligible Salary
DLRECURCWBAMTPL NUMBER

Amount
DLRECURPERCENTSALPL NUMBER

Percent
DLRPREVELEMENTAMTPL NUMBER

Previous element screen entry value
DLRELEMENTAMTPL NUMBER

Amount
DLRECURXRATEPL NUMBER

Exchange rate
DLRECURCORPELIGSALPL NUMBER

Eligible salary
DLRECURCORPCWBAMTPL NUMBER

Amount in preferred currency
DLCORPRPREVELEMENTAMTPL NUMBER

Previous element amount in preferred currency
DLRECURCORPAMTPOSTEDPL NUMBER

Amount posted in preferred currency
DLRELEMENTINPUTPL VARCHAR2 (80)
Input value
DLRECUREFFDATEPL DATE

Effective date
DLRECURELIGPL VARCHAR2 (80)
Eligible
DLNAMERECUROPT1 VARCHAR2 (240)
Option 1 name
DLRECURCURRENCYOPT1 VARCHAR2 (80)
Currency
DLRECURELIGSALOPT1 NUMBER

Eligible salary
DLRECURCWBAMTOPT1 NUMBER

Amount
DLRECURPERCENTSALOPT1 NUMBER

Percent
DLRPREVELEMENTAMTOPT1 NUMBER

Previous element amount
DLRELEMENTAMTOPT1 NUMBER

Amount
DLRECURXRATEOPT1 NUMBER

Exchange rate
DLRECURCORPELIGSALOPT1 NUMBER

Eligible salary in preferred currency
DLRECURCORPCWBAMTOPT1 NUMBER

Amount in preferred currency
DLCORPRPREVELEMENTAMTOPT1 NUMBER

Previous element amount in preferred currency
DLRECURCORPAMTPOSTEDOPT1 NUMBER

Amount posted in preferred currency
DLRELEMENTINPUTOPT1 VARCHAR2 (80)
Input value
DLRECUREFFDATEOPT1 DATE

Effective date
DLRECURELIGOPT1 VARCHAR2 (80)
Eligible
DLNAMERECUROPT2 VARCHAR2 (240)
Option 2 name
DLRECURCURRENCYOPT2 VARCHAR2 (80)
Currency
DLRECURELIGSALOPT2 NUMBER

Eligible salary
DLRECURCWBAMTOPT2 NUMBER

Amount
DLRECURPERCENTSALOPT2 NUMBER

Percent
DLRPREVELEMENTAMTOPT2 NUMBER

Previous element amount
DLRELEMENTAMTOPT2 NUMBER

Amount
DLRECURXRATEOPT2 NUMBER

Exchange rate
DLRECURCORPELIGSALOPT2 NUMBER

Eligible salary in preferred currency
DLRECURCORPCWBAMTOPT2 NUMBER

Amount in preferred currency
DLCORPRPREVELEMENTAMTOPT2 NUMBER

Previous element amount in preferred currency
DLRECURCORPAMTPOSTEDOPT2 NUMBER

Amount posted in preferred currency
DLRELEMENTINPUTOPT2 VARCHAR2 (80)
Input value
DLRECUREFFDATEOPT2 DATE

Effective date
DLRECURELIGOPT2 VARCHAR2 (80)
Eligible
DLNAMERECUROPT3 VARCHAR2 (240)
Option 3 name
DLRECURCURRENCYOPT3 VARCHAR2 (80)
Currency
DLRECURELIGSALOPT3 NUMBER

Eligible salary
DLRECURCWBAMTOPT3 NUMBER

Amount
DLRECURPERCENTSALOPT3 NUMBER

Percent
DLRPREVELEMENTAMTOPT3 NUMBER

Previous element amount
DLRELEMENTAMTOPT3 NUMBER

Amount
DLRECURXRATEOPT3 NUMBER

Exchange rate
DLRECURCORPELIGSALOPT3 NUMBER

Eligible salary in preferred currency
DLRECURCORPCWBAMTOPT3 NUMBER

Amount in preferred currency
DLCORPRPREVELEMENTAMTOPT3 NUMBER

Previous element amount
DLRECURCORPAMTPOSTEDOPT3 NUMBER

Amount posted in preferred currency
DLRELEMENTINPUTOPT3 VARCHAR2 (80)
Input value
DLRECUREFFDATEOPT3 DATE

Effective date
DLRECURELIGOPT3 VARCHAR2 (80)
Eligible
DLNAMERECUROPT4 VARCHAR2 (240)
Option 4 name
DLRECURCURRENCYOPT4 VARCHAR2 (80)
Currency
DLRECURELIGSALOPT4 NUMBER

Eligible salary
DLRECURCWBAMTOPT4 NUMBER

Amount
DLRECURPERCENTSALOPT4 NUMBER

Percent
DLRPREVELEMENTAMTOPT4 NUMBER

Previous element amount
DLRELEMENTAMTOPT4 NUMBER

Amount
DLRECURXRATEOPT4 NUMBER

Exchange rate
DLRECURCORPELIGSALOPT4 NUMBER

Eligible salary in preferred currency
DLRECURCORPCWBAMTOPT4 NUMBER

Amount in preferred currency
DLCORPRPREVELEMENTAMTOPT4 NUMBER

Previous element amount in preferred currency
DLRECURCORPAMTPOSTEDOPT4 NUMBER

Amount posted in preferred currency
DLRELEMENTINPUTOPT4 VARCHAR2 (80)
Input value
DLRECUREFFDATEOPT4 DATE

Effective date
DLRECURELIGOPT4 VARCHAR2 (80)
Eligible
DLCWBRATING VARCHAR2 (30)
Rating
DLPOSTEDRATING VARCHAR2 (30)
Posted rating
DLRATINGTYPE VARCHAR2 (80)
Rating type
DLRATINGDATE DATE

Rating date
DLASSFLAG VARCHAR2 (30)
Assignment changed flag
DLBEFOREJOB VARCHAR2 (700)
Before Job
DLAFTERJOB VARCHAR2 (700)
After Job
DLJOB VARCHAR2 (700)
Job
DLBEFOREPOSITION VARCHAR2 (240)
Before Position
DLAFTERPOSITION VARCHAR2 (240)
After Position
DLPOSITION VARCHAR2 (240)
Position
DLBEFOREGRADE VARCHAR2 (240)
Before grade
DLAFTERGRADE VARCHAR2 (240)
After grade
DLGRADE VARCHAR2 (240)
Grade
DLBEFOREGROUP VARCHAR2 (240)
Before group
DLAFTERGROUP VARCHAR2 (240)
After group
DLGRUP VARCHAR2 (240)
Group
DLCHANGEREASON VARCHAR2 (80)
Change reason
DLPENDGWORKFLOW VARCHAR2 (30)
Pending workflow
DLBEFOREFLEX1 VARCHAR2 (150)
Descriptive flexfield segment column
DLAFTERFLEX1 VARCHAR2 (150)
Descriptive flexfield segment column
DLFLEX1 VARCHAR2 (150)
Descriptive flexfield segment column
DLBEFOREFLEX2 VARCHAR2 (150)
Descriptive flexfield segment column
DLAFTERFLEX2 VARCHAR2 (150)
Descriptive flexfield segment column
DLFLEX2 VARCHAR2 (150)
Descriptive flexfield segment column
DLBEFOREFLEX3 VARCHAR2 (150)
Descriptive flexfield segment column
DLAFTERFLEX3 VARCHAR2 (150)
Descriptive flexfield segment column
DLFLEX3 VARCHAR2 (150)
Descriptive flexfield segment column
DLBEFOREFLEX4 VARCHAR2 (150)
Descriptive flexfield segment column
DLAFTERFLEX4 VARCHAR2 (150)
Descriptive flexfield segment column
DLFLEX4 VARCHAR2 (150)
Descriptive flexfield segment column
DLBEFOREFLEX5 VARCHAR2 (150)
Descriptive flexfield segment column
DLAFTERFLEX5 VARCHAR2 (150)
Descriptive flexfield segment column
DLFLEX5 VARCHAR2 (150)
Descriptive flexfield segment column
DLBEFOREFLEX6 VARCHAR2 (150)
Descriptive flexfield segment column
DLAFTERFLEX6 VARCHAR2 (150)
Descriptive flexfield segment column
DLFLEX6 VARCHAR2 (150)
Descriptive flexfield segment column
DLBEFOREFLEX7 VARCHAR2 (150)
Descriptive flexfield segment column
DLAFTERFLEX7 VARCHAR2 (150)
Descriptive flexfield segment column
DLFLEX7 VARCHAR2 (150)
Descriptive flexfield segment column
DLBEFOREFLEX8 VARCHAR2 (150)
Descriptive flexfield segment column
DLAFTERFLEX8 VARCHAR2 (150)
Descriptive flexfield segment column
DLFLEX8 VARCHAR2 (150)
Descriptive flexfield segment column
DLBEFOREFLEX9 VARCHAR2 (150)
Descriptive flexfield segment column
DLAFTERFLEX9 VARCHAR2 (150)
Descriptive flexfield segment column
DLFLEX9 VARCHAR2 (150)
Descriptive flexfield segment column
DLBEFOREFLEX10 VARCHAR2 (150)
Descriptive flexfield segment column
DLAFTERFLEX10 VARCHAR2 (150)
Descriptive flexfield segment column
DLFLEX10 VARCHAR2 (150)
Descriptive flexfield segment column
DLBEFOREFLEX11 VARCHAR2 (150)
Descriptive flexfield segment column
DLAFTERFLEX11 VARCHAR2 (150)
Descriptive flexfield segment column
DLFLEX11 VARCHAR2 (150)
Descriptive flexfield segment column
DLBEFOREFLEX12 VARCHAR2 (150)
Descriptive flexfield segment column
DLAFTERFLEX12 VARCHAR2 (150)
Descriptive flexfield segment column
DLFLEX12 VARCHAR2 (150)
Descriptive flexfield segment column
DLBEFOREFLEX13 VARCHAR2 (150)
Descriptive flexfield segment column
DLAFTERFLEX13 VARCHAR2 (150)
Descriptive flexfield segment column
DLFLEX13 VARCHAR2 (150)
Descriptive flexfield segment column
DLBEFOREFLEX14 VARCHAR2 (150)
Descriptive flexfield segment column
DLAFTERFLEX14 VARCHAR2 (150)
Descriptive flexfield segment column
DLFLEX14 VARCHAR2 (150)
Descriptive flexfield segment column
DLBEFOREFLEX15 VARCHAR2 (150)
Descriptive flexfield segment column
DLAFTERFLEX15 VARCHAR2 (150)
Descriptive flexfield segment column
DLFLEX15 VARCHAR2 (150)
Descriptive flexfield segment column
DLBEFOREFLEX16 VARCHAR2 (150)
Descriptive flexfield segment column
DLAFTERFLEX16 VARCHAR2 (150)
Descriptive flexfield segment column
DLFLEX16 VARCHAR2 (150)
Descriptive flexfield segment column
DLBEFOREFLEX17 VARCHAR2 (150)
Descriptive flexfield segment column
DLAFTERFLEX17 VARCHAR2 (150)
Descriptive flexfield segment column
DLFLEX17 VARCHAR2 (150)
Descriptive flexfield segment column
DLBEFOREFLEX18 VARCHAR2 (150)
Descriptive flexfield segment column
DLAFTERFLEX18 VARCHAR2 (150)
Descriptive flexfield segment column
DLFLEX18 VARCHAR2 (150)
Descriptive flexfield segment column
DLBEFOREFLEX19 VARCHAR2 (150)
Descriptive flexfield segment column
DLAFTERFLEX19 VARCHAR2 (150)
Descriptive flexfield segment column
DLFLEX19 VARCHAR2 (150)
Descriptive flexfield segment column
DLBEFOREFLEX20 VARCHAR2 (150)
Descriptive flexfield segment column
DLAFTERFLEX20 VARCHAR2 (150)
Descriptive flexfield segment column
DLFLEX20 VARCHAR2 (150)
Descriptive flexfield segment column
DLBEFOREFLEX21 VARCHAR2 (150)
Descriptive flexfield segment column
DLAFTERFLEX21 VARCHAR2 (150)
Descriptive flexfield segment column
DLFLEX21 VARCHAR2 (150)
Descriptive flexfield segment column
DLBEFOREFLEX22 VARCHAR2 (150)
Descriptive flexfield segment column
DLAFTERFLEX22 VARCHAR2 (150)
Descriptive flexfield segment column
DLFLEX22 VARCHAR2 (150)
Descriptive flexfield segment column
DLBEFOREFLEX23 VARCHAR2 (150)
Descriptive flexfield segment column
DLAFTERFLEX23 VARCHAR2 (150)
Descriptive flexfield segment column
DLFLEX23 VARCHAR2 (150)
Descriptive flexfield segment column
DLBEFOREFLEX24 VARCHAR2 (150)
Descriptive flexfield segment column
DLAFTERFLEX24 VARCHAR2 (150)
Descriptive flexfield segment column
DLFLEX24 VARCHAR2 (150)
Descriptive flexfield segment column
DLBEFOREFLEX25 VARCHAR2 (150)
Descriptive flexfield segment column
DLAFTERFLEX25 VARCHAR2 (150)
Descriptive flexfield segment column
DLFLEX25 VARCHAR2 (150)
Descriptive flexfield segment column
DLBEFOREFLEX26 VARCHAR2 (150)
Descriptive flexfield segment column
DLAFTERFLEX26 VARCHAR2 (150)
Descriptive flexfield segment column
DLFLEX26 VARCHAR2 (150)
Descriptive flexfield segment column
DLBEFOREFLEX27 VARCHAR2 (150)
Descriptive flexfield segment column
DLAFTERFLEX27 VARCHAR2 (150)
Descriptive flexfield segment column
DLFLEX27 VARCHAR2 (150)
Descriptive flexfield segment column
DLBEFOREFLEX28 VARCHAR2 (150)
Descriptive flexfield segment column
DLAFTERFLEX28 VARCHAR2 (150)
Descriptive flexfield segment column
DLFLEX28 VARCHAR2 (150)
Descriptive flexfield segment column
DLBEFOREFLEX29 VARCHAR2 (150)
Descriptive flexfield segment column
DLAFTERFLEX29 VARCHAR2 (150)
Descriptive flexfield segment column
DLFLEX29 VARCHAR2 (150)
Descriptive flexfield segment column
DLBEFOREFLEX30 VARCHAR2 (150)
Descriptive flexfield segment column
DLAFTERFLEX30 VARCHAR2 (150)
Descriptive flexfield segment column
DLFLEX30 VARCHAR2 (150)
Descriptive flexfield segment column
DLASGNEFFECTIVEDATE DATE

Effective date
DLOPTION1ID NUMBER

Group option in plan id
DLOPTION2ID NUMBER

Group option in plan id
DLOPTION3ID NUMBER

Group option in plan id
DLOPTION4ID NUMBER

Group option in plan id
DLBENEFITACTIONID NUMBER (15)
Benefit action Id. Foreign key to BEN_BENEFIT_ACTIONS
DLPROCESSDATE DATE

Process date
DLGROUPPERINLERID NUMBER

Group Per in ler Id
DLPERSONID NUMBER (15)
Person Id. Foreign key to PER_ALL_PEOPLE_F
DLREQUESTID NUMBER (15)
Request Id. Foreign key to FND_CONCURRENT_REQUESTS
Query Text

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


SELECT DLSECUREDNAMEPR
,      DLNUMPR
,      DLSTATUSPR
,      DLMESSAGEPR
,      DLCOUNTRYPR
,      DLBGNAMEPR
,      DLLOCALPLANPR
,      DLELIGPR
,      DLEVTPR
,      DLNAMESALPL
,      DLCURRENCYPL
,      DLBASESALARYPL
,      DLELIGSALARYPL
,      DLCWBAMTPL
,      DLPERCENTPL
,      DLBASISPL
,      DLPAYFACTORPL
,      DLPLANFACTORPL
,      DLFACTORPL
,      DLADJAMTPL
,      DLPREVSALPL
,      DLCHANGEPL
,      DLNEWSALPL
,      DLXRATEPL
,      DLCORPBASESALPL
,      DLCORPELIGSALPL
,      DLCORPCWBAMTPL
,      DLCORPADJAMTPL
,      DLCORPPREVSALPL
,      DLCORPCHANGEPL
,      DLCORPNEWSALPL
,      DLREASONPL
,      DLEFFECTIVEDTPL
,      DLOPTELIGPL
,      DLFTEFACTORPL
,      DLNAMESALOPT1
,      DLCURRENCYOPT1
,      DLBASESALARYOPT1
,      DLELIGSALARYOPT1
,      DLCWBAMTOPT1
,      DLPERCENTOPT1
,      DLBASISOPT1
,      DLPAYFACTOROPT1
,      DLPLANFACTOROPT1
,      DLFACTOROPT1
,      DLADJAMTOPT1
,      DLPREVSALOPT1
,      DLCHANGEOPT1
,      DLNEWSALOPT1
,      DLXRATEOPT1
,      DLCORPBASESALOPT1
,      DLCORPELIGSALOPT1
,      DLCORPCWBAMTOPT1
,      DLCORPADJAMTOPT1
,      DLCORPPREVSALOPT1
,      DLCORPCHANGEOPT1
,      DLCORPNEWSALOPT1
,      DLREASONOPT1
,      DLEFFECTIVEDTOPT1
,      DLOPTELIGOPT1
,      DLFTEFACTOROPT1
,      DLNAMESALOPT2
,      DLCURRENCYOPT2
,      DLBASESALARYOPT2
,      DLELIGSALARYOPT2
,      DLCWBAMTOPT2
,      DLPERCENTOPT2
,      DLBASISOPT2
,      DLPAYFACTOROPT2
,      DLPLANFACTOROPT2
,      DLFACTOROPT2
,      DLADJAMTOPT2
,      DLPREVSALOPT2
,      DLCHANGEOPT2
,      DLNEWSALOPT2
,      DLXRATEOPT2
,      DLCORPBASESALOPT2
,      DLCORPELIGSALOPT2
,      DLCORPCWBAMTOPT2
,      DLCORPADJAMTOPT2
,      DLCORPPREVSALOPT2
,      DLCORPCHANGEOPT2
,      DLCORPNEWSALOPT2
,      DLREASONOPT2
,      DLEFFECTIVEDTOPT2
,      DLOPTELIGOPT2
,      DLFTEFACTOROPT2
,      DLNAMESALOPT3
,      DLCURRENCYOPT3
,      DLBASESALARYOPT3
,      DLELIGSALARYOPT3
,      DLCWBAMTOPT3
,      DLPERCENTOPT3
,      DLBASISOPT3
,      DLPAYFACTOROPT3
,      DLPLANFACTOROPT3
,      DLFACTOROPT3
,      DLADJAMTOPT3
,      DLPREVSALOPT3
,      DLCHANGEOPT3
,      DLNEWSALOPT3
,      DLXRATEOPT3
,      DLCORPBASESALOPT3
,      DLCORPELIGSALOPT3
,      DLCORPCWBAMTOPT3
,      DLCORPADJAMTOPT3
,      DLCORPPREVSALOPT3
,      DLCORPCHANGEOPT3
,      DLCORPNEWSALOPT3
,      DLREASONOPT3
,      DLEFFECTIVEDTOPT3
,      DLOPTELIGOPT3
,      DLFTEFACTOROPT3
,      DLNAMESALOPT4
,      DLCURRENCYOPT4
,      DLBASESALARYOPT4
,      DLELIGSALARYOPT4
,      DLCWBAMTOPT4
,      DLPERCENTOPT4
,      DLBASISOPT4
,      DLPAYFACTOROPT4
,      DLPLANFACTOROPT4
,      DLFACTOROPT4
,      DLADJAMTOPT4
,      DLPREVSALOPT4
,      DLCHANGEOPT4
,      DLNEWSALOPT4
,      DLXRATEOPT4
,      DLCORPBASESALOPT4
,      DLCORPELIGSALOPT4
,      DLCORPCWBAMTOPT4
,      DLCORPADJAMTOPT4
,      DLCORPPREVSALOPT4
,      DLCORPCHANGEOPT4
,      DLCORPNEWSALOPT4
,      DLREASONOPT4
,      DLEFFECTIVEDTOPT4
,      DLOPTELIGOPT4
,      DLFTEFACTOROPT4
,      DLNAMENONSALPL
,      DLNONSALCURRENCYPL
,      DLNONSALELIGSALPL
,      DLNONSALCWBAMTPL
,      DLNONSALPERCENTSALPL
,      DLELEMENTAMTPL
,      DLNONSALXRATEPL
,      DLNONSALCORPELIGSALPL
,      DLNONSALCORPCWBAMTPL
,      DLNONSALCORPAMTPOSTEDPL
,      DLELEMENTINPUTPL
,      DLNONSALEFFDATEPL
,      DLNONSALELIGPL
,      DLNAMENONSALOPT1
,      DLNONSALCURRENCYOPT1
,      DLNONSALELIGSALOPT1
,      DLNONSALCWBAMTOPT1
,      DLNONSALPERCENTSALOPT1
,      DLELEMENTAMTOPT1
,      DLNONSALXRATEOPT1
,      DLNONSALCORPELIGSALOPT1
,      DLNONSALCORPCWBAMTOPT1
,      DLNONSALCORPAMTPOSTEDOPT1
,      DLELEMENTINPUTOPT1
,      DLNONSALEFFDATEOPT1
,      DLNONSALELIGOPT1
,      DLNAMENONSALOPT2
,      DLNONSALCURRENCYOPT2
,      DLNONSALELIGSALOPT2
,      DLNONSALCWBAMTOPT2
,      DLNONSALPERCENTSALOPT2
,      DLELEMENTAMTOPT2
,      DLNONSALXRATEOPT2
,      DLNONSALCORPELIGSALOPT2
,      DLNONSALCORPCWBAMTOPT2
,      DLNONSALCORPAMTPOSTEDOPT2
,      DLELEMENTINPUTOPT2
,      DLNONSALEFFDATEOPT2
,      DLNONSALELIGOPT2
,      DLNAMENONSALOPT3
,      DLNONSALCURRENCYOPT3
,      DLNONSALELIGSALOPT3
,      DLNONSALCWBAMTOPT3
,      DLNONSALPERCENTSALOPT3
,      DLELEMENTAMTOPT3
,      DLNONSALXRATEOPT3
,      DLNONSALCORPELIGSALOPT3
,      DLNONSALCORPCWBAMTOPT3
,      DLNONSALCORPAMTPOSTEDOPT3
,      DLELEMENTINPUTOPT3
,      DLNONSALEFFDATEOPT3
,      DLNONSALELIGOPT3
,      DLNAMENONSALOPT4
,      DLNONSALCURRENCYOPT4
,      DLNONSALELIGSALOPT4
,      DLNONSALCWBAMTOPT4
,      DLNONSALPERCENTSALOPT4
,      DLELEMENTAMTOPT4
,      DLNONSALXRATEOPT4
,      DLNONSALCORPELIGSALOPT4
,      DLNONSALCORPCWBAMTOPT4
,      DLNONSALCORPAMTPOSTEDOPT4
,      DLELEMENTINPUTOPT4
,      DLNONSALEFFDATEOPT4
,      DLNONSALELIGOPT4
,      DLNAMENONMONPL
,      DLNONMONUOMPL
,      DLNONMONCWBAMTPL
,      DLNONMONAMTPOSTEDPL
,      DLNONMONELINPUTPL
,      DLNONMONEFFDATEPL
,      DLNONMONELIGPL
,      DLNAMENONMONOPT1
,      DLNONMONUOMOPT1
,      DLNONMONCWBAMTOPT1
,      DLNONMONAMTPOSTEDOPT1
,      DLNONMONELINPUTOPT1
,      DLNONMONEFFDATEOPT1
,      DLNONMONELIGOPT1
,      DLNAMENONMONOPT2
,      DLNONMONUOMOPT2
,      DLNONMONCWBAMTOPT2
,      DLNONMONAMTPOSTEDOPT2
,      DLNONMONELINPUTOPT2
,      DLNONMONEFFDATEOPT2
,      DLNONMONELIGOPT2
,      DLNAMENONMONOPT3
,      DLNONMONUOMOPT3
,      DLNONMONCWBAMTOPT3
,      DLNONMONAMTPOSTEDOPT3
,      DLNONMONELINPUTOPT3
,      DLNONMONEFFDATEOPT3
,      DLNONMONELIGOPT3
,      DLNAMENONMONOPT4
,      DLNONMONUOMOPT4
,      DLNONMONCWBAMTOPT4
,      DLNONMONAMTPOSTEDOPT4
,      DLNONMONELINPUTOPT4
,      DLNONMONEFFDATEOPT4
,      DLNONMONELIGOPT4
,      DLNAMERECURPL
,      DLRECURCURRENCYPL
,      DLRECURELIGSALPL
,      DLRECURCWBAMTPL
,      DLRECURPERCENTSALPL
,      DLRPREVELEMENTAMTPL
,      DLRELEMENTAMTPL
,      DLRECURXRATEPL
,      DLRECURCORPELIGSALPL
,      DLRECURCORPCWBAMTPL
,      DLCORPRPREVELEMENTAMTPL
,      DLRECURCORPAMTPOSTEDPL
,      DLRELEMENTINPUTPL
,      DLRECUREFFDATEPL
,      DLRECURELIGPL
,      DLNAMERECUROPT1
,      DLRECURCURRENCYOPT1
,      DLRECURELIGSALOPT1
,      DLRECURCWBAMTOPT1
,      DLRECURPERCENTSALOPT1
,      DLRPREVELEMENTAMTOPT1
,      DLRELEMENTAMTOPT1
,      DLRECURXRATEOPT1
,      DLRECURCORPELIGSALOPT1
,      DLRECURCORPCWBAMTOPT1
,      DLCORPRPREVELEMENTAMTOPT1
,      DLRECURCORPAMTPOSTEDOPT1
,      DLRELEMENTINPUTOPT1
,      DLRECUREFFDATEOPT1
,      DLRECURELIGOPT1
,      DLNAMERECUROPT2
,      DLRECURCURRENCYOPT2
,      DLRECURELIGSALOPT2
,      DLRECURCWBAMTOPT2
,      DLRECURPERCENTSALOPT2
,      DLRPREVELEMENTAMTOPT2
,      DLRELEMENTAMTOPT2
,      DLRECURXRATEOPT2
,      DLRECURCORPELIGSALOPT2
,      DLRECURCORPCWBAMTOPT2
,      DLCORPRPREVELEMENTAMTOPT2
,      DLRECURCORPAMTPOSTEDOPT2
,      DLRELEMENTINPUTOPT2
,      DLRECUREFFDATEOPT2
,      DLRECURELIGOPT2
,      DLNAMERECUROPT3
,      DLRECURCURRENCYOPT3
,      DLRECURELIGSALOPT3
,      DLRECURCWBAMTOPT3
,      DLRECURPERCENTSALOPT3
,      DLRPREVELEMENTAMTOPT3
,      DLRELEMENTAMTOPT3
,      DLRECURXRATEOPT3
,      DLRECURCORPELIGSALOPT3
,      DLRECURCORPCWBAMTOPT3
,      DLCORPRPREVELEMENTAMTOPT3
,      DLRECURCORPAMTPOSTEDOPT3
,      DLRELEMENTINPUTOPT3
,      DLRECUREFFDATEOPT3
,      DLRECURELIGOPT3
,      DLNAMERECUROPT4
,      DLRECURCURRENCYOPT4
,      DLRECURELIGSALOPT4
,      DLRECURCWBAMTOPT4
,      DLRECURPERCENTSALOPT4
,      DLRPREVELEMENTAMTOPT4
,      DLRELEMENTAMTOPT4
,      DLRECURXRATEOPT4
,      DLRECURCORPELIGSALOPT4
,      DLRECURCORPCWBAMTOPT4
,      DLCORPRPREVELEMENTAMTOPT4
,      DLRECURCORPAMTPOSTEDOPT4
,      DLRELEMENTINPUTOPT4
,      DLRECUREFFDATEOPT4
,      DLRECURELIGOPT4
,      DLCWBRATING
,      DLPOSTEDRATING
,      DLRATINGTYPE
,      DLRATINGDATE
,      DLASSFLAG
,      DLBEFOREJOB
,      DLAFTERJOB
,      DLJOB
,      DLBEFOREPOSITION
,      DLAFTERPOSITION
,      DLPOSITION
,      DLBEFOREGRADE
,      DLAFTERGRADE
,      DLGRADE
,      DLBEFOREGROUP
,      DLAFTERGROUP
,      DLGRUP
,      DLCHANGEREASON
,      DLPENDGWORKFLOW
,      DLBEFOREFLEX1
,      DLAFTERFLEX1
,      DLFLEX1
,      DLBEFOREFLEX2
,      DLAFTERFLEX2
,      DLFLEX2
,      DLBEFOREFLEX3
,      DLAFTERFLEX3
,      DLFLEX3
,      DLBEFOREFLEX4
,      DLAFTERFLEX4
,      DLFLEX4
,      DLBEFOREFLEX5
,      DLAFTERFLEX5
,      DLFLEX5
,      DLBEFOREFLEX6
,      DLAFTERFLEX6
,      DLFLEX6
,      DLBEFOREFLEX7
,      DLAFTERFLEX7
,      DLFLEX7
,      DLBEFOREFLEX8
,      DLAFTERFLEX8
,      DLFLEX8
,      DLBEFOREFLEX9
,      DLAFTERFLEX9
,      DLFLEX9
,      DLBEFOREFLEX10
,      DLAFTERFLEX10
,      DLFLEX10
,      DLBEFOREFLEX11
,      DLAFTERFLEX11
,      DLFLEX11
,      DLBEFOREFLEX12
,      DLAFTERFLEX12
,      DLFLEX12
,      DLBEFOREFLEX13
,      DLAFTERFLEX13
,      DLFLEX13
,      DLBEFOREFLEX14
,      DLAFTERFLEX14
,      DLFLEX14
,      DLBEFOREFLEX15
,      DLAFTERFLEX15
,      DLFLEX15
,      DLBEFOREFLEX16
,      DLAFTERFLEX16
,      DLFLEX16
,      DLBEFOREFLEX17
,      DLAFTERFLEX17
,      DLFLEX17
,      DLBEFOREFLEX18
,      DLAFTERFLEX18
,      DLFLEX18
,      DLBEFOREFLEX19
,      DLAFTERFLEX19
,      DLFLEX19
,      DLBEFOREFLEX20
,      DLAFTERFLEX20
,      DLFLEX20
,      DLBEFOREFLEX21
,      DLAFTERFLEX21
,      DLFLEX21
,      DLBEFOREFLEX22
,      DLAFTERFLEX22
,      DLFLEX22
,      DLBEFOREFLEX23
,      DLAFTERFLEX23
,      DLFLEX23
,      DLBEFOREFLEX24
,      DLAFTERFLEX24
,      DLFLEX24
,      DLBEFOREFLEX25
,      DLAFTERFLEX25
,      DLFLEX25
,      DLBEFOREFLEX26
,      DLAFTERFLEX26
,      DLFLEX26
,      DLBEFOREFLEX27
,      DLAFTERFLEX27
,      DLFLEX27
,      DLBEFOREFLEX28
,      DLAFTERFLEX28
,      DLFLEX28
,      DLBEFOREFLEX29
,      DLAFTERFLEX29
,      DLFLEX29
,      DLBEFOREFLEX30
,      DLAFTERFLEX30
,      DLFLEX30
,      DLASGNEFFECTIVEDATE
,      DLOPTION1ID
,      DLOPTION2ID
,      DLOPTION3ID
,      DLOPTION4ID
,      DLBENEFITACTIONID
,      DLPROCESSDATE
,      DLGROUPPERINLERID
,      DLPERSONID
,      DLREQUESTID
FROM APPS.BEN_CWB_PP_ENH_AUDIT_DN_V;

Dependencies

[top of page]

APPS.BEN_CWB_PP_ENH_AUDIT_DN_V references the following:

SchemaAPPS
SynonymBEN_BENEFIT_ACTIONS
SynonymBEN_CWB_RPT_DETAIL
SynonymBEN_PER_IN_LER
ViewFND_CURRENCIES_VL
PL/SQL PackageFND_GLOBAL - show dependent code
SynonymFND_TERRITORIES_TL
PL/SQL PackageHR_API - show dependent code
PL/SQL PackageHR_GENERAL - show dependent code
ViewHR_LOOKUPS
PL/SQL PackageHR_PERSON_NAME - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
ViewPER_PEOPLE_F
APPS.BEN_CWB_PP_ENH_AUDIT_DN_V is referenced by following:

SchemaPUBLIC
SynonymBEN_CWB_PP_ENH_AUDIT_DN_V