DBA Data[Home] [Help]

APPS.PAY_US_SQWL_ARCHIVE dependencies on PAY_ACTION_CLASSIFICATIONS

Line 2047: pay_action_classifications pac,

2043: ppa.effective_date
2044: from pay_assignment_actions paa,
2045: per_all_assignments_f paf,
2046: pay_payroll_actions ppa,
2047: pay_action_classifications pac,
2048: per_all_assignments_f paf1
2049: where paf1.assignment_id = p_assignment_id
2050: and paf.person_id = paf1.person_id
2051: and paa.assignment_id = paf.assignment_id

Line 2080: PAY_ACTION_CLASSIFICATIONS PAC

2076: FROM PER_ALL_ASSIGNMENTS_F PAF1,
2077: PER_ALL_ASSIGNMENTS_F PAF ,
2078: PAY_ASSIGNMENT_ACTIONS PAA,
2079: PAY_PAYROLL_ACTIONS PPA ,
2080: PAY_ACTION_CLASSIFICATIONS PAC
2081: WHERE PAF1.ASSIGNMENT_ID = p_assignment_id
2082: AND PAF.PERSON_ID = PAF1.PERSON_ID
2083: AND PAA.ASSIGNMENT_ID = PAF.ASSIGNMENT_ID
2084: AND PAA.TAX_UNIT_ID = taxunitid