DBA Data[Home] [Help]

APPS.PAY_SA_GENERAL dependencies on PER_ASSIGNMENTS_F

Line 198: FROM per_assignments_f paf

194: function get_sum return number as
195: l_sum pay_pre_payments.value%type;
196: CURSOR CSR_SA_EFT_SUM is
197: SELECT SUM(ppp.value)
198: FROM per_assignments_f paf
199: ,per_people_f pef
200: ,pay_pre_payments ppp
201: ,pay_assignment_actions paa
202: ,pay_payroll_actions ppa

Line 225: FROM per_assignments_f paf

221: function get_count RETURN NUMBER as
222: l_count NUMBER(15);
223: CURSOR CSR_SA_EFT_COUNT IS
224: SELECT COUNT(*)
225: FROM per_assignments_f paf
226: ,per_people_f pef
227: ,pay_pre_payments ppp
228: ,pay_assignment_actions paa
229: ,pay_payroll_actions ppa