DBA Data[Home] [Help]

APPS.PAY_NL_EOY_PKG dependencies on STANDARD

Line 391: /* Set previous year's taxable income for this assignment to be the sum of balances Standard Taxable Income

387: IF (l_asg_start_date <= l_prev_year_start_date and l_asg_end_date >= l_prev_year_end_date )
388: or (l_asg_end_date < l_prev_year_end_date and TO_CHAR(l_asg_end_date,'YYYY') = TO_CHAR(l_prev_year_end_date,'YYYY') )THEN
389:
390:
391: /* Set previous year's taxable income for this assignment to be the sum of balances Standard Taxable Income
392: Special Taxable Income, Retro Standard Taxable Income, Retro Standard Taxable Income Current Quarter
393: and Retro Special Taxable Income for the whole of the previous year */
394:
395: l_prev_year_income:= l_std_tax_income + l_spl_tax_income + l_retrostd_tax_income +

Line 392: Special Taxable Income, Retro Standard Taxable Income, Retro Standard Taxable Income Current Quarter

388: or (l_asg_end_date < l_prev_year_end_date and TO_CHAR(l_asg_end_date,'YYYY') = TO_CHAR(l_prev_year_end_date,'YYYY') )THEN
389:
390:
391: /* Set previous year's taxable income for this assignment to be the sum of balances Standard Taxable Income
392: Special Taxable Income, Retro Standard Taxable Income, Retro Standard Taxable Income Current Quarter
393: and Retro Special Taxable Income for the whole of the previous year */
394:
395: l_prev_year_income:= l_std_tax_income + l_spl_tax_income + l_retrostd_tax_income +
396: l_retrostdcurrq_tax_income + l_retrospl_tax_income;

Line 412: /* Add together the values of balances Standard Taxable Income, Special Taxable

408:
409: --if g_debug then
410: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_prev_year_income'||l_prev_year_income,2900);
411: --end if;
412: /* Add together the values of balances Standard Taxable Income, Special Taxable
413: Income, Retro Standard Taxable Income, Retro Standard Taxable Income
414: Current Quarter and Retro Special Taxable Income for the previous year.*/
415:
416: l_prev_year_income:= l_std_tax_income + l_spl_tax_income + l_retrostd_tax_income +

Line 413: Income, Retro Standard Taxable Income, Retro Standard Taxable Income

409: --if g_debug then
410: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_prev_year_income'||l_prev_year_income,2900);
411: --end if;
412: /* Add together the values of balances Standard Taxable Income, Special Taxable
413: Income, Retro Standard Taxable Income, Retro Standard Taxable Income
414: Current Quarter and Retro Special Taxable Income for the previous year.*/
415:
416: l_prev_year_income:= l_std_tax_income + l_spl_tax_income + l_retrostd_tax_income +
417: l_retrostdcurrq_tax_income + l_retrospl_tax_income;

Line 501: /*Add together the balances Standard Taxable Income, Special Taxable

497: --if g_debug then
498: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_total_week_days'||l_total_week_days,3900);
499: --end if;
500:
501: /*Add together the balances Standard Taxable Income, Special Taxable
502: Income, Retro Standard Taxable Income, Retro Standard Taxable Income
503: Current Quarter and Retro Special Taxable Income for this first period.*/
504:
505: l_first_period_income:= l_std_tax_income_ptd + l_spl_tax_income_ptd + l_retrostd_tax_income_ptd +

Line 502: Income, Retro Standard Taxable Income, Retro Standard Taxable Income

498: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_total_week_days'||l_total_week_days,3900);
499: --end if;
500:
501: /*Add together the balances Standard Taxable Income, Special Taxable
502: Income, Retro Standard Taxable Income, Retro Standard Taxable Income
503: Current Quarter and Retro Special Taxable Income for this first period.*/
504:
505: l_first_period_income:= l_std_tax_income_ptd + l_spl_tax_income_ptd + l_retrostd_tax_income_ptd +
506: l_retrostdcurrq_tax_income_ptd + l_retrospl_tax_income_ptd;

Line 535: /*Add together the balances Standard Taxable Income, Special Taxable

531: --if g_debug then
532: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_first_period_income'||l_first_period_income,4300);
533: --end if;
534:
535: /*Add together the balances Standard Taxable Income, Special Taxable
536: Income, Retro Standard Taxable Income, Retro Standard Taxable Income
537: Current Quarter and Retro Special Taxable Income for rest of the previous year
538: (excluding the first period), and subtract any value of balance Holiday Allowance
539: Payment for the rest of the previous year (excluding the first period). */

Line 536: Income, Retro Standard Taxable Income, Retro Standard Taxable Income

532: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_first_period_income'||l_first_period_income,4300);
533: --end if;
534:
535: /*Add together the balances Standard Taxable Income, Special Taxable
536: Income, Retro Standard Taxable Income, Retro Standard Taxable Income
537: Current Quarter and Retro Special Taxable Income for rest of the previous year
538: (excluding the first period), and subtract any value of balance Holiday Allowance
539: Payment for the rest of the previous year (excluding the first period). */
540: --Bug 3479044

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 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 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 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');