APPS.HRBALDTM dependencies on PAY_PAYROLL_ACTIONS

Line 22: mwcallag 19-JAN-1995 - Temp. insert into pay_payroll_actions now also

18: action. The procedure first creates a payroll action which is used
19: to insert the assignment action on the effective date.
20: --
21: MODIFIED (DD-MON-YYYY)
22: mwcallag 19-JAN-1995 - Temp. insert into pay_payroll_actions now also
23: populates date_earned with the virtual date
24: value.
25: mwcallag 10-JAN-1995 - New mandatory column 'object_version_number'
26: added to insert of pay_payroll_actions.

Line 26: added to insert of pay_payroll_actions.

22: mwcallag 19-JAN-1995 - Temp. insert into pay_payroll_actions now also
23: populates date_earned with the virtual date
24: value.
25: mwcallag 10-JAN-1995 - New mandatory column 'object_version_number'
26: added to insert of pay_payroll_actions.
27: mwcallag 01-OCT-1993 - created.
28: */
29: procedure get_bal_ass_action
30: (

Line 39: l_pay_action_id pay_payroll_actions.payroll_action_id%type;

35: )is
36: l_payroll_id per_assignments_f.payroll_id%type;
37: l_consol_set_id pay_payrolls_f.payroll_id%type;
38: l_ass_action_id pay_assignment_actions.assignment_action_id%type;
39: l_pay_action_id pay_payroll_actions.payroll_action_id%type;
40: begin
41: --
42: -- get the payroll id and the consolidation set id
43: --

Line 61: select pay_payroll_actions_s.nextval

57: --
58: -- get the next value for payroll action id
59: --
60: hr_utility.set_location ('hrbaldtm.get_bal_ass_action', 2);
61: select pay_payroll_actions_s.nextval
62: into l_pay_action_id
63: from dual;
64: --
65: -- insert a temporary row into pay_payroll_actions

Line 65: -- insert a temporary row into pay_payroll_actions

61: select pay_payroll_actions_s.nextval
62: into l_pay_action_id
63: from dual;
64: --
65: -- insert a temporary row into pay_payroll_actions
66: --
67: hr_utility.set_location ('hrbaldtm.get_bal_ass_action', 3);
68: insert into pay_payroll_actions
69: (payroll_action_id,

Line 68: insert into pay_payroll_actions

64: --
65: -- insert a temporary row into pay_payroll_actions
66: --
67: hr_utility.set_location ('hrbaldtm.get_bal_ass_action', 3);
68: insert into pay_payroll_actions
69: (payroll_action_id,
70: action_type,
71: business_group_id,
72: consolidation_set_id,