[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
20-feb-2001 djoshi 115.2 Added procedure to delete the
pl/sql table for the accurual
procedure is
delete_ltr_assignment_accrual
29-NOV-2001 asasthan Changed get_net_accruals
Added p_assignment_action_id
parameter
24-JAN-2002 ahanda Added fnd_date.canonical_to_date
for getting Cont Calc Date
12-JUN-2002 ahanda 115.5 Changed length of var lv_accrual_code
to 100.
26-JUN-2003 ahanda 115.6 Changed cursor c_accrual_category
06-Aug-2003 vpandya 115.8 Added NOCOPY with out parameter.
28-May-2005 sackumar 115.9 4053111 in get_emp_net_accrual procedure the
values of current arrcrual is coming
incorrectly for that i introduce a new
call of the procedure
per_accrual_calc_functions.get_net_accrual
17-JUN-2005 sackumar 115.10 Add distinct in c_accrual_category cursor.
17-OCT-2005 ahanda 115.11 4681780 Initalized variables
18-OCT-2005 ahanda 115.12 4681780 Initalized all total variables
09-JAN-2006 ahanda 115.13 4761039 Passing -1 for asg action in
pay_us_pto_accrual.get_net_accrual
31-MAY-2006 ppanda 115.14 5220628 Cursor c_accrual_category changed in procedure
get_emp_net_accrual to filter values based on
Security Group
02-OCT-2006 ahanda 115.15 5473954 Storing Accrual Code in PL/SQL table
05-MAR-2007 sackumar 115.16 5470648 Modified get_emp_net_accrual procedure.
*******************************************************************/
AS
/*****************************************************
** Global Package Body Variables
******************************************************/
gv_package_name VARCHAR2(100) := 'pay_us_emp_payslip_accrual_web';
select start_date,
end_date,
period_num,
ptpt.number_per_fiscal_year
from per_time_period_types ptpt,
per_time_periods ptp
where ptpt.period_type = ptp.period_type
and ptp.payroll_id = cp_payroll_id
and cp_effective_date between ptp.start_date
and ptp.end_date;
select payroll_id, business_group_id
from pay_payroll_actions ppa,
pay_assignment_actions paa
where ppa.payroll_action_id = paa.payroll_action_id
and paa.assignment_action_id = cp_assignment_action_id;
select distinct flv.lookup_code,
flv.meaning
from fnd_lookup_values flv
where flv.lookup_type = 'US_PTO_ACCRUAL'
and flv.language = nvl(cp_language,userenv('LANG'))
and flv.security_group_id = fnd_global.lookup_security_group(flv.lookup_type, flv.view_application_id);
select pap.accrual_plan_id,
pap.accrual_plan_element_type_id
from pay_accrual_plans pap,
pay_element_links_f pel,
pay_element_entries_f pee
where pap.accrual_category = cp_accrual_category
and pel.element_type_id= pap.accrual_plan_element_type_id
and cp_effective_date between pel.effective_start_date
and pel.effective_end_date
and pee.element_link_id = pel.element_link_id
and pee.assignment_id = cp_assignment_id
and cp_effective_date between pee.effective_start_date
and pee.effective_end_date;
PROCEDURE delete_ltr_assignment_accrual
/******************************************************************
**
** Description:
** This procedure Deletes the ltr_assignment_accrual PL/SQL
** Table
**
**
** Access Status:
** Public.
**
******************************************************************/
IS
BEGIN
/* Delete the accrual PL/SQL table */
ltr_assignment_accruals.delete;
END delete_ltr_assignment_accrual;