APPS.PAY_SA_GENERAL dependencies on PAY_PRE_PAYMENTS

Line 195: l_sum pay_pre_payments.value%type;

191: END IF;
192: END chk_multiple_assignments;
193: -----
194: function get_sum return number as
195: l_sum pay_pre_payments.value%type;
196: CURSOR CSR_SA_EFT_SUM is
197: SELECT /*+ index(pef) index(ppa) use_nl(paa ppa) use_nl(paa paf) */
198: SUM(ppp.value)
199: FROM per_assignments_f paf

Line 201: ,pay_pre_payments ppp

197: SELECT /*+ index(pef) index(ppa) use_nl(paa ppa) use_nl(paa paf) */
198: SUM(ppp.value)
199: FROM per_assignments_f paf
200: ,per_people_f pef
201: ,pay_pre_payments ppp
202: ,pay_assignment_actions paa
203: ,pay_payroll_actions ppa
204: WHERE paa.payroll_action_id =
205: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

Line 229: ,pay_pre_payments ppp

225: SELECT /*+ index(pef) index(ppa) use_nl(paa ppa) use_nl(paa paf) */
226: COUNT(*)
227: FROM per_assignments_f paf
228: ,per_people_f pef
229: ,pay_pre_payments ppp
230: ,pay_assignment_actions paa
231: ,pay_payroll_actions ppa
232: WHERE paa.payroll_action_id =
233: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')