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 324: FROM per_assignments_f paf

320: function get_count RETURN NUMBER as
321: l_count NUMBER(15);
322: CURSOR CSR_AE_EFT_COUNT IS
323: SELECT COUNT(*)
324: FROM per_assignments_f paf
325: ,per_people_f pef
326: ,pay_pre_payments ppp
327: ,pay_assignment_actions paa
328: ,pay_payroll_actions ppa

Line 351: FROM per_assignments_f paf

347: function get_total_sum return number as
348: l_total_sum pay_pre_payments.value%type;
349: CURSOR CSR_AE_EFT_SUM is
350: SELECT SUM(ppp.value)
351: FROM per_assignments_f paf
352: ,per_people_f pef
353: ,pay_pre_payments ppp
354: ,pay_assignment_actions paa
355: ,pay_payroll_actions ppa

Line 379: FROM per_assignments_f paf

375: function get_credit_sum return number as
376: l_credit_sum pay_pre_payments.value%type;
377: CURSOR CSR_AE_EFT_SUM is
378: SELECT SUM(ppp.value)
379: FROM per_assignments_f paf
380: ,per_people_f pef
381: ,pay_pre_payments ppp
382: ,pay_assignment_actions paa
383: ,pay_payroll_actions ppa

Line 407: FROM per_assignments_f paf

403: function get_debit_sum return number as
404: l_debit_sum pay_pre_payments.value%type;
405: CURSOR CSR_AE_EFT_SUM is
406: SELECT SUM(ppp.value)
407: FROM per_assignments_f paf
408: ,per_people_f pef
409: ,pay_pre_payments ppp
410: ,pay_assignment_actions paa
411: ,pay_payroll_actions ppa