DBA Data[Home] [Help]

APPS.PY_ZA_TX dependencies on PAY_BALANCE_PKG

Line 675: pay_balance_pkg.set_context ('ASSIGNMENT_ID', to_char(assignment_id));

671:
672: -- -- dbms_output.put_line('l_asg_end_date = '||to_char(l_asg_end_date)); -- GSCC Error: File.Sql.18
673: -- -- dbms_output.put_line('l_asg_end_date = '||to_char(l_asg_end_date)); -- GSCC Error: File.Sql.18
674:
675: pay_balance_pkg.set_context ('ASSIGNMENT_ID', to_char(assignment_id));
676:
677: l_dim_id := pay_za_payroll_action_pkg.defined_balance_id('Travelling Allowance','_ASG_TAX_YTD');
678:
679:

Line 689: ytd_bal_val := pay_balance_pkg.get_value(l_dim_id,assignment_id,v_date.effective_end_date);

685: )
686:
687: LOOP
688:
689: ytd_bal_val := pay_balance_pkg.get_value(l_dim_id,assignment_id,v_date.effective_end_date);
690: differ_bal_val := ytd_bal_val - bal_tot_val;
691:
692: bal_tot_val := ytd_bal_val;
693:

Line 700: ytd_bal_val := pay_balance_pkg.get_value(l_dim_id,assignment_id,l_max_end_date);

696: taxable_bal_val_tot := taxable_bal_val_tot + taxable_bal_val;
697:
698: END LOOP;
699:
700: ytd_bal_val := pay_balance_pkg.get_value(l_dim_id,assignment_id,l_max_end_date);
701: -- ytd_bal_val := pay_balance_pkg.get_value(l_dim_id,assignment_id,p_current_period_end_date);
702:
703: differ_bal_val := ytd_bal_val - bal_tot_val;
704:

Line 701: -- ytd_bal_val := pay_balance_pkg.get_value(l_dim_id,assignment_id,p_current_period_end_date);

697:
698: END LOOP;
699:
700: ytd_bal_val := pay_balance_pkg.get_value(l_dim_id,assignment_id,l_max_end_date);
701: -- ytd_bal_val := pay_balance_pkg.get_value(l_dim_id,assignment_id,p_current_period_end_date);
702:
703: differ_bal_val := ytd_bal_val - bal_tot_val;
704:
705: taxable_bal_val := differ_bal_val * (fnd_number.canonical_to_number(p_global_value) / 100);

Line 776: pay_balance_pkg.set_context ('ASSIGNMENT_ID', to_char(assignment_id));

772:
773:
774: l_min_start_date := GREATEST(l_asg_start_date, p_tax_year_start_date);
775:
776: pay_balance_pkg.set_context ('ASSIGNMENT_ID', to_char(assignment_id));
777:
778: l_dim_id := pay_za_payroll_action_pkg.defined_balance_id('Travelling Allowance','_ASG_CAL_YTD');
779:
780: -- Check that the newest of the Calendar Year Start Date and the Assignment Start Date

Line 797: ytd_bal_val := pay_balance_pkg.get_value(l_dim_id,assignment_id,v_date.effective_end_date);

793: )
794:
795: LOOP -- for every record that is returned. Total the actual taxable value
796:
797: ytd_bal_val := pay_balance_pkg.get_value(l_dim_id,assignment_id,v_date.effective_end_date);
798:
799: differ_bal_val := ytd_bal_val - bal_tot_val;
800:
801: bal_tot_val := ytd_bal_val;

Line 827: ytd_bal_val := pay_balance_pkg.get_value(l_dim_id,assignment_id,l_effec_date);

823: AND l_effec_date < glb.effective_end_date
824: AND global_name = 'ZA_CAR_ALLOW_TAX_PERC';
825:
826:
827: ytd_bal_val := pay_balance_pkg.get_value(l_dim_id,assignment_id,l_effec_date);
828:
829: differ_bal_val := ytd_bal_val - bal_tot_val;
830:
831: taxable_bal_val := differ_bal_val * (l_value_at_year_st / 100);