DBA Data[Home] [Help]

APPS.PAY_AE_GENERAL dependencies on PER_PEOPLE_F

Line 325: ,per_people_f pef

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
329: WHERE paa.payroll_action_id =

Line 352: ,per_people_f pef

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
356: WHERE paa.payroll_action_id =

Line 380: ,per_people_f pef

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
384: WHERE paa.payroll_action_id =

Line 408: ,per_people_f pef

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
412: WHERE paa.payroll_action_id =