DBA Data[Home] [Help]

APPS.PAY_NL_EOY_PKG dependencies on PAY_NL_GENERAL

Line 196: l_hol_allow_perc:=fnd_number.canonical_to_number(pay_nl_general.get_global_value(

192:
193:
194: /* Get the value of Global NL_TAX_HOLIDAY_ALLOWANCE_PERCENTAGE */
195:
196: l_hol_allow_perc:=fnd_number.canonical_to_number(pay_nl_general.get_global_value(
197: l_date_earned =>p_effective_date,
198: l_global_name =>'NL_TAX_HOLIDAY_ALLOWANCE_PERCENTAGE'));
199:
200: --if g_debug then

Line 661: l_type := pay_nl_general.check_de_dp_dimension(p_payroll_action_id

657: OPEN get_ass_act_id(l_assignment.assignment_id,l_current_period_start_date,l_current_period_end_date);
658: FETCH get_ass_act_id INTO l_ass_act_id;
659: CLOSE get_ass_act_id;
660: --
661: l_type := pay_nl_general.check_de_dp_dimension(p_payroll_action_id
662: ,l_assignment.assignment_id
663: ,l_ass_act_id);
664: --
665:

Line 668: l_spl_rate_income_dbaid_ptd:=pay_nl_general.get_defined_balance_id('SPECIAL_RATE_INCOME_ASG_BDATE_PTD');

664: --
665:
666: hr_utility.trace('~~VV l_type : '||l_type);
667: IF l_type = 'DE' THEN
668: l_spl_rate_income_dbaid_ptd:=pay_nl_general.get_defined_balance_id('SPECIAL_RATE_INCOME_ASG_BDATE_PTD');
669: IF l_ass_act_id is NOT NULL THEN
670: l_special_rate_income_ptd :=pay_balance_pkg.get_value(p_defined_balance_id=> l_spl_rate_income_dbaid_ptd
671: ,p_assignment_action_id => l_ass_act_id
672: ,p_tax_unit_id => NULL

Line 689: l_spl_rate_income_dbaid_ptd:=pay_nl_general.get_defined_balance_id('SPECIAL_RATE_INCOME_ASG_PTD');

685: ELSE
686: l_special_rate_income_ptd := 0;
687: END IF;
688: ELSE
689: l_spl_rate_income_dbaid_ptd:=pay_nl_general.get_defined_balance_id('SPECIAL_RATE_INCOME_ASG_PTD');
690: IF l_ass_act_id is NOT NULL THEN
691: pay_balance_pkg.set_context('BALANCE_DATE',NULL);
692: l_special_rate_income_ptd :=pay_balance_pkg.get_value(p_defined_balance_id=> l_spl_rate_income_dbaid_ptd
693: ,p_assignment_action_id => l_ass_act_id

Line 702: l_spl_rate_income_dbaid_ptd:=pay_nl_general.get_defined_balance_id('SPECIAL_RATE_INCOME_ASG_PTD');

698: END IF;
699: END IF;
700: ELSE
701: hr_utility.trace('~~VV 2');
702: l_spl_rate_income_dbaid_ptd:=pay_nl_general.get_defined_balance_id('SPECIAL_RATE_INCOME_ASG_PTD');
703: l_special_rate_income_ptd :=pay_balance_pkg.get_value(l_spl_rate_income_dbaid_ptd
704: ,l_assignment.assignment_id,l_current_period_end_date);
705: END IF;
706: --

Line 806: l_std_tax_dbalid :=pay_nl_general.get_defined_balance_id('STANDARD_TAXABLE_INCOME_ASG_YTD');

802:
803: Begin
804:
805: --Get the Defined Balance Id's of the required balances
806: l_std_tax_dbalid :=pay_nl_general.get_defined_balance_id('STANDARD_TAXABLE_INCOME_ASG_YTD');
807: l_spl_tax_dbalid :=pay_nl_general.get_defined_balance_id('SPECIAL_TAXABLE_INCOME_ASG_YTD');
808: l_retrostd_tax_dbalid :=pay_nl_general.get_defined_balance_id('RETRO_STANDARD_TAXABLE_INCOME_ASG_YTD');
809: l_retrostdcurrq_tax_dbalid :=pay_nl_general.get_defined_balance_id('RETRO_STANDARD_TAXABLE_INCOME_CURRENT_QUARTER_ASG_YTD');
810: l_retrospl_tax_dbalid :=pay_nl_general.get_defined_balance_id('RETRO_SPECIAL_TAXABLE_INCOME_ASG_YTD');

Line 807: l_spl_tax_dbalid :=pay_nl_general.get_defined_balance_id('SPECIAL_TAXABLE_INCOME_ASG_YTD');

803: Begin
804:
805: --Get the Defined Balance Id's of the required balances
806: l_std_tax_dbalid :=pay_nl_general.get_defined_balance_id('STANDARD_TAXABLE_INCOME_ASG_YTD');
807: l_spl_tax_dbalid :=pay_nl_general.get_defined_balance_id('SPECIAL_TAXABLE_INCOME_ASG_YTD');
808: l_retrostd_tax_dbalid :=pay_nl_general.get_defined_balance_id('RETRO_STANDARD_TAXABLE_INCOME_ASG_YTD');
809: l_retrostdcurrq_tax_dbalid :=pay_nl_general.get_defined_balance_id('RETRO_STANDARD_TAXABLE_INCOME_CURRENT_QUARTER_ASG_YTD');
810: l_retrospl_tax_dbalid :=pay_nl_general.get_defined_balance_id('RETRO_SPECIAL_TAXABLE_INCOME_ASG_YTD');
811:

Line 808: l_retrostd_tax_dbalid :=pay_nl_general.get_defined_balance_id('RETRO_STANDARD_TAXABLE_INCOME_ASG_YTD');

804:
805: --Get the Defined Balance Id's of the required balances
806: l_std_tax_dbalid :=pay_nl_general.get_defined_balance_id('STANDARD_TAXABLE_INCOME_ASG_YTD');
807: l_spl_tax_dbalid :=pay_nl_general.get_defined_balance_id('SPECIAL_TAXABLE_INCOME_ASG_YTD');
808: l_retrostd_tax_dbalid :=pay_nl_general.get_defined_balance_id('RETRO_STANDARD_TAXABLE_INCOME_ASG_YTD');
809: l_retrostdcurrq_tax_dbalid :=pay_nl_general.get_defined_balance_id('RETRO_STANDARD_TAXABLE_INCOME_CURRENT_QUARTER_ASG_YTD');
810: l_retrospl_tax_dbalid :=pay_nl_general.get_defined_balance_id('RETRO_SPECIAL_TAXABLE_INCOME_ASG_YTD');
811:
812: l_hol_allow_pay_dbalid :=pay_nl_general.get_defined_balance_id('HOLIDAY_ALLOWANCE_PAYMENT_ASG_YTD');

Line 809: l_retrostdcurrq_tax_dbalid :=pay_nl_general.get_defined_balance_id('RETRO_STANDARD_TAXABLE_INCOME_CURRENT_QUARTER_ASG_YTD');

805: --Get the Defined Balance Id's of the required balances
806: l_std_tax_dbalid :=pay_nl_general.get_defined_balance_id('STANDARD_TAXABLE_INCOME_ASG_YTD');
807: l_spl_tax_dbalid :=pay_nl_general.get_defined_balance_id('SPECIAL_TAXABLE_INCOME_ASG_YTD');
808: l_retrostd_tax_dbalid :=pay_nl_general.get_defined_balance_id('RETRO_STANDARD_TAXABLE_INCOME_ASG_YTD');
809: l_retrostdcurrq_tax_dbalid :=pay_nl_general.get_defined_balance_id('RETRO_STANDARD_TAXABLE_INCOME_CURRENT_QUARTER_ASG_YTD');
810: l_retrospl_tax_dbalid :=pay_nl_general.get_defined_balance_id('RETRO_SPECIAL_TAXABLE_INCOME_ASG_YTD');
811:
812: l_hol_allow_pay_dbalid :=pay_nl_general.get_defined_balance_id('HOLIDAY_ALLOWANCE_PAYMENT_ASG_YTD');
813: l_hol_allow_tax_dbalid :=pay_nl_general.get_defined_balance_id('HOLIDAY_ALLOWANCE_TAXABLE_INCOME_ASG_YTD');

Line 810: l_retrospl_tax_dbalid :=pay_nl_general.get_defined_balance_id('RETRO_SPECIAL_TAXABLE_INCOME_ASG_YTD');

806: l_std_tax_dbalid :=pay_nl_general.get_defined_balance_id('STANDARD_TAXABLE_INCOME_ASG_YTD');
807: l_spl_tax_dbalid :=pay_nl_general.get_defined_balance_id('SPECIAL_TAXABLE_INCOME_ASG_YTD');
808: l_retrostd_tax_dbalid :=pay_nl_general.get_defined_balance_id('RETRO_STANDARD_TAXABLE_INCOME_ASG_YTD');
809: l_retrostdcurrq_tax_dbalid :=pay_nl_general.get_defined_balance_id('RETRO_STANDARD_TAXABLE_INCOME_CURRENT_QUARTER_ASG_YTD');
810: l_retrospl_tax_dbalid :=pay_nl_general.get_defined_balance_id('RETRO_SPECIAL_TAXABLE_INCOME_ASG_YTD');
811:
812: l_hol_allow_pay_dbalid :=pay_nl_general.get_defined_balance_id('HOLIDAY_ALLOWANCE_PAYMENT_ASG_YTD');
813: l_hol_allow_tax_dbalid :=pay_nl_general.get_defined_balance_id('HOLIDAY_ALLOWANCE_TAXABLE_INCOME_ASG_YTD');
814: l_retrohol_allow_tax_dbalid :=pay_nl_general.get_defined_balance_id('RETRO_HOLIDAY_ALLOWANCE_TAXABLE_INCOME_ASG_YTD');

Line 812: l_hol_allow_pay_dbalid :=pay_nl_general.get_defined_balance_id('HOLIDAY_ALLOWANCE_PAYMENT_ASG_YTD');

808: l_retrostd_tax_dbalid :=pay_nl_general.get_defined_balance_id('RETRO_STANDARD_TAXABLE_INCOME_ASG_YTD');
809: l_retrostdcurrq_tax_dbalid :=pay_nl_general.get_defined_balance_id('RETRO_STANDARD_TAXABLE_INCOME_CURRENT_QUARTER_ASG_YTD');
810: l_retrospl_tax_dbalid :=pay_nl_general.get_defined_balance_id('RETRO_SPECIAL_TAXABLE_INCOME_ASG_YTD');
811:
812: l_hol_allow_pay_dbalid :=pay_nl_general.get_defined_balance_id('HOLIDAY_ALLOWANCE_PAYMENT_ASG_YTD');
813: l_hol_allow_tax_dbalid :=pay_nl_general.get_defined_balance_id('HOLIDAY_ALLOWANCE_TAXABLE_INCOME_ASG_YTD');
814: l_retrohol_allow_tax_dbalid :=pay_nl_general.get_defined_balance_id('RETRO_HOLIDAY_ALLOWANCE_TAXABLE_INCOME_ASG_YTD');
815:
816:

Line 813: l_hol_allow_tax_dbalid :=pay_nl_general.get_defined_balance_id('HOLIDAY_ALLOWANCE_TAXABLE_INCOME_ASG_YTD');

809: l_retrostdcurrq_tax_dbalid :=pay_nl_general.get_defined_balance_id('RETRO_STANDARD_TAXABLE_INCOME_CURRENT_QUARTER_ASG_YTD');
810: l_retrospl_tax_dbalid :=pay_nl_general.get_defined_balance_id('RETRO_SPECIAL_TAXABLE_INCOME_ASG_YTD');
811:
812: l_hol_allow_pay_dbalid :=pay_nl_general.get_defined_balance_id('HOLIDAY_ALLOWANCE_PAYMENT_ASG_YTD');
813: l_hol_allow_tax_dbalid :=pay_nl_general.get_defined_balance_id('HOLIDAY_ALLOWANCE_TAXABLE_INCOME_ASG_YTD');
814: l_retrohol_allow_tax_dbalid :=pay_nl_general.get_defined_balance_id('RETRO_HOLIDAY_ALLOWANCE_TAXABLE_INCOME_ASG_YTD');
815:
816:
817: l_std_tax_dbalid_ptd :=pay_nl_general.get_defined_balance_id('STANDARD_TAXABLE_INCOME_ASG_PTD');

Line 814: l_retrohol_allow_tax_dbalid :=pay_nl_general.get_defined_balance_id('RETRO_HOLIDAY_ALLOWANCE_TAXABLE_INCOME_ASG_YTD');

810: l_retrospl_tax_dbalid :=pay_nl_general.get_defined_balance_id('RETRO_SPECIAL_TAXABLE_INCOME_ASG_YTD');
811:
812: l_hol_allow_pay_dbalid :=pay_nl_general.get_defined_balance_id('HOLIDAY_ALLOWANCE_PAYMENT_ASG_YTD');
813: l_hol_allow_tax_dbalid :=pay_nl_general.get_defined_balance_id('HOLIDAY_ALLOWANCE_TAXABLE_INCOME_ASG_YTD');
814: l_retrohol_allow_tax_dbalid :=pay_nl_general.get_defined_balance_id('RETRO_HOLIDAY_ALLOWANCE_TAXABLE_INCOME_ASG_YTD');
815:
816:
817: l_std_tax_dbalid_ptd :=pay_nl_general.get_defined_balance_id('STANDARD_TAXABLE_INCOME_ASG_PTD');
818: l_spl_tax_dbalid_ptd :=pay_nl_general.get_defined_balance_id('SPECIAL_TAXABLE_INCOME_ASG_PTD');

Line 817: l_std_tax_dbalid_ptd :=pay_nl_general.get_defined_balance_id('STANDARD_TAXABLE_INCOME_ASG_PTD');

813: l_hol_allow_tax_dbalid :=pay_nl_general.get_defined_balance_id('HOLIDAY_ALLOWANCE_TAXABLE_INCOME_ASG_YTD');
814: l_retrohol_allow_tax_dbalid :=pay_nl_general.get_defined_balance_id('RETRO_HOLIDAY_ALLOWANCE_TAXABLE_INCOME_ASG_YTD');
815:
816:
817: l_std_tax_dbalid_ptd :=pay_nl_general.get_defined_balance_id('STANDARD_TAXABLE_INCOME_ASG_PTD');
818: l_spl_tax_dbalid_ptd :=pay_nl_general.get_defined_balance_id('SPECIAL_TAXABLE_INCOME_ASG_PTD');
819: l_retrostd_tax_dbalid_ptd :=pay_nl_general.get_defined_balance_id('RETRO_STANDARD_TAXABLE_INCOME_ASG_PTD');
820: l_retrostdcurrq_tax_dbalid_ptd :=pay_nl_general.get_defined_balance_id('RETRO_STANDARD_TAXABLE_INCOME_CURRENT_QUARTER_ASG_PTD');
821: l_retrospl_tax_dbalid_ptd :=pay_nl_general.get_defined_balance_id('RETRO_SPECIAL_TAXABLE_INCOME_ASG_PTD');

Line 818: l_spl_tax_dbalid_ptd :=pay_nl_general.get_defined_balance_id('SPECIAL_TAXABLE_INCOME_ASG_PTD');

814: l_retrohol_allow_tax_dbalid :=pay_nl_general.get_defined_balance_id('RETRO_HOLIDAY_ALLOWANCE_TAXABLE_INCOME_ASG_YTD');
815:
816:
817: l_std_tax_dbalid_ptd :=pay_nl_general.get_defined_balance_id('STANDARD_TAXABLE_INCOME_ASG_PTD');
818: l_spl_tax_dbalid_ptd :=pay_nl_general.get_defined_balance_id('SPECIAL_TAXABLE_INCOME_ASG_PTD');
819: l_retrostd_tax_dbalid_ptd :=pay_nl_general.get_defined_balance_id('RETRO_STANDARD_TAXABLE_INCOME_ASG_PTD');
820: l_retrostdcurrq_tax_dbalid_ptd :=pay_nl_general.get_defined_balance_id('RETRO_STANDARD_TAXABLE_INCOME_CURRENT_QUARTER_ASG_PTD');
821: l_retrospl_tax_dbalid_ptd :=pay_nl_general.get_defined_balance_id('RETRO_SPECIAL_TAXABLE_INCOME_ASG_PTD');
822:

Line 819: l_retrostd_tax_dbalid_ptd :=pay_nl_general.get_defined_balance_id('RETRO_STANDARD_TAXABLE_INCOME_ASG_PTD');

815:
816:
817: l_std_tax_dbalid_ptd :=pay_nl_general.get_defined_balance_id('STANDARD_TAXABLE_INCOME_ASG_PTD');
818: l_spl_tax_dbalid_ptd :=pay_nl_general.get_defined_balance_id('SPECIAL_TAXABLE_INCOME_ASG_PTD');
819: l_retrostd_tax_dbalid_ptd :=pay_nl_general.get_defined_balance_id('RETRO_STANDARD_TAXABLE_INCOME_ASG_PTD');
820: l_retrostdcurrq_tax_dbalid_ptd :=pay_nl_general.get_defined_balance_id('RETRO_STANDARD_TAXABLE_INCOME_CURRENT_QUARTER_ASG_PTD');
821: l_retrospl_tax_dbalid_ptd :=pay_nl_general.get_defined_balance_id('RETRO_SPECIAL_TAXABLE_INCOME_ASG_PTD');
822:
823:

Line 820: l_retrostdcurrq_tax_dbalid_ptd :=pay_nl_general.get_defined_balance_id('RETRO_STANDARD_TAXABLE_INCOME_CURRENT_QUARTER_ASG_PTD');

816:
817: l_std_tax_dbalid_ptd :=pay_nl_general.get_defined_balance_id('STANDARD_TAXABLE_INCOME_ASG_PTD');
818: l_spl_tax_dbalid_ptd :=pay_nl_general.get_defined_balance_id('SPECIAL_TAXABLE_INCOME_ASG_PTD');
819: l_retrostd_tax_dbalid_ptd :=pay_nl_general.get_defined_balance_id('RETRO_STANDARD_TAXABLE_INCOME_ASG_PTD');
820: l_retrostdcurrq_tax_dbalid_ptd :=pay_nl_general.get_defined_balance_id('RETRO_STANDARD_TAXABLE_INCOME_CURRENT_QUARTER_ASG_PTD');
821: l_retrospl_tax_dbalid_ptd :=pay_nl_general.get_defined_balance_id('RETRO_SPECIAL_TAXABLE_INCOME_ASG_PTD');
822:
823:
824: l_hol_allow_pay_dbalid_ptd :=pay_nl_general.get_defined_balance_id('HOLIDAY_ALLOWANCE_PAYMENT_ASG_PTD');

Line 821: l_retrospl_tax_dbalid_ptd :=pay_nl_general.get_defined_balance_id('RETRO_SPECIAL_TAXABLE_INCOME_ASG_PTD');

817: l_std_tax_dbalid_ptd :=pay_nl_general.get_defined_balance_id('STANDARD_TAXABLE_INCOME_ASG_PTD');
818: l_spl_tax_dbalid_ptd :=pay_nl_general.get_defined_balance_id('SPECIAL_TAXABLE_INCOME_ASG_PTD');
819: l_retrostd_tax_dbalid_ptd :=pay_nl_general.get_defined_balance_id('RETRO_STANDARD_TAXABLE_INCOME_ASG_PTD');
820: l_retrostdcurrq_tax_dbalid_ptd :=pay_nl_general.get_defined_balance_id('RETRO_STANDARD_TAXABLE_INCOME_CURRENT_QUARTER_ASG_PTD');
821: l_retrospl_tax_dbalid_ptd :=pay_nl_general.get_defined_balance_id('RETRO_SPECIAL_TAXABLE_INCOME_ASG_PTD');
822:
823:
824: l_hol_allow_pay_dbalid_ptd :=pay_nl_general.get_defined_balance_id('HOLIDAY_ALLOWANCE_PAYMENT_ASG_PTD');
825: l_hol_allow_tax_dbalid_ptd :=pay_nl_general.get_defined_balance_id('HOLIDAY_ALLOWANCE_TAXABLE_INCOME_ASG_PTD');

Line 824: l_hol_allow_pay_dbalid_ptd :=pay_nl_general.get_defined_balance_id('HOLIDAY_ALLOWANCE_PAYMENT_ASG_PTD');

820: l_retrostdcurrq_tax_dbalid_ptd :=pay_nl_general.get_defined_balance_id('RETRO_STANDARD_TAXABLE_INCOME_CURRENT_QUARTER_ASG_PTD');
821: l_retrospl_tax_dbalid_ptd :=pay_nl_general.get_defined_balance_id('RETRO_SPECIAL_TAXABLE_INCOME_ASG_PTD');
822:
823:
824: l_hol_allow_pay_dbalid_ptd :=pay_nl_general.get_defined_balance_id('HOLIDAY_ALLOWANCE_PAYMENT_ASG_PTD');
825: l_hol_allow_tax_dbalid_ptd :=pay_nl_general.get_defined_balance_id('HOLIDAY_ALLOWANCE_TAXABLE_INCOME_ASG_PTD');
826: l_retrohol_allow_dbalid_ptd :=pay_nl_general.get_defined_balance_id('RETRO_HOLIDAY_ALLOWANCE_TAXABLE_INCOME_ASG_PTD');
827:
828:

Line 825: l_hol_allow_tax_dbalid_ptd :=pay_nl_general.get_defined_balance_id('HOLIDAY_ALLOWANCE_TAXABLE_INCOME_ASG_PTD');

821: l_retrospl_tax_dbalid_ptd :=pay_nl_general.get_defined_balance_id('RETRO_SPECIAL_TAXABLE_INCOME_ASG_PTD');
822:
823:
824: l_hol_allow_pay_dbalid_ptd :=pay_nl_general.get_defined_balance_id('HOLIDAY_ALLOWANCE_PAYMENT_ASG_PTD');
825: l_hol_allow_tax_dbalid_ptd :=pay_nl_general.get_defined_balance_id('HOLIDAY_ALLOWANCE_TAXABLE_INCOME_ASG_PTD');
826: l_retrohol_allow_dbalid_ptd :=pay_nl_general.get_defined_balance_id('RETRO_HOLIDAY_ALLOWANCE_TAXABLE_INCOME_ASG_PTD');
827:
828:
829: --if g_debug then

Line 826: l_retrohol_allow_dbalid_ptd :=pay_nl_general.get_defined_balance_id('RETRO_HOLIDAY_ALLOWANCE_TAXABLE_INCOME_ASG_PTD');

822:
823:
824: l_hol_allow_pay_dbalid_ptd :=pay_nl_general.get_defined_balance_id('HOLIDAY_ALLOWANCE_PAYMENT_ASG_PTD');
825: l_hol_allow_tax_dbalid_ptd :=pay_nl_general.get_defined_balance_id('HOLIDAY_ALLOWANCE_TAXABLE_INCOME_ASG_PTD');
826: l_retrohol_allow_dbalid_ptd :=pay_nl_general.get_defined_balance_id('RETRO_HOLIDAY_ALLOWANCE_TAXABLE_INCOME_ASG_PTD');
827:
828:
829: --if g_debug then
830: hr_utility.set_location('Inside get_balance_values: l_std_tax_dbalid'||l_std_tax_dbalid,2510);