DBA Data[Home] [Help]

APPS.PAY_NZ_SOE_PKG dependencies on PAY_BALANCE_TYPES

Line 455: p_balance_name in pay_balance_types.balance_name%type,

451: procedure run_and_ytd_balances
452: (p_assignment_id in per_all_assignments_f.assignment_id%type,
453: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
454: p_effective_date in date,
455: p_balance_name in pay_balance_types.balance_name%type,
456: p_run_balance out nocopy number,
457: p_ytd_balance out nocopy number)
458: is
459:

Line 464: c_balance_name pay_balance_types.balance_name%type) is

460: cursor run_and_ytd_value
461: (c_assignment_id pay_assignment_actions.assignment_id%type,
462: c_assignment_action_id pay_assignment_actions.assignment_action_id%type,
463: c_effective_date date,
464: c_balance_name pay_balance_types.balance_name%type) is
465: select nvl(hr_nzbal.calc_asg_run(c_assignment_action_id,
466: balance_type_id,
467: c_effective_date,
468: c_assignment_id),0),

Line 473: from pay_balance_types

469: nvl(hr_nzbal.calc_asg_ytd(c_assignment_action_id,
470: balance_type_id,
471: c_effective_date,
472: c_assignment_id),0)
473: from pay_balance_types
474: where balance_name = c_balance_name
475: -- Modified the condition for bug 6083911
476: and legislation_code = 'NZ';
477: