APPS.PAY_US_SQWL_UDF dependencies on PAY_BALANCE_PKG

Line 737: l_total_state_taxable := pay_balance_pkg.get_value( l_defined_balance_id,

733: CLOSE get_defined_balance_id;
734:
735: l_total_state_taxable := 0;
736:
737: l_total_state_taxable := pay_balance_pkg.get_value( l_defined_balance_id,
738: p_assignment_id,
739: l_reporting_date);
740:
741: hr_utility.trace('Total SUI Taxable till this Quarter'||l_total_state_taxable);

Line 755: pay_balance_pkg.set_context('JURISDICTION_CODE',fl_jurisdiction_code);

751: END IF;
752:
753: CLOSE get_defined_balance_id;
754:
755: pay_balance_pkg.set_context('JURISDICTION_CODE',fl_jurisdiction_code);
756:
757: l_total_out_of_state_taxable := 0;
758:
759: l_total_out_of_state_taxable := l_total_state_taxable -

Line 760: pay_balance_pkg.get_value( l_defined_balance_id,

756:
757: l_total_out_of_state_taxable := 0;
758:
759: l_total_out_of_state_taxable := l_total_state_taxable -
760: pay_balance_pkg.get_value( l_defined_balance_id,
761: p_assignment_id,
762: l_reporting_date);
763:
764: hr_utility.trace('Total Out of State SUI Taxable till this Quarter'||l_total_out_of_state_taxable);

Line 792: pay_balance_pkg.set_context('JURISDICTION_CODE',l_state_code||'-000-0000');

788: THEN
789:
790: l_state_earnings := 0;
791:
792: pay_balance_pkg.set_context('JURISDICTION_CODE',l_state_code||'-000-0000');
793:
794: l_state_earnings := pay_balance_pkg.get_value( l_defined_balance_id,
795: p_assignment_id,
796: l_reporting_date);

Line 794: l_state_earnings := pay_balance_pkg.get_value( l_defined_balance_id,

790: l_state_earnings := 0;
791:
792: pay_balance_pkg.set_context('JURISDICTION_CODE',l_state_code||'-000-0000');
793:
794: l_state_earnings := pay_balance_pkg.get_value( l_defined_balance_id,
795: p_assignment_id,
796: l_reporting_date);
797:
798: l_out_of_state_taxable := l_out_of_state_taxable + l_state_earnings;

Line 843: pay_balance_pkg.set_context('JURISDICTION_CODE',l_state_code||'-000-0000');

839: THEN
840:
841: l_state_earnings := 0;
842:
843: pay_balance_pkg.set_context('JURISDICTION_CODE',l_state_code||'-000-0000');
844:
845: l_state_earnings := pay_balance_pkg.get_value( l_defined_balance_id,
846: p_assignment_id,
847: l_reporting_date);

Line 845: l_state_earnings := pay_balance_pkg.get_value( l_defined_balance_id,

841: l_state_earnings := 0;
842:
843: pay_balance_pkg.set_context('JURISDICTION_CODE',l_state_code||'-000-0000');
844:
845: l_state_earnings := pay_balance_pkg.get_value( l_defined_balance_id,
846: p_assignment_id,
847: l_reporting_date);
848:
849: l_out_of_state_taxable := l_out_of_state_taxable + l_state_earnings;