eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_KR_PAYKRYTR_PKG dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 152: from per_assignment_extra_info pi,

148:
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

Line 169: from per_assignment_extra_info pei,

165: aei_information3 emp_educ_exp_nts,
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

Line 183: from per_assignment_extra_info pi,

179: cursor csr_get_emp_exp_amount is
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

Line 196: from per_assignment_extra_info pi,

192:
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

Line 211: from per_assignment_extra_info pi,

207: select nvl(to_number(aei_information4), 0) +
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