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.

VIEW: APPS.PAY_US_REPORT_AS_OF_DATE_V

Source

View Text - Preformatted


SELECT paa.tax_unit_id TAX_UNIT_ID, hou.business_group_id , hou.organization_id ORGANIZATION_ID, hou.name ORGANIZATION_NAME, paa.assignment_action_id ASSIGNMENT_ACTION_ID, ppf.person_id PERSON_ID , ppf.full_name FULL_NAME , paf.assignment_id ASSIGNMENT_ID, paf.assignment_number ASSIGNMENT_NUMBER, ppa.effective_date EFFECTIVE_DATE , ppa.date_earned DATE_EARNED , ppa.action_type ACTION_TYPE, paf.effective_end_date EFFECTIVE_END_DATE, paf.effective_start_date EFFECTIVE_START_DATE FROM pay_assignment_actions paa, per_assignments_f paf, per_people_f ppf, pay_payroll_actions ppa, hr_organization_units hou WHERE ppa.payroll_action_id = paa.payroll_action_id AND paa.assignment_id = paf.assignment_id AND paf.person_id = ppf.person_id AND hou.organization_id = paf.organization_id AND ppa.effective_date BETWEEN paf.effective_start_date AND paf.effective_end_date AND ppa.effective_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date AND ppa.action_type in ('B','I','R','Q','V')

View Text - HTML Formatted

SELECT PAA.TAX_UNIT_ID TAX_UNIT_ID
, HOU.BUSINESS_GROUP_ID
, HOU.ORGANIZATION_ID ORGANIZATION_ID
, HOU.NAME ORGANIZATION_NAME
, PAA.ASSIGNMENT_ACTION_ID ASSIGNMENT_ACTION_ID
, PPF.PERSON_ID PERSON_ID
, PPF.FULL_NAME FULL_NAME
, PAF.ASSIGNMENT_ID ASSIGNMENT_ID
, PAF.ASSIGNMENT_NUMBER ASSIGNMENT_NUMBER
, PPA.EFFECTIVE_DATE EFFECTIVE_DATE
, PPA.DATE_EARNED DATE_EARNED
, PPA.ACTION_TYPE ACTION_TYPE
, PAF.EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, PAF.EFFECTIVE_START_DATE EFFECTIVE_START_DATE
FROM PAY_ASSIGNMENT_ACTIONS PAA
, PER_ASSIGNMENTS_F PAF
, PER_PEOPLE_F PPF
, PAY_PAYROLL_ACTIONS PPA
, HR_ORGANIZATION_UNITS HOU
WHERE PPA.PAYROLL_ACTION_ID = PAA.PAYROLL_ACTION_ID
AND PAA.ASSIGNMENT_ID = PAF.ASSIGNMENT_ID
AND PAF.PERSON_ID = PPF.PERSON_ID
AND HOU.ORGANIZATION_ID = PAF.ORGANIZATION_ID
AND PPA.EFFECTIVE_DATE BETWEEN PAF.EFFECTIVE_START_DATE
AND PAF.EFFECTIVE_END_DATE
AND PPA.EFFECTIVE_DATE BETWEEN PPF.EFFECTIVE_START_DATE
AND PPF.EFFECTIVE_END_DATE
AND PPA.ACTION_TYPE IN ('B'
, 'I'
, 'R'
, 'Q'
, 'V')