376: --
377: l_rec csr_info%ROWTYPE;
378: l_expiry_date DATE;
379: BEGIN
380: hr_utility.trace(' In p_owner_payroll_action_id => ' || p_owner_payroll_action_id );
381: hr_utility.trace(' In p_user_payroll_action_id => ' || p_user_payroll_action_id );
382: hr_utility.trace(' In p_owner_assignment_action_id => ' || p_owner_assignment_action_id);
383: hr_utility.trace(' In p_user_assignment_action_id => ' || p_user_assignment_action_id );
384: hr_utility.trace(' In p_owner_effective_date => ' || p_owner_effective_date);
377: l_rec csr_info%ROWTYPE;
378: l_expiry_date DATE;
379: BEGIN
380: hr_utility.trace(' In p_owner_payroll_action_id => ' || p_owner_payroll_action_id );
381: hr_utility.trace(' In p_user_payroll_action_id => ' || p_user_payroll_action_id );
382: hr_utility.trace(' In p_owner_assignment_action_id => ' || p_owner_assignment_action_id);
383: hr_utility.trace(' In p_user_assignment_action_id => ' || p_user_assignment_action_id );
384: hr_utility.trace(' In p_owner_effective_date => ' || p_owner_effective_date);
385: hr_utility.trace(' p_user_effective_date => ' || p_user_effective_date );
378: l_expiry_date DATE;
379: BEGIN
380: hr_utility.trace(' In p_owner_payroll_action_id => ' || p_owner_payroll_action_id );
381: hr_utility.trace(' In p_user_payroll_action_id => ' || p_user_payroll_action_id );
382: hr_utility.trace(' In p_owner_assignment_action_id => ' || p_owner_assignment_action_id);
383: hr_utility.trace(' In p_user_assignment_action_id => ' || p_user_assignment_action_id );
384: hr_utility.trace(' In p_owner_effective_date => ' || p_owner_effective_date);
385: hr_utility.trace(' p_user_effective_date => ' || p_user_effective_date );
386: hr_utility.trace(' In p_dimension_name => ' || p_dimension_name);
379: BEGIN
380: hr_utility.trace(' In p_owner_payroll_action_id => ' || p_owner_payroll_action_id );
381: hr_utility.trace(' In p_user_payroll_action_id => ' || p_user_payroll_action_id );
382: hr_utility.trace(' In p_owner_assignment_action_id => ' || p_owner_assignment_action_id);
383: hr_utility.trace(' In p_user_assignment_action_id => ' || p_user_assignment_action_id );
384: hr_utility.trace(' In p_owner_effective_date => ' || p_owner_effective_date);
385: hr_utility.trace(' p_user_effective_date => ' || p_user_effective_date );
386: hr_utility.trace(' In p_dimension_name => ' || p_dimension_name);
387:
380: hr_utility.trace(' In p_owner_payroll_action_id => ' || p_owner_payroll_action_id );
381: hr_utility.trace(' In p_user_payroll_action_id => ' || p_user_payroll_action_id );
382: hr_utility.trace(' In p_owner_assignment_action_id => ' || p_owner_assignment_action_id);
383: hr_utility.trace(' In p_user_assignment_action_id => ' || p_user_assignment_action_id );
384: hr_utility.trace(' In p_owner_effective_date => ' || p_owner_effective_date);
385: hr_utility.trace(' p_user_effective_date => ' || p_user_effective_date );
386: hr_utility.trace(' In p_dimension_name => ' || p_dimension_name);
387:
388: --
381: hr_utility.trace(' In p_user_payroll_action_id => ' || p_user_payroll_action_id );
382: hr_utility.trace(' In p_owner_assignment_action_id => ' || p_owner_assignment_action_id);
383: hr_utility.trace(' In p_user_assignment_action_id => ' || p_user_assignment_action_id );
384: hr_utility.trace(' In p_owner_effective_date => ' || p_owner_effective_date);
385: hr_utility.trace(' p_user_effective_date => ' || p_user_effective_date );
386: hr_utility.trace(' In p_dimension_name => ' || p_dimension_name);
387:
388: --
389: --
382: hr_utility.trace(' In p_owner_assignment_action_id => ' || p_owner_assignment_action_id);
383: hr_utility.trace(' In p_user_assignment_action_id => ' || p_user_assignment_action_id );
384: hr_utility.trace(' In p_owner_effective_date => ' || p_owner_effective_date);
385: hr_utility.trace(' p_user_effective_date => ' || p_user_effective_date );
386: hr_utility.trace(' In p_dimension_name => ' || p_dimension_name);
387:
388: --
389: --
390: -- Find the business group and also the period type of the balance dimension.
400:
401: l_expiry_date := hyear_ec(p_owner_effective_date);
402: --
403: END IF;
404: hr_utility.trace(' l_expiry_date => ' || l_expiry_date );
405: --
406: --
407: -- See if the current effective date is within the same span of time as the
408: -- balance's effective date. If yes then it is OK to use cached balance
461: BEGIN
462:
463: --
464: --
465: hr_utility.trace(' In p_owner_payroll_action_id => ' || p_owner_payroll_action_id );
466: hr_utility.trace(' In p_user_payroll_action_id => ' || p_user_payroll_action_id );
467: hr_utility.trace(' In p_owner_assignment_action_id => ' || p_owner_assignment_action_id);
468: hr_utility.trace(' In p_user_assignment_action_id => ' || p_user_assignment_action_id );
469: hr_utility.trace(' In p_owner_effective_date => ' || p_owner_effective_date);
462:
463: --
464: --
465: hr_utility.trace(' In p_owner_payroll_action_id => ' || p_owner_payroll_action_id );
466: hr_utility.trace(' In p_user_payroll_action_id => ' || p_user_payroll_action_id );
467: hr_utility.trace(' In p_owner_assignment_action_id => ' || p_owner_assignment_action_id);
468: hr_utility.trace(' In p_user_assignment_action_id => ' || p_user_assignment_action_id );
469: hr_utility.trace(' In p_owner_effective_date => ' || p_owner_effective_date);
470: hr_utility.trace(' p_user_effective_date => ' || p_user_effective_date );
463: --
464: --
465: hr_utility.trace(' In p_owner_payroll_action_id => ' || p_owner_payroll_action_id );
466: hr_utility.trace(' In p_user_payroll_action_id => ' || p_user_payroll_action_id );
467: hr_utility.trace(' In p_owner_assignment_action_id => ' || p_owner_assignment_action_id);
468: hr_utility.trace(' In p_user_assignment_action_id => ' || p_user_assignment_action_id );
469: hr_utility.trace(' In p_owner_effective_date => ' || p_owner_effective_date);
470: hr_utility.trace(' p_user_effective_date => ' || p_user_effective_date );
471: hr_utility.trace(' In p_dimension_name => ' || p_dimension_name);
464: --
465: hr_utility.trace(' In p_owner_payroll_action_id => ' || p_owner_payroll_action_id );
466: hr_utility.trace(' In p_user_payroll_action_id => ' || p_user_payroll_action_id );
467: hr_utility.trace(' In p_owner_assignment_action_id => ' || p_owner_assignment_action_id);
468: hr_utility.trace(' In p_user_assignment_action_id => ' || p_user_assignment_action_id );
469: hr_utility.trace(' In p_owner_effective_date => ' || p_owner_effective_date);
470: hr_utility.trace(' p_user_effective_date => ' || p_user_effective_date );
471: hr_utility.trace(' In p_dimension_name => ' || p_dimension_name);
472:
465: hr_utility.trace(' In p_owner_payroll_action_id => ' || p_owner_payroll_action_id );
466: hr_utility.trace(' In p_user_payroll_action_id => ' || p_user_payroll_action_id );
467: hr_utility.trace(' In p_owner_assignment_action_id => ' || p_owner_assignment_action_id);
468: hr_utility.trace(' In p_user_assignment_action_id => ' || p_user_assignment_action_id );
469: hr_utility.trace(' In p_owner_effective_date => ' || p_owner_effective_date);
470: hr_utility.trace(' p_user_effective_date => ' || p_user_effective_date );
471: hr_utility.trace(' In p_dimension_name => ' || p_dimension_name);
472:
473: -- Find the business group and also the period type of the balance dimension.
466: hr_utility.trace(' In p_user_payroll_action_id => ' || p_user_payroll_action_id );
467: hr_utility.trace(' In p_owner_assignment_action_id => ' || p_owner_assignment_action_id);
468: hr_utility.trace(' In p_user_assignment_action_id => ' || p_user_assignment_action_id );
469: hr_utility.trace(' In p_owner_effective_date => ' || p_owner_effective_date);
470: hr_utility.trace(' p_user_effective_date => ' || p_user_effective_date );
471: hr_utility.trace(' In p_dimension_name => ' || p_dimension_name);
472:
473: -- Find the business group and also the period type of the balance dimension.
474: --
467: hr_utility.trace(' In p_owner_assignment_action_id => ' || p_owner_assignment_action_id);
468: hr_utility.trace(' In p_user_assignment_action_id => ' || p_user_assignment_action_id );
469: hr_utility.trace(' In p_owner_effective_date => ' || p_owner_effective_date);
470: hr_utility.trace(' p_user_effective_date => ' || p_user_effective_date );
471: hr_utility.trace(' In p_dimension_name => ' || p_dimension_name);
472:
473: -- Find the business group and also the period type of the balance dimension.
474: --
475: OPEN csr_info(p_owner_payroll_action_id, p_dimension_name);
493:
494: END IF;
495:
496:
497: hr_utility.trace(' p_expiry_information => ' || p_expiry_information);
498: --
499: --
500: -- See if the current effective date is within the same span of time as the
501: -- balance's effective date. If yes then it is OK to use cached balance