eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_NL_REM_REPORT dependencies on STANDARD

Line 314: l_foreigner_rule_si_std_value := get_balance_value('FOREIGNER_RULE_SI_INCOME_STANDARD_ADJUSTMENT_ASG_RUN',assact_id);

310: /*******************************************
311: Fetch Balance values for various balances
312: ********************************************/
313: l_zvw_refund := NVL(get_balance_value('ZVW_REFUND_ASG_RUN',assact_id),0);
314: l_foreigner_rule_si_std_value := get_balance_value('FOREIGNER_RULE_SI_INCOME_STANDARD_ADJUSTMENT_ASG_RUN',assact_id);
315: l_foreigner_rule_si_spl_value := get_balance_value('FOREIGNER_RULE_SI_INCOME_SPECIAL_ADJUSTMENT_ASG_RUN',assact_id);
316: l_wage_in_money_tax_si_value := get_balance_value('WAGE_IN_MONEY_STANDARD_TAX_SI_ASG_RUN',assact_id);
317: l_wage_in_money_spl_tax_value := get_balance_value('WAGE_IN_MONEY_SPECIAL_TAX_SI_ASG_RUN',assact_id);
318: l_wage_in_kind_std_tax_value := get_balance_value('WAGE_IN_KIND_STANDARD_TAX_SI_ASG_RUN',assact_id);

Line 316: l_wage_in_money_tax_si_value := get_balance_value('WAGE_IN_MONEY_STANDARD_TAX_SI_ASG_RUN',assact_id);

312: ********************************************/
313: l_zvw_refund := NVL(get_balance_value('ZVW_REFUND_ASG_RUN',assact_id),0);
314: l_foreigner_rule_si_std_value := get_balance_value('FOREIGNER_RULE_SI_INCOME_STANDARD_ADJUSTMENT_ASG_RUN',assact_id);
315: l_foreigner_rule_si_spl_value := get_balance_value('FOREIGNER_RULE_SI_INCOME_SPECIAL_ADJUSTMENT_ASG_RUN',assact_id);
316: l_wage_in_money_tax_si_value := get_balance_value('WAGE_IN_MONEY_STANDARD_TAX_SI_ASG_RUN',assact_id);
317: l_wage_in_money_spl_tax_value := get_balance_value('WAGE_IN_MONEY_SPECIAL_TAX_SI_ASG_RUN',assact_id);
318: l_wage_in_kind_std_tax_value := get_balance_value('WAGE_IN_KIND_STANDARD_TAX_SI_ASG_RUN',assact_id);
319: l_wage_in_kind_spl_tax_value := get_balance_value('WAGE_IN_KIND_SPECIAL_TAX_SI_ASG_RUN',assact_id);
320: l_tips_fund_tax_std_si_value := get_balance_value('TIPS_AND_FUND_PAYMENTS_STANDARD_TAX_SI_ASG_RUN',assact_id);

Line 318: l_wage_in_kind_std_tax_value := get_balance_value('WAGE_IN_KIND_STANDARD_TAX_SI_ASG_RUN',assact_id);

314: l_foreigner_rule_si_std_value := get_balance_value('FOREIGNER_RULE_SI_INCOME_STANDARD_ADJUSTMENT_ASG_RUN',assact_id);
315: l_foreigner_rule_si_spl_value := get_balance_value('FOREIGNER_RULE_SI_INCOME_SPECIAL_ADJUSTMENT_ASG_RUN',assact_id);
316: l_wage_in_money_tax_si_value := get_balance_value('WAGE_IN_MONEY_STANDARD_TAX_SI_ASG_RUN',assact_id);
317: l_wage_in_money_spl_tax_value := get_balance_value('WAGE_IN_MONEY_SPECIAL_TAX_SI_ASG_RUN',assact_id);
318: l_wage_in_kind_std_tax_value := get_balance_value('WAGE_IN_KIND_STANDARD_TAX_SI_ASG_RUN',assact_id);
319: l_wage_in_kind_spl_tax_value := get_balance_value('WAGE_IN_KIND_SPECIAL_TAX_SI_ASG_RUN',assact_id);
320: l_tips_fund_tax_std_si_value := get_balance_value('TIPS_AND_FUND_PAYMENTS_STANDARD_TAX_SI_ASG_RUN',assact_id);
321: l_tips_fund_tax_spl_si_value := get_balance_value('TIPS_AND_FUND_PAYMENTS_SPECIAL_TAX_SI_ASG_RUN',assact_id);
322: l_pre_tax_deductions_value := get_balance_value('PRE_TAX_ONLY_DEDUCTIONS_ASG_RUN',assact_id);

Line 320: l_tips_fund_tax_std_si_value := get_balance_value('TIPS_AND_FUND_PAYMENTS_STANDARD_TAX_SI_ASG_RUN',assact_id);

316: l_wage_in_money_tax_si_value := get_balance_value('WAGE_IN_MONEY_STANDARD_TAX_SI_ASG_RUN',assact_id);
317: l_wage_in_money_spl_tax_value := get_balance_value('WAGE_IN_MONEY_SPECIAL_TAX_SI_ASG_RUN',assact_id);
318: l_wage_in_kind_std_tax_value := get_balance_value('WAGE_IN_KIND_STANDARD_TAX_SI_ASG_RUN',assact_id);
319: l_wage_in_kind_spl_tax_value := get_balance_value('WAGE_IN_KIND_SPECIAL_TAX_SI_ASG_RUN',assact_id);
320: l_tips_fund_tax_std_si_value := get_balance_value('TIPS_AND_FUND_PAYMENTS_STANDARD_TAX_SI_ASG_RUN',assact_id);
321: l_tips_fund_tax_spl_si_value := get_balance_value('TIPS_AND_FUND_PAYMENTS_SPECIAL_TAX_SI_ASG_RUN',assact_id);
322: l_pre_tax_deductions_value := get_balance_value('PRE_TAX_ONLY_DEDUCTIONS_ASG_RUN',assact_id);
323: l_si_income_std_tax_value := get_balance_value('SI_INCOME_STANDARD_TAX_ASG_RUN',assact_id);
324: l_si_income_spl_tax_value := get_balance_value('SI_INCOME_SPECIAL_TAX_ASG_RUN',assact_id);

Line 323: l_si_income_std_tax_value := get_balance_value('SI_INCOME_STANDARD_TAX_ASG_RUN',assact_id);

319: l_wage_in_kind_spl_tax_value := get_balance_value('WAGE_IN_KIND_SPECIAL_TAX_SI_ASG_RUN',assact_id);
320: l_tips_fund_tax_std_si_value := get_balance_value('TIPS_AND_FUND_PAYMENTS_STANDARD_TAX_SI_ASG_RUN',assact_id);
321: l_tips_fund_tax_spl_si_value := get_balance_value('TIPS_AND_FUND_PAYMENTS_SPECIAL_TAX_SI_ASG_RUN',assact_id);
322: l_pre_tax_deductions_value := get_balance_value('PRE_TAX_ONLY_DEDUCTIONS_ASG_RUN',assact_id);
323: l_si_income_std_tax_value := get_balance_value('SI_INCOME_STANDARD_TAX_ASG_RUN',assact_id);
324: l_si_income_spl_tax_value := get_balance_value('SI_INCOME_SPECIAL_TAX_ASG_RUN',assact_id);
325: l_lcld := NVL(get_balance_value('LIFE_CYCLE_LEAVE_DISCOUNT_ASG_RUN',assact_id),0);
326: l_std_tax_deduction_value := NVL(get_balance_value('STANDARD_TAX_DEDUCTION_ASG_RUN',assact_id),0)
327: + NVL(get_balance_value('STANDARD_TAX_CORRECTION_ASG_RUN',assact_id),0) - l_lcld;

Line 326: l_std_tax_deduction_value := NVL(get_balance_value('STANDARD_TAX_DEDUCTION_ASG_RUN',assact_id),0)

322: l_pre_tax_deductions_value := get_balance_value('PRE_TAX_ONLY_DEDUCTIONS_ASG_RUN',assact_id);
323: l_si_income_std_tax_value := get_balance_value('SI_INCOME_STANDARD_TAX_ASG_RUN',assact_id);
324: l_si_income_spl_tax_value := get_balance_value('SI_INCOME_SPECIAL_TAX_ASG_RUN',assact_id);
325: l_lcld := NVL(get_balance_value('LIFE_CYCLE_LEAVE_DISCOUNT_ASG_RUN',assact_id),0);
326: l_std_tax_deduction_value := NVL(get_balance_value('STANDARD_TAX_DEDUCTION_ASG_RUN',assact_id),0)
327: + NVL(get_balance_value('STANDARD_TAX_CORRECTION_ASG_RUN',assact_id),0) - l_lcld;
328: l_spl_tax_deduction_value := NVL(get_balance_value('SPECIAL_TAX_DEDUCTION_ASG_RUN',assact_id),0)
329: + NVL(get_balance_value('SPECIAL_TAX_CORRECTION_ASG_RUN',assact_id),0);
330: l_labour_tax_deduction_value := get_balance_value('LABOUR_TAX_REDUCTION_ASG_RUN',assact_id);

Line 327: + NVL(get_balance_value('STANDARD_TAX_CORRECTION_ASG_RUN',assact_id),0) - l_lcld;

323: l_si_income_std_tax_value := get_balance_value('SI_INCOME_STANDARD_TAX_ASG_RUN',assact_id);
324: l_si_income_spl_tax_value := get_balance_value('SI_INCOME_SPECIAL_TAX_ASG_RUN',assact_id);
325: l_lcld := NVL(get_balance_value('LIFE_CYCLE_LEAVE_DISCOUNT_ASG_RUN',assact_id),0);
326: l_std_tax_deduction_value := NVL(get_balance_value('STANDARD_TAX_DEDUCTION_ASG_RUN',assact_id),0)
327: + NVL(get_balance_value('STANDARD_TAX_CORRECTION_ASG_RUN',assact_id),0) - l_lcld;
328: l_spl_tax_deduction_value := NVL(get_balance_value('SPECIAL_TAX_DEDUCTION_ASG_RUN',assact_id),0)
329: + NVL(get_balance_value('SPECIAL_TAX_CORRECTION_ASG_RUN',assact_id),0);
330: l_labour_tax_deduction_value := get_balance_value('LABOUR_TAX_REDUCTION_ASG_RUN',assact_id);
331: l_zvw_base_std := get_balance_value('ZVW_INCOME_STANDARD_TAX_ASG_RUN',assact_id);

Line 331: l_zvw_base_std := get_balance_value('ZVW_INCOME_STANDARD_TAX_ASG_RUN',assact_id);

327: + NVL(get_balance_value('STANDARD_TAX_CORRECTION_ASG_RUN',assact_id),0) - l_lcld;
328: l_spl_tax_deduction_value := NVL(get_balance_value('SPECIAL_TAX_DEDUCTION_ASG_RUN',assact_id),0)
329: + NVL(get_balance_value('SPECIAL_TAX_CORRECTION_ASG_RUN',assact_id),0);
330: l_labour_tax_deduction_value := get_balance_value('LABOUR_TAX_REDUCTION_ASG_RUN',assact_id);
331: l_zvw_base_std := get_balance_value('ZVW_INCOME_STANDARD_TAX_ASG_RUN',assact_id);
332: l_zvw_base_spl := get_balance_value('ZVW_INCOME_SPECIAL_TAX_ASG_RUN',assact_id);
333: l_presi_pre_tax_ded_value := get_balance_value('PRE_TAX_DEDUCTIONS_ASG_RUN',assact_id)
334: - get_balance_value('WAGE_DEDUCTION_STANDARD_TAX_SI_ASG_RUN',assact_id)
335: - get_balance_value('WAGE_DEDUCTION_SPECIAL_TAX_SI_ASG_RUN',assact_id);

Line 334: - get_balance_value('WAGE_DEDUCTION_STANDARD_TAX_SI_ASG_RUN',assact_id)

330: l_labour_tax_deduction_value := get_balance_value('LABOUR_TAX_REDUCTION_ASG_RUN',assact_id);
331: l_zvw_base_std := get_balance_value('ZVW_INCOME_STANDARD_TAX_ASG_RUN',assact_id);
332: l_zvw_base_spl := get_balance_value('ZVW_INCOME_SPECIAL_TAX_ASG_RUN',assact_id);
333: l_presi_pre_tax_ded_value := get_balance_value('PRE_TAX_DEDUCTIONS_ASG_RUN',assact_id)
334: - get_balance_value('WAGE_DEDUCTION_STANDARD_TAX_SI_ASG_RUN',assact_id)
335: - get_balance_value('WAGE_DEDUCTION_SPECIAL_TAX_SI_ASG_RUN',assact_id);
336: l_pre_si_and_pre_tax_value := NVL(l_presi_pre_tax_ded_value,0) - NVL(l_pre_tax_deductions_value,0);
337: l_wage_in_money_tax_si_value := NVL(l_wage_in_money_tax_si_value,0) - NVL(l_foreigner_rule_si_std_value,0);
338: l_wage_in_money_spl_tax_value := NVL(l_wage_in_money_spl_tax_value,0) - NVL(l_foreigner_rule_si_spl_value,0);

Line 346: l_ee_si_cont_std_tax_val_zfw := get_balance_value('EMPLOYEE_SI_CONTRIBUTION_STANDARD_TAX_ASG_SIT_RUN',assact_id,l_context_id,'ZVWL');

342: ELSE
343: l_real_si_days := 0;
344: END IF;
345:
346: l_ee_si_cont_std_tax_val_zfw := get_balance_value('EMPLOYEE_SI_CONTRIBUTION_STANDARD_TAX_ASG_SIT_RUN',assact_id,l_context_id,'ZVWL');
347: l_ee_si_cont_spl_tax_val_zfw := get_balance_value('EMPLOYEE_SI_CONTRIBUTION_SPECIAL_TAX_ASG_SIT_RUN',assact_id,l_context_id,'ZVWL');
348: l_net_ee_si_cont_value_zfw := get_balance_value('NET_EMPLOYEE_SI_CONTRIBUTION_ASG_SIT_RUN',assact_id,l_context_id,'ZVWL');
349:
350:

Line 356: l_std_tax_income := get_balance_value('STANDARD_TAXABLE_INCOME_ASG_RUN',assact_id);

352: ,0) + NVL(l_net_ee_si_cont_value_zfw
353: ,0);
354:
355: l_spl_tax_income := get_balance_value('SPECIAL_TAXABLE_INCOME_ASG_RUN',assact_id);
356: l_std_tax_income := get_balance_value('STANDARD_TAXABLE_INCOME_ASG_RUN',assact_id);
357:
358: /***************************************************
359: End of fetching Balance Values
360: ****************************************************/

Line 558: l_wage_in_money_std_retro := get_balance_value('RETRO_WAGE_IN_MONEY_STANDARD_TAX_SI_ASG_BDATE_RUN',assact_id,NULL,NULL,l_retro_period);

554: /****************************************************************
555: Fetch Balance Values for Calculation
556: *****************************************************************/
557: l_zvw_refund_r := NVL(get_balance_value('RETRO_ZVW_REFUND_ASG_BDATE_RUN',assact_id,NULL,NULL,l_retro_period),0);
558: l_wage_in_money_std_retro := get_balance_value('RETRO_WAGE_IN_MONEY_STANDARD_TAX_SI_ASG_BDATE_RUN',assact_id,NULL,NULL,l_retro_period);
559: l_wage_in_money_spl_retro := get_balance_value('RETRO_WAGE_IN_MONEY_SPECIAL_TAX_SI_ASG_BDATE_RUN',assact_id,NULL,NULL,l_retro_period);
560: l_wage_in_kind_std_retro := get_balance_value('RETRO_WAGE_IN_KIND_STANDARD_TAX_SI_ASG_BDATE_RUN',assact_id,NULL,NULL,l_retro_period);
561: l_wage_in_kind_spl_retro := get_balance_value('RETRO_WAGE_IN_KIND_SPECIAL_TAX_SI_ASG_BDATE_RUN',assact_id,NULL,NULL,l_retro_period);
562: l_tips_fund_tax_std_retro := get_balance_value('RETRO_TIPS_AND_FUND_PAYMENTS_STANDARD_TAX_SI_ASG_BDATE_RUN',assact_id,NULL,NULL,l_retro_period);

Line 560: l_wage_in_kind_std_retro := get_balance_value('RETRO_WAGE_IN_KIND_STANDARD_TAX_SI_ASG_BDATE_RUN',assact_id,NULL,NULL,l_retro_period);

556: *****************************************************************/
557: l_zvw_refund_r := NVL(get_balance_value('RETRO_ZVW_REFUND_ASG_BDATE_RUN',assact_id,NULL,NULL,l_retro_period),0);
558: l_wage_in_money_std_retro := get_balance_value('RETRO_WAGE_IN_MONEY_STANDARD_TAX_SI_ASG_BDATE_RUN',assact_id,NULL,NULL,l_retro_period);
559: l_wage_in_money_spl_retro := get_balance_value('RETRO_WAGE_IN_MONEY_SPECIAL_TAX_SI_ASG_BDATE_RUN',assact_id,NULL,NULL,l_retro_period);
560: l_wage_in_kind_std_retro := get_balance_value('RETRO_WAGE_IN_KIND_STANDARD_TAX_SI_ASG_BDATE_RUN',assact_id,NULL,NULL,l_retro_period);
561: l_wage_in_kind_spl_retro := get_balance_value('RETRO_WAGE_IN_KIND_SPECIAL_TAX_SI_ASG_BDATE_RUN',assact_id,NULL,NULL,l_retro_period);
562: l_tips_fund_tax_std_retro := get_balance_value('RETRO_TIPS_AND_FUND_PAYMENTS_STANDARD_TAX_SI_ASG_BDATE_RUN',assact_id,NULL,NULL,l_retro_period);
563: l_tips_fund_tax_spl_retro := get_balance_value('RETRO_TIPS_AND_FUND_PAYMENTS_SPECIAL_TAX_SI_ASG_BDATE_RUN',assact_id,NULL,NULL,l_retro_period);
564: l_retro_pre_tax_ded := get_balance_value('RETRO_PRE_TAX_ONLY_DEDUCTIONS_ASG_BDATE_RUN',assact_id,NULL,NULL,l_retro_period);

Line 562: l_tips_fund_tax_std_retro := get_balance_value('RETRO_TIPS_AND_FUND_PAYMENTS_STANDARD_TAX_SI_ASG_BDATE_RUN',assact_id,NULL,NULL,l_retro_period);

558: l_wage_in_money_std_retro := get_balance_value('RETRO_WAGE_IN_MONEY_STANDARD_TAX_SI_ASG_BDATE_RUN',assact_id,NULL,NULL,l_retro_period);
559: l_wage_in_money_spl_retro := get_balance_value('RETRO_WAGE_IN_MONEY_SPECIAL_TAX_SI_ASG_BDATE_RUN',assact_id,NULL,NULL,l_retro_period);
560: l_wage_in_kind_std_retro := get_balance_value('RETRO_WAGE_IN_KIND_STANDARD_TAX_SI_ASG_BDATE_RUN',assact_id,NULL,NULL,l_retro_period);
561: l_wage_in_kind_spl_retro := get_balance_value('RETRO_WAGE_IN_KIND_SPECIAL_TAX_SI_ASG_BDATE_RUN',assact_id,NULL,NULL,l_retro_period);
562: l_tips_fund_tax_std_retro := get_balance_value('RETRO_TIPS_AND_FUND_PAYMENTS_STANDARD_TAX_SI_ASG_BDATE_RUN',assact_id,NULL,NULL,l_retro_period);
563: l_tips_fund_tax_spl_retro := get_balance_value('RETRO_TIPS_AND_FUND_PAYMENTS_SPECIAL_TAX_SI_ASG_BDATE_RUN',assact_id,NULL,NULL,l_retro_period);
564: l_retro_pre_tax_ded := get_balance_value('RETRO_PRE_TAX_ONLY_DEDUCTIONS_ASG_BDATE_RUN',assact_id,NULL,NULL,l_retro_period);
565: l_retro_pre_si := NVL(get_balance_value('RETRO_PRE_TAX_DEDUCTIONS_ASG_BDATE_RUN',assact_id,NULL,NULL,l_retro_period),0)
566: - NVL(l_retro_pre_tax_ded,0)

Line 567: - NVL(get_balance_value('RETRO_WAGE_DEDUCTION_STANDARD_TAX_SI_ASG_BDATE_RUN',assact_id,NULL,NULL,l_retro_period),0)

563: l_tips_fund_tax_spl_retro := get_balance_value('RETRO_TIPS_AND_FUND_PAYMENTS_SPECIAL_TAX_SI_ASG_BDATE_RUN',assact_id,NULL,NULL,l_retro_period);
564: l_retro_pre_tax_ded := get_balance_value('RETRO_PRE_TAX_ONLY_DEDUCTIONS_ASG_BDATE_RUN',assact_id,NULL,NULL,l_retro_period);
565: l_retro_pre_si := NVL(get_balance_value('RETRO_PRE_TAX_DEDUCTIONS_ASG_BDATE_RUN',assact_id,NULL,NULL,l_retro_period),0)
566: - NVL(l_retro_pre_tax_ded,0)
567: - NVL(get_balance_value('RETRO_WAGE_DEDUCTION_STANDARD_TAX_SI_ASG_BDATE_RUN',assact_id,NULL,NULL,l_retro_period),0)
568: - NVL(get_balance_value('RETRO_WAGE_DEDUCTION_SPECIAL_TAX_SI_ASG_BDATE_RUN',assact_id,NULL,NULL,l_retro_period)
569: ,0);
570: l_retro_si_income_std_tax := get_balance_value('RETRO_SI_INCOME_STANDARD_TAX_ASG_BDATE_RUN',assact_id,NULL,NULL,l_retro_period);
571: l_retro_si_income_spl_tax := get_balance_value('RETRO_SI_INCOME_SPECIAL_TAX_ASG_BDATE_RUN',assact_id,NULL,NULL,l_retro_period);

Line 570: l_retro_si_income_std_tax := get_balance_value('RETRO_SI_INCOME_STANDARD_TAX_ASG_BDATE_RUN',assact_id,NULL,NULL,l_retro_period);

566: - NVL(l_retro_pre_tax_ded,0)
567: - NVL(get_balance_value('RETRO_WAGE_DEDUCTION_STANDARD_TAX_SI_ASG_BDATE_RUN',assact_id,NULL,NULL,l_retro_period),0)
568: - NVL(get_balance_value('RETRO_WAGE_DEDUCTION_SPECIAL_TAX_SI_ASG_BDATE_RUN',assact_id,NULL,NULL,l_retro_period)
569: ,0);
570: l_retro_si_income_std_tax := get_balance_value('RETRO_SI_INCOME_STANDARD_TAX_ASG_BDATE_RUN',assact_id,NULL,NULL,l_retro_period);
571: l_retro_si_income_spl_tax := get_balance_value('RETRO_SI_INCOME_SPECIAL_TAX_ASG_BDATE_RUN',assact_id,NULL,NULL,l_retro_period);
572:
573: l_std_tax_income_retro := NVL(get_balance_value('RETRO_STANDARD_TAXABLE_INCOME_ASG_BDATE_RUN',assact_id,NULL,NULL,l_retro_period),0)
574: + NVL(get_balance_value('RETRO_STANDARD_TAXABLE_INCOME_CURRENT_QUARTER_ASG_BDATE_RUN',assact_id,NULL,NULL,l_retro_period),0);

Line 573: l_std_tax_income_retro := NVL(get_balance_value('RETRO_STANDARD_TAXABLE_INCOME_ASG_BDATE_RUN',assact_id,NULL,NULL,l_retro_period),0)

569: ,0);
570: l_retro_si_income_std_tax := get_balance_value('RETRO_SI_INCOME_STANDARD_TAX_ASG_BDATE_RUN',assact_id,NULL,NULL,l_retro_period);
571: l_retro_si_income_spl_tax := get_balance_value('RETRO_SI_INCOME_SPECIAL_TAX_ASG_BDATE_RUN',assact_id,NULL,NULL,l_retro_period);
572:
573: l_std_tax_income_retro := NVL(get_balance_value('RETRO_STANDARD_TAXABLE_INCOME_ASG_BDATE_RUN',assact_id,NULL,NULL,l_retro_period),0)
574: + NVL(get_balance_value('RETRO_STANDARD_TAXABLE_INCOME_CURRENT_QUARTER_ASG_BDATE_RUN',assact_id,NULL,NULL,l_retro_period),0);
575: l_spl_tax_income_retro := NVL(get_balance_value('RETRO_SPECIAL_TAXABLE_INCOME_ASG_BDATE_RUN',assact_id,NULL,NULL,l_retro_period),0);
576: l_retro_std_tax_ded := get_balance_value('RETRO_STANDARD_TAX_DEDUCTION_ASG_BDATE_RUN',assact_id,NULL,NULL,l_retro_period);
577: l_retro_std_ded_quarter := get_balance_value('RETRO_STANDARD_TAX_DEDUCTION_CURRENT_QUARTER_ASG_BDATE_RUN',assact_id,NULL,NULL,l_retro_period);

Line 574: + NVL(get_balance_value('RETRO_STANDARD_TAXABLE_INCOME_CURRENT_QUARTER_ASG_BDATE_RUN',assact_id,NULL,NULL,l_retro_period),0);

570: l_retro_si_income_std_tax := get_balance_value('RETRO_SI_INCOME_STANDARD_TAX_ASG_BDATE_RUN',assact_id,NULL,NULL,l_retro_period);
571: l_retro_si_income_spl_tax := get_balance_value('RETRO_SI_INCOME_SPECIAL_TAX_ASG_BDATE_RUN',assact_id,NULL,NULL,l_retro_period);
572:
573: l_std_tax_income_retro := NVL(get_balance_value('RETRO_STANDARD_TAXABLE_INCOME_ASG_BDATE_RUN',assact_id,NULL,NULL,l_retro_period),0)
574: + NVL(get_balance_value('RETRO_STANDARD_TAXABLE_INCOME_CURRENT_QUARTER_ASG_BDATE_RUN',assact_id,NULL,NULL,l_retro_period),0);
575: l_spl_tax_income_retro := NVL(get_balance_value('RETRO_SPECIAL_TAXABLE_INCOME_ASG_BDATE_RUN',assact_id,NULL,NULL,l_retro_period),0);
576: l_retro_std_tax_ded := get_balance_value('RETRO_STANDARD_TAX_DEDUCTION_ASG_BDATE_RUN',assact_id,NULL,NULL,l_retro_period);
577: l_retro_std_ded_quarter := get_balance_value('RETRO_STANDARD_TAX_DEDUCTION_CURRENT_QUARTER_ASG_BDATE_RUN',assact_id,NULL,NULL,l_retro_period);
578: l_retro_spl_tax_ded := get_balance_value('RETRO_SPECIAL_TAX_DEDUCTION_ASG_BDATE_RUN',assact_id,NULL,NULL,l_retro_period);

Line 576: l_retro_std_tax_ded := get_balance_value('RETRO_STANDARD_TAX_DEDUCTION_ASG_BDATE_RUN',assact_id,NULL,NULL,l_retro_period);

572:
573: l_std_tax_income_retro := NVL(get_balance_value('RETRO_STANDARD_TAXABLE_INCOME_ASG_BDATE_RUN',assact_id,NULL,NULL,l_retro_period),0)
574: + NVL(get_balance_value('RETRO_STANDARD_TAXABLE_INCOME_CURRENT_QUARTER_ASG_BDATE_RUN',assact_id,NULL,NULL,l_retro_period),0);
575: l_spl_tax_income_retro := NVL(get_balance_value('RETRO_SPECIAL_TAXABLE_INCOME_ASG_BDATE_RUN',assact_id,NULL,NULL,l_retro_period),0);
576: l_retro_std_tax_ded := get_balance_value('RETRO_STANDARD_TAX_DEDUCTION_ASG_BDATE_RUN',assact_id,NULL,NULL,l_retro_period);
577: l_retro_std_ded_quarter := get_balance_value('RETRO_STANDARD_TAX_DEDUCTION_CURRENT_QUARTER_ASG_BDATE_RUN',assact_id,NULL,NULL,l_retro_period);
578: l_retro_spl_tax_ded := get_balance_value('RETRO_SPECIAL_TAX_DEDUCTION_ASG_BDATE_RUN',assact_id,NULL,NULL,l_retro_period);
579: l_lcld_r := NVL(get_balance_value('RETRO_LIFE_CYCLE_LEAVE_DISCOUNT_ASG_BDATE_RUN',assact_id,NULL,NULL,l_retro_period),0);
580:

Line 577: l_retro_std_ded_quarter := get_balance_value('RETRO_STANDARD_TAX_DEDUCTION_CURRENT_QUARTER_ASG_BDATE_RUN',assact_id,NULL,NULL,l_retro_period);

573: l_std_tax_income_retro := NVL(get_balance_value('RETRO_STANDARD_TAXABLE_INCOME_ASG_BDATE_RUN',assact_id,NULL,NULL,l_retro_period),0)
574: + NVL(get_balance_value('RETRO_STANDARD_TAXABLE_INCOME_CURRENT_QUARTER_ASG_BDATE_RUN',assact_id,NULL,NULL,l_retro_period),0);
575: l_spl_tax_income_retro := NVL(get_balance_value('RETRO_SPECIAL_TAXABLE_INCOME_ASG_BDATE_RUN',assact_id,NULL,NULL,l_retro_period),0);
576: l_retro_std_tax_ded := get_balance_value('RETRO_STANDARD_TAX_DEDUCTION_ASG_BDATE_RUN',assact_id,NULL,NULL,l_retro_period);
577: l_retro_std_ded_quarter := get_balance_value('RETRO_STANDARD_TAX_DEDUCTION_CURRENT_QUARTER_ASG_BDATE_RUN',assact_id,NULL,NULL,l_retro_period);
578: l_retro_spl_tax_ded := get_balance_value('RETRO_SPECIAL_TAX_DEDUCTION_ASG_BDATE_RUN',assact_id,NULL,NULL,l_retro_period);
579: l_lcld_r := NVL(get_balance_value('RETRO_LIFE_CYCLE_LEAVE_DISCOUNT_ASG_BDATE_RUN',assact_id,NULL,NULL,l_retro_period),0);
580:
581: l_retro_std_tax_ded := NVL(l_retro_std_tax_ded,0) + NVL(l_retro_std_ded_quarter,0) - l_lcld_r;

Line 584: l_retro_ee_sic_zfw := get_balance_value('RETRO_EMPLOYEE_SI_CONTRIBUTION_STANDARD_TAX_ASG_BDATE_SIT_RUN',assact_id,l_context_id,'ZVWL',l_retro_period);

580:
581: l_retro_std_tax_ded := NVL(l_retro_std_tax_ded,0) + NVL(l_retro_std_ded_quarter,0) - l_lcld_r;
582: l_retro_spl_tax_ded_sum := NVL(l_retro_spl_tax_ded,0);
583: l_retro_net_ee_sic_zfw := get_balance_value('RETRO_NET_EMPLOYEE_SI_CONTRIBUTION_ASG_BDATE_SIT_RUN',assact_id,l_context_id,'ZVWL',l_retro_period);
584: l_retro_ee_sic_zfw := get_balance_value('RETRO_EMPLOYEE_SI_CONTRIBUTION_STANDARD_TAX_ASG_BDATE_SIT_RUN',assact_id,l_context_id,'ZVWL',l_retro_period);
585: l_retro_ded_zfw := NVL(l_retro_ee_sic_zfw,0) + NVL(l_retro_net_ee_sic_zfw,0);
586: l_retro_ee_sic_spl_zfw := get_balance_value('RETRO_EMPLOYEE_SI_CONTRIBUTION_SPECIAL_TAX_ASG_BDATE_SIT_RUN',assact_id,l_context_id,'ZVWL',l_retro_period);
587: l_retro_labour_tax_ded := get_balance_value('RETRO_LABOUR_TAX_REDUCTION_ASG_BDATE_RUN',assact_id,NULL,NULL,l_retro_period);
588: l_zvw_base_std_r_ID := pay_nl_general.get_element_type_id('Retro ZVW Income Standard Tax',p_reporting_date);

Line 588: l_zvw_base_std_r_ID := pay_nl_general.get_element_type_id('Retro ZVW Income Standard Tax',p_reporting_date);

584: l_retro_ee_sic_zfw := get_balance_value('RETRO_EMPLOYEE_SI_CONTRIBUTION_STANDARD_TAX_ASG_BDATE_SIT_RUN',assact_id,l_context_id,'ZVWL',l_retro_period);
585: l_retro_ded_zfw := NVL(l_retro_ee_sic_zfw,0) + NVL(l_retro_net_ee_sic_zfw,0);
586: l_retro_ee_sic_spl_zfw := get_balance_value('RETRO_EMPLOYEE_SI_CONTRIBUTION_SPECIAL_TAX_ASG_BDATE_SIT_RUN',assact_id,l_context_id,'ZVWL',l_retro_period);
587: l_retro_labour_tax_ded := get_balance_value('RETRO_LABOUR_TAX_REDUCTION_ASG_BDATE_RUN',assact_id,NULL,NULL,l_retro_period);
588: l_zvw_base_std_r_ID := pay_nl_general.get_element_type_id('Retro ZVW Income Standard Tax',p_reporting_date);
589: l_zvw_base_spl_r_id := pay_nl_general.get_element_type_id('Retro ZVW Income Special Tax',p_reporting_date);
590:
591: l_zvw_base_std_r := NVL(pay_nl_general.get_retro_sum_element(retro_period
592: ,NULL

Line 600: OPEN cur_get_zvw_input_value('Retro ZVW Income Standard Tax');

596: ,assact_id)
597: ,0);
598:
599: IF l_zvw_correction <> assact_id THEN
600: OPEN cur_get_zvw_input_value('Retro ZVW Income Standard Tax');
601: FETCH cur_get_zvw_input_value
602: INTO l_zvw_input_value;
603: CLOSE cur_get_zvw_input_value;
604:

Line 1625: /EndCall to fetch employee Retro Payroll Details Standard and Special /

1621: END IF;
1622:
1623: END LOOP RetroPeriod;
1624: CLOSE cur_retro_period_det;
1625: /*EndCall to fetch employee Retro Payroll Details Standard and Special */
1626:
1627: END LOOP Period;
1628: CLOSE cur_pay_period;
1629: