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_AE_GENERAL dependencies on PER_ASSIGNMENTS_F

Line 286: FROM per_assignments_f paf

282: function get_count RETURN NUMBER as
283: l_count NUMBER(15);
284: CURSOR CSR_AE_EFT_COUNT IS
285: SELECT COUNT(*)
286: FROM per_assignments_f paf
287: ,per_people_f pef
288: ,pay_pre_payments ppp
289: ,pay_assignment_actions paa
290: ,pay_payroll_actions ppa

Line 313: FROM per_assignments_f paf

309: function get_total_sum return number as
310: l_total_sum pay_pre_payments.value%type;
311: CURSOR CSR_AE_EFT_SUM is
312: SELECT SUM(ppp.value)
313: FROM per_assignments_f paf
314: ,per_people_f pef
315: ,pay_pre_payments ppp
316: ,pay_assignment_actions paa
317: ,pay_payroll_actions ppa

Line 341: FROM per_assignments_f paf

337: function get_credit_sum return number as
338: l_credit_sum pay_pre_payments.value%type;
339: CURSOR CSR_AE_EFT_SUM is
340: SELECT SUM(ppp.value)
341: FROM per_assignments_f paf
342: ,per_people_f pef
343: ,pay_pre_payments ppp
344: ,pay_assignment_actions paa
345: ,pay_payroll_actions ppa

Line 369: FROM per_assignments_f paf

365: function get_debit_sum return number as
366: l_debit_sum pay_pre_payments.value%type;
367: CURSOR CSR_AE_EFT_SUM is
368: SELECT SUM(ppp.value)
369: FROM per_assignments_f paf
370: ,per_people_f pef
371: ,pay_pre_payments ppp
372: ,pay_assignment_actions paa
373: ,pay_payroll_actions ppa