APPS.PAY_AE_GENERAL dependencies on PAY_PRE_PAYMENTS

Line 288: ,pay_pre_payments ppp

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 =
292: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

Line 310: l_total_sum pay_pre_payments.value%type;

306: return l_count;
307: END get_count;
308: ---------
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

Line 315: ,pay_pre_payments ppp

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 =
319: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

Line 338: l_credit_sum pay_pre_payments.value%type;

334: END get_total_sum;
335: --------
336: ---------
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

Line 343: ,pay_pre_payments ppp

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 =
347: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

Line 366: l_debit_sum pay_pre_payments.value%type;

362: END get_credit_sum;
363: --------
364: ---------
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

Line 371: ,pay_pre_payments ppp

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 =
375: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')