[Home] [Help]
243: -- This function returns TRUE if the Element is the only Feed to its
244: -- Balance. Otherwise it returns FALSE. This is determined by executing
245: -- the cursor and if a row is returned, then it must be a single balance
246: -- feed, so return the necessary parameters required to call
247: -- hr_nzbal.calc_asg_ytd. Otherwise no records will be returned.
248: ------------------------------------------------------------------------
249: function single_feed_balance
250: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
251: p_assignment_id in pay_assignment_actions.assignment_id%type,
315:
316: ------------------------------------------------------------------------
317: -- Checks to see if the Balance is fed by a single Element by calling
318: -- single_balance_feed. If it is, then the Balance PTD function (in the
319: -- hr_nzbal package) is called. Otherwise, the Result PTD function in this
320: -- package is called.
321: ------------------------------------------------------------------------
322: function value_ptd
323: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
337: p_assignment_action_id,
338: p_balance_type_id,
339: p_effective_start_date) then
340:
341: v_value_ptd := hr_nzbal.calc_asg_ptd
342: (p_assignment_action_id, p_balance_type_id,
343: p_effective_start_date, p_assignment_id);
344: else
345: v_value_ptd := result_ptd (p_payroll_action_id,
352:
353: ------------------------------------------------------------------------
354: -- Checks to see if the Balance is fed by a single Element by calling
355: -- single_balance_feed. If it is, then the Balance YTD function (in the
356: -- hr_nzbal package) is called. Otherwise, the Result YTD function in this
357: -- package is called.
358: ------------------------------------------------------------------------
359: function value_ytd
360: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
374: p_assignment_action_id,
375: p_balance_type_id,
376: p_effective_start_date) then
377:
378: v_value_ytd := hr_nzbal.calc_asg_ytd
379: (p_assignment_action_id, p_balance_type_id,
380: p_effective_start_date, p_assignment_id);
381: else
382: v_value_ytd := result_ytd (p_payroll_action_id,