APPS.PAY_AU_REC_PKG dependencies on PAY_BALANCE_TYPES

Line 11: p_balance_name in pay_balance_types.balance_name%type,

7: procedure run_balances
8: (p_assignment_id in per_all_assignments_f.assignment_id%type,
9: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
10: p_effective_date in date,
11: p_balance_name in pay_balance_types.balance_name%type,
12: p_run_balance out NOCOPY number)
13: is
14:
15: cursor run_value

Line 19: c_balance_name pay_balance_types.balance_name%type) is

15: cursor run_value
16: (c_assignment_id pay_assignment_actions.assignment_id%type,
17: c_assignment_action_id pay_assignment_actions.assignment_action_id%type,
18: c_effective_date date,
19: c_balance_name pay_balance_types.balance_name%type) is
20: select nvl(hr_aubal.calc_asg_run(c_assignment_action_id,
21: balance_type_id,
22: c_effective_date,
23: c_assignment_id),0)

Line 24: from pay_balance_types

20: select nvl(hr_aubal.calc_asg_run(c_assignment_action_id,
21: balance_type_id,
22: c_effective_date,
23: c_assignment_id),0)
24: from pay_balance_types
25: where balance_name = c_balance_name
26: and legislation_code = 'AU';
27:
28: begin