eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: HRFV_BACKFEED_PAYMENT_DETAILS

Product:	PER - Human Resources
Description:	Business view template from which the flexfield view is generated.
Implementation/DBA Data:	APPS.HRFV_BACKFEED_PAYMENT_DETAILS

View Text

SELECT /* UNIQUE ATTRIBUTES */ ORG.NAME
, PPY.PAYROLL_NAME
, BPR.PAYROLL_IDENTIFIER
, ASG.ASSIGNMENT_NUMBER
, PEO.EMPLOYEE_NUMBER /* REGULAR ATTRIBUTES */
, PEO.FULL_NAME
, BPR.PERIOD_START_DATE
, BPR.PERIOD_END_DATE
, BPR.PROCESSING_DATE
, BPD.CHECK_NUMBER
, BPD.PAYMENT_DATE
, BPD.AMOUNT
, HR_GENERAL.DECODE_LOOKUP('BACKFEED_PD_CHECK_TYPE'
, BPD.CHECK_TYPE)
, POPM.ORG_PAYMENT_METHOD_NAME
, PPT.PAYMENT_TYPE_NAME
, POPM.CURRENCY_CODE /* FOREIGN KEY RESOLUTIONS */ /* DESCRIPTIVE FLEXFIELD COLUMNS */
, '_DF:PER:PER_BF_PAYMENT_DETAILS:BPD'
, '_DF:PER:PER_BF_PROCESSED_ASSIGNMENTS:BPA'
, '_DF:PER:PER_BF_PAYROLL_RUNS:BPR' /* ID'S */
, PEO.PERSON_ID
, ASG.ASSIGNMENT_ID
, PPY.PAYROLL_ID
, BPR.PAYROLL_RUN_ID
, BPD.PAYMENT_DETAIL_ID
, PPM.PERSONAL_PAYMENT_METHOD_ID
FROM PER_PEOPLE_F PEO
, PER_ALL_ASSIGNMENTS_F ASG
, PER_BUSINESS_GROUPS ORG
, PAY_PAYMENT_TYPES PPT
, PAY_ORG_PAYMENT_METHODS_F POPM
, PAY_PERSONAL_PAYMENT_METHODS_F PPM
, PER_BF_PAYMENT_DETAILS BPD
, PER_BF_PROCESSED_ASSIGNMENTS BPA
, PER_BF_PAYROLL_RUNS BPR
, PAY_ALL_PAYROLLS_F PPY
WHERE ORG.BUSINESS_GROUP_ID = BPR.BUSINESS_GROUP_ID
AND PPY.PAYROLL_ID = BPR.PAYROLL_ID
AND BPR.PAYROLL_RUN_ID = BPA.PAYROLL_RUN_ID
AND BPA.ASSIGNMENT_ID = ASG.ASSIGNMENT_ID
AND PEO.PERSON_ID = ASG.PERSON_ID
AND BPA.PROCESSED_ASSIGNMENT_ID = BPD.PROCESSED_ASSIGNMENT_ID
AND BPD.PERSONAL_PAYMENT_METHOD_ID = PPM.PERSONAL_PAYMENT_METHOD_ID
AND PPM.ORG_PAYMENT_METHOD_ID = POPM.ORG_PAYMENT_METHOD_ID
AND POPM.PAYMENT_TYPE_ID = PPT.PAYMENT_TYPE_ID
AND TRUNC(SYSDATE) BETWEEN ASG.EFFECTIVE_START_DATE
AND ASG.EFFECTIVE_END_DATE
AND TRUNC(SYSDATE) BETWEEN POPM.EFFECTIVE_START_DATE
AND POPM.EFFECTIVE_END_DATE
AND TRUNC(SYSDATE) BETWEEN PPM.EFFECTIVE_START_DATE
AND PPM.EFFECTIVE_END_DATE
AND TRUNC(SYSDATE) BETWEEN PEO.EFFECTIVE_START_DATE
AND PEO.EFFECTIVE_END_DATE
AND TRUNC(SYSDATE) BETWEEN PPY.EFFECTIVE_START_DATE
AND PPY.EFFECTIVE_END_DATE WITH READ ONLY

Columns

Name
BUSINESS_GROUP_NAME
PAYROLL_NAME
PAYROLL_RUN_IDENTIFIER
ASSIGNMENT_NUMBER
EMPLOYEE_NUMBER
PERSON_NAME
PROCESSING_PERIOD_START_DATE
PROCESSING_PERIOD_END_DATE
PROCESSING_DATE
CHECK_NUMBER
PAYMENT_DATE
AMOUNT
CHECK_TYPE
PAYMENT_METHOD
PAYMENT_TYPE
CURRENCY_CODE
"_DF:PAYMENTS"
"_DF:ASSIGNMENTS"
"_DF:PAYROLL"
PERSON_ID
ASSIGNMENT_ID
PAYROLL_ID
PAYROLL_RUN_ID
PAYMENT_DETAIL_ID
PERSONAL_PAYMENT_METHOD_ID