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_SA_GENERAL dependencies on PAY_PRE_PAYMENTS

Line 195: l_sum pay_pre_payments.value%type;

191: END IF;
192: END chk_multiple_assignments;
193: -----
194: function get_sum return number as
195: l_sum pay_pre_payments.value%type;
196: CURSOR CSR_SA_EFT_SUM is
197: SELECT SUM(ppp.value)
198: FROM per_assignments_f paf
199: ,per_people_f pef

Line 200: ,pay_pre_payments ppp

196: CURSOR CSR_SA_EFT_SUM is
197: SELECT SUM(ppp.value)
198: FROM per_assignments_f paf
199: ,per_people_f pef
200: ,pay_pre_payments ppp
201: ,pay_assignment_actions paa
202: ,pay_payroll_actions ppa
203: WHERE paa.payroll_action_id =
204: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

Line 227: ,pay_pre_payments ppp

223: CURSOR CSR_SA_EFT_COUNT IS
224: SELECT COUNT(*)
225: FROM per_assignments_f paf
226: ,per_people_f pef
227: ,pay_pre_payments ppp
228: ,pay_assignment_actions paa
229: ,pay_payroll_actions ppa
230: WHERE paa.payroll_action_id =
231: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')