APPS.PAY_NZ_LEAVE_LIABILITY dependencies on PAY_ASSIGNMENT_ACTIONS

Line 124: select pay_assignment_actions_s.nextval

120: and pa.effective_date between el.effective_start_date
121: and el.effective_end_date ;
122:
123: cursor c_assignment_action_id is
124: select pay_assignment_actions_s.nextval
125: from dual ;
126:
127: begin
128:

Line 194: l_assignment_id pay_assignment_actions.assignment_id%type ;

190: l_procedure_name varchar2(61) := 'pay_nz_leave_liability.archive_code' ;
191: l_process_id pay_au_processes.process_id%type ;
192: l_gcc_parameters_store pay_au_generic_code_caller.t_variable_store_tab ;
193: l_business_group_id pay_payroll_actions.business_group_id%type ;
194: l_assignment_id pay_assignment_actions.assignment_id%type ;
195: l_payroll_action_id pay_payroll_actions.payroll_action_id%type ;
196: l_counter integer := 1 ;
197:
198: cursor c_process(p_short_name varchar2) is

Line 208: from pay_assignment_actions aa

204: cursor c_action(p_assignment_action_id number) is
205: select pa.business_group_id
206: , pa.payroll_action_id
207: , aa.assignment_id
208: from pay_assignment_actions aa
209: , pay_payroll_actions pa
210: where aa.assignment_action_id = p_assignment_action_id
211: and pa.payroll_action_id = aa.payroll_action_id ;
212:

Line 216: from pay_assignment_actions aa

212:
213: cursor c_accrual_plans(p_assignment_action_id number) is
214: select ap.accrual_plan_id
215: , a.payroll_id
216: from pay_assignment_actions aa
217: , pay_payroll_actions pa
218: , per_assignments_f a
219: , pay_element_entries_f ee
220: , pay_element_links_f el