DBA Data[Home] [Help]

APPS.PY_ZA_PRORATE_PKG dependencies on PER_ASSIGNMENTS_F

Line 68: from per_assignments_f

64: FUNCTION pro_rate(payroll_action_id IN number)
65: RETURN NUMBER IS
66:
67: CURSOR c2 (x_payroll_action_id number) is select effective_start_date,effective_end_date
68: from per_assignments_f
69: where payroll_id = (select payroll_id
70: from pay_payroll_actions
71: where payroll_action_id = x_payroll_action_id)
72: and assignment_id = (select assignment_id