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 563: p_assignment_id in per_all_assignments_f.assignment_id%type,

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