[Home] [Help]
206: to_number(SUBSTR(MAX(lpad(paa.action_sequence,15,'0')
207: || paa.assignment_action_id),16)) lat_assignment_action_id,
208: MAX(pact.effective_date) effective_date,
209: paa.assignment_id
210: FROM pay_assignment_actions paa,
211: pay_payroll_actions pact
212: WHERE paa.payroll_action_id = pact.payroll_action_id
213: AND pact.action_type IN ('Q','R','B','I','V')
214: AND paa.action_status IN ('C','S')
461: fnd_file.put_line(fnd_file.LOG,'Pamount:' || p_amount );
462: fnd_file.put_line(fnd_file.LOG,'p_element_type_id:' || p_element_type_id);
463: fnd_file.put_line(fnd_file.LOG,'p_assignment_action_id:' || p_assignment_action_id);
464:
465: select effective_date into l_eff_date from pay_assignment_actions paa, pay_payroll_actions ppa where ppa.payroll_action_id = paa.payroll_action_id
466: and paa.assignment_action_id = p_assignment_action_id;
467:
468: select business_group_id, payroll_id into g_business_group_id , l_payroll_id
469: from pay_payroll_Actions ppa,
466: and paa.assignment_action_id = p_assignment_action_id;
467:
468: select business_group_id, payroll_id into g_business_group_id , l_payroll_id
469: from pay_payroll_Actions ppa,
470: pay_assignment_Actions paa
471: where paa.PAYROLL_ACTION_ID = ppa.payroll_Action_id
472: and paa.assignment_action_id = p_assignment_action_id;
473:
474: select SEGMENT1 into g_paye_reference from hr_soft_coding_keyflex hr , pay_payrolls_f p