DBA Data[Home] [Help]

APPS.PAY_SG_AWCAP_ARCHIVE dependencies on PER_ALL_ASSIGNMENTS_F

Line 222: l_assignment_id per_all_assignments_f.assignment_id%type;

218: is
219:
220: l_proc_name varchar2(100) ;
221: --
222: l_assignment_id per_all_assignments_f.assignment_id%type;
223: l_payroll_id pay_payroll_actions.payroll_action_id%type ;
224: --------------------------
225: -- Tables for pay_balance_pkg
226: --------------------------

Line 566: p_assignment_id in per_all_assignments_f.assignment_id%type,

562: ----------------------------------------------------------------------------------
563: --Function calculates current year Ordinary Earnings with monthly ceiling of 5,500
564: ---------------------------------------------------------------------------------
565: function get_cur_year_ord_ytd (p_person_id in per_all_people_f.person_id%type,
566: p_assignment_id in per_all_assignments_f.assignment_id%type,
567: p_date_earned in date) return number
568: is
569: l_proc_name varchar2(100);
570: --