APPS.PAY_KR_PAYKRYTR_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 137: pay_assignment_actions paa

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
141: and ppa.effective_date

Line 153: pay_assignment_actions paa,

149: -- 4289780
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

Line 170: pay_assignment_actions paa,

166: aei_information4 emp_card_exp_nts,
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

Line 184: pay_assignment_actions paa,

180: select nvl(to_number(aei_information18), 0) + nvl(to_number(aei_information19), 0) +
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

Line 197: pay_assignment_actions paa,

193: cursor csr_get_emp_card_expense is
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

Line 212: pay_assignment_actions paa,

208: nvl(to_number(aei_information5), 0) +
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

Line 225: pay_assignment_actions paa

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: --
229: l_asg_details csr_asg_details%rowtype;