[Home] [Help]
132: ppa.effective_date
133: from per_people_f per,
134: per_periods_of_service pds,
135: per_assignments_f asg,
136: pay_payroll_actions ppa,
137: pay_assignment_actions paa
138: where paa.assignment_action_id = p_assignment_action_id
139: and ppa.payroll_action_id = paa.payroll_action_id
140: and asg.assignment_id = paa.assignment_id
150: cursor csr_cash_receipt is
151: select to_number(pi.aei_information13) "Cash Receipt"
152: from per_assignment_extra_info pi,
153: pay_assignment_actions paa,
154: pay_payroll_actions ppa
155: where paa.assignment_action_id = p_assignment_action_id
156: and ppa.payroll_action_id = paa.payroll_action_id
157: and pi.assignment_id = paa.assignment_id
158: and pi.information_type = 'KR_YEA_TAX_EXEM_INFO'
167: aei_information5 emp_don_exp_nts,
168: aei_information6 emp_ins_exp_nts -- Bug 5667762
169: from per_assignment_extra_info pei,
170: pay_assignment_actions paa,
171: pay_payroll_actions ppa
172: where paa.assignment_action_id = p_assignment_action_id
173: and ppa.payroll_action_id = paa.payroll_action_id
174: and pei.assignment_id = paa.assignment_id
175: and pei.information_type = 'KR_YEA_EMP_EXPENSE_DETAILS'
181: nvl(to_number(aei_information20), 0) + nvl(to_number(aei_information22), 0) +
182: nvl(to_number(aei_information23), 0) + nvl(to_number(aei_information30), 0)
183: from per_assignment_extra_info pi,
184: pay_assignment_actions paa,
185: pay_payroll_actions ppa
186: where paa.assignment_action_id = p_assignment_action_id
187: and ppa.payroll_action_id = paa.payroll_action_id
188: and pi.assignment_id = paa.assignment_id
189: and pi.information_type = 'KR_YEA_SP_TAX_EXEM_INFO'
194: select nvl(to_number(aei_information7), 0) + nvl(to_number(aei_information10), 0)
195: + nvl(to_number(aei_information12), 0)
196: from per_assignment_extra_info pi,
197: pay_assignment_actions paa,
198: pay_payroll_actions ppa
199: where paa.assignment_action_id = p_assignment_action_id
200: and ppa.payroll_action_id = paa.payroll_action_id
201: and pi.assignment_id = paa.assignment_id
202: and pi.information_type = 'KR_YEA_TAX_EXEM_INFO'
209: nvl(to_number(aei_information6), 0),
210: nvl(to_number(aei_information2),0)
211: from per_assignment_extra_info pi,
212: pay_assignment_actions paa,
213: pay_payroll_actions ppa
214: where paa.assignment_action_id = p_assignment_action_id
215: and ppa.payroll_action_id = paa.payroll_action_id
216: and pi.assignment_id = paa.assignment_id
217: and pi.information_type = 'KR_YEA_SP_TAX_EXEM_INFO2'
220:
221: -- Bug 5726158
222: cursor csr_asg_details is
223: select paa.assignment_id, ppa.effective_date
224: from pay_payroll_actions ppa,
225: pay_assignment_actions paa
226: where paa.assignment_action_id = p_assignment_action_id
227: and ppa.payroll_action_id = paa.payroll_action_id;
228: --