[Home] [Help]
12: -- Date Author Reference Description
13: -- -----------+--------+---------+------------------------------------------
14: -- 01 Sep 2004 JLin N/A Fixed GSCC warning
15: -- 12 Aug 2004 JLin 3781867 Modified accraul_category getting
16: -- from the pay_au_processes table
17: -- 04 Dec 2002 Ragovind 2689226 Added NOCOPY for the functions leave_net_accrual, leave_net_entitlement, range_code and added dbdrv
18: -- 25 JUL 2000 rayyadev N/A modified the query of cursor c_Accrual_plans
19: -- in the archive_code procedure
20: -- 14 JUL 2000 rayyadev N/A Created
55: 'and ee.assignment_id = a.assignment_id ' ||
56: 'and el.element_link_id = ee.element_link_id ' ||
57: 'and ap.accrual_plan_element_type_id = el.element_type_id ' ||
58: 'and ap.accrual_category In (select accrual_category ' ||
59: 'from pay_au_processes ' ||
60: 'where accrual_category is not null ' ||
61: 'and legislation_code = ''AU'') ' ||
62: 'and pa.effective_date between p.effective_start_date ' ||
63: 'and p.effective_end_date ' ||
116: and ee.assignment_id = a.assignment_id
117: and el.element_link_id = ee.element_link_id
118: and ap.accrual_plan_element_type_id = el.element_type_id
119: and ap.accrual_category IN (select accrual_category
120: from pay_au_processes
121: where legislation_code = 'AU'
122: and accrual_category is not null)
123: and pa.effective_date between a.effective_start_date
124: and a.effective_end_date
198: (p_assignment_action_id in number
199: ,p_effective_date in date) is
200:
201: l_procedure_name varchar2(61) ;
202: l_process_id pay_au_processes.process_id%type ;
203: l_gcc_parameters_store pay_au_generic_code_caller.t_variable_store_tab ;
204: l_business_group_id pay_payroll_actions.business_group_id%type ;
205: l_assignment_id pay_assignment_actions.assignment_id%type ;
206: l_payroll_action_id pay_payroll_actions.payroll_action_id%type ;
208: l_accrual_category varchar2(15); --temporary variable to check the accrual category.
209:
210: cursor c_process(p_short_name varchar2) is
211: select p.process_id
212: from pay_au_processes p
213: where p.short_name = p_short_name
214: and p.legislation_code = 'AU' ;
215:
216: cursor c_action(p_assignment_action_id number) is
239: and ee.assignment_id = a.assignment_id
240: and el.element_link_id = ee.element_link_id
241: and ap.accrual_plan_element_type_id = el.element_type_id
242: and ap.accrual_category in (select accrual_category
243: from pay_au_processes
244: where legislation_code = 'AU'
245: and accrual_category is not null)
246: and pa.effective_date between a.effective_start_date
247: and a.effective_end_date
251: and el.effective_end_date ;
252:
253: cursor c_process_category(p_accrual_category varchar2) is
254: select p.process_id
255: from pay_au_processes p
256: where p.accrual_category = p_accrual_category
257: and p.legislation_code = 'AU'
258: and p.accrual_category is not null;
259: