140: -- IN : p_payroll_id NUMBER --
141: -- p_date DATE --
142: --------------------------------------------------------------------------
143: FUNCTION get_period_number
144: ( p_payroll_id in pay_all_payrolls_f.payroll_id%type,
145: p_date in date )
146: return number is
147: l_start_date date;
148: l_end_date date;
374: (p_element_entry_id in pay_element_entries_f.element_entry_id%type ,
375: p_effective_date in date ,
376: p_entry_type_flag in varchar2,
377: p_entry_end_date in date ,
378: p_payroll_id in pay_all_payrolls_f.payroll_id%type,
379: p_rent_paid out nocopy t_rent_paid,
380: p_month out nocopy t_month )
381: is
382: l_effective_date date;
796: ****/
797: l_assignment_id per_all_assignments_f.assignment_id%type ;
798: l_asg_end_date DATE ;
799: l_last_period_num NUMBER ;
800: l_payroll_id pay_all_payrolls_f.payroll_id%type;
801: l_current_month_rent NUMBER ;
802: l_rent_paid_tbl t_rent_paid ;
803: l_month_tbl t_month ;
804: l_hra_tbl t_bal_value ;