DBA Data[Home] [Help]

APPS.PAY_ZA_TAX_REG_AR dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 118: per_assignment_extra_info AEI

114: 'SELECT distinct PAF.person_id
115: FROM per_assignments_f PAF,
116: pay_payrolls_f PPY,
117: pay_payroll_actions PPA,
118: per_assignment_extra_info AEI
119: WHERE PPA.payroll_action_id = :payroll_action_id
120: AND PAF.business_group_id = PPA.business_group_id
121: AND PPY.payroll_id = PAF.payroll_id
122: AND AEI.assignment_id = PAF.assignment_id

Line 158: , per_assignment_extra_info aei

154: )
155: IS
156: SELECT PAF.assignment_id
157: FROM per_assignments_f PAF
158: , per_assignment_extra_info aei
159: , per_time_periods ptp
160: WHERE PAF.payroll_id = nvl(p_payroll_id, PAF.payroll_id)
161: AND PAF.assignment_id = nvl(p_asg_id, PAF.assignment_id)
162: AND aei.assignment_id = PAF.assignment_id