DBA Data[Home] [Help]

APPS.PAY_KW_GENERAL dependencies on PER_ASSIGNMENTS_F

Line 272: FROM per_assignments_f paf

268: function get_count RETURN NUMBER as
269: l_count NUMBER(15);
270: CURSOR CSR_KW_EFT_COUNT IS
271: SELECT COUNT(*)
272: FROM per_assignments_f paf
273: ,per_people_f pef
274: ,pay_pre_payments ppp
275: ,pay_assignment_actions paa
276: ,pay_payroll_actions ppa

Line 299: FROM per_assignments_f paf

295: function get_sum return number as
296: l_sum pay_pre_payments.value%type;
297: CURSOR CSR_KW_EFT_SUM is
298: SELECT SUM(ppp.value)
299: FROM per_assignments_f paf
300: ,per_people_f pef
301: ,pay_pre_payments ppp
302: ,pay_assignment_actions paa
303: ,pay_payroll_actions ppa