[Home] [Help]
33:
34: PROCEDURE create_payroll_action AS
35: BEGIN
36:
37: SELECT pay_payroll_actions_s.nextval
38: INTO g_payroll_action_id
39: FROM dual;
40:
41: INSERT INTO pay_payroll_actions
37: SELECT pay_payroll_actions_s.nextval
38: INTO g_payroll_action_id
39: FROM dual;
40:
41: INSERT INTO pay_payroll_actions
42: (payroll_action_id
43: ,action_type
44: ,business_group_id
45: ,effective_date