DBA Data[Home] [Help]

APPS.PAY_AE_GENERAL dependencies on PER_PEOPLE_F

Line 287: ,per_people_f pef

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

Line 314: ,per_people_f pef

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

Line 342: ,per_people_f pef

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

Line 370: ,per_people_f pef

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