DBA Data[Home] [Help]

APPS.HR_US_W4_EX dependencies on PAY_ACTION_CLASSIFICATIONS

Line 98: pay_action_classifications pac

94: select paa.assignment_action_id
95: from pay_assignment_actions paa,
96: per_all_assignments_f paf,
97: pay_payroll_actions ppa,
98: pay_action_classifications pac
99: where paf.person_id = p_person_id
100: and paa.assignment_id = paf.assignment_id
101: and paa.tax_unit_id = w4_tax_unit_id
102: and paa.payroll_action_id = ppa.payroll_action_id

Line 144: pay_action_classifications pac2

140: into l_bal_aaid
141: from pay_assignment_actions paa1,
142: per_assignments_f paf2,
143: pay_payroll_actions ppa2,
144: pay_action_classifications pac2
145: where paf2.person_id = w4_person_id
146: and paa1.assignment_id = paf2.assignment_id
147: and paa1.tax_unit_id = w4_tax_unit_id
148: and paa1.payroll_action_id = ppa2.payroll_action_id

Line 156: FROM pay_action_classifications pac,

152: and paf2.effective_end_date
153: and ppa2.effective_date between w4_start_date and
154: w4_end_date
155: and not exists (select ''
156: FROM pay_action_classifications pac,
157: pay_payroll_actions ppa,
158: pay_assignment_actions paa,
159: per_assignments_f paf1
160: WHERE paf1.person_id = w4_person_id