[Home] [Help]
501: where paa.assignment_action_id = p_assignment_action_id
502: and ppa.payroll_action_id = paa.payroll_action_id
503: and pi.assignment_id = paa.assignment_id
504: and pi.information_type = 'KR_YEA_TAX_EXEM_INFO'
505: and trunc(fnd_date.canonical_to_date(pi.aei_information1), 'YYYY')
506: = trunc(ppa.effective_date, 'YYYY');
507:
508: --5190884
509: cursor csr_emp_exp_details is
522: where paa.assignment_action_id = p_assignment_action_id
523: and ppa.payroll_action_id = paa.payroll_action_id
524: and pei.assignment_id = paa.assignment_id
525: and pei.information_type = 'KR_YEA_EMP_EXPENSE_DETAILS'
526: and trunc(fnd_date.canonical_to_date(pei.aei_information1), 'YYYY')
527: = trunc(ppa.effective_date, 'YYYY');
528:
529: cursor csr_get_emp_exp_amount is
530: select nvl(to_number(aei_information18), 0) + nvl(to_number(aei_information19), 0) +
536: where paa.assignment_action_id = p_assignment_action_id
537: and ppa.payroll_action_id = paa.payroll_action_id
538: and pi.assignment_id = paa.assignment_id
539: and pi.information_type = 'KR_YEA_SP_TAX_EXEM_INFO'
540: and trunc(fnd_date.canonical_to_date(pi.aei_information1), 'YYYY')
541: = trunc(ppa.effective_date, 'YYYY');
542:
543: cursor csr_get_emp_card_expense is
544: select nvl(to_number(aei_information7), 0),
550: where paa.assignment_action_id = p_assignment_action_id
551: and ppa.payroll_action_id = paa.payroll_action_id
552: and pi.assignment_id = paa.assignment_id
553: and pi.information_type = 'KR_YEA_TAX_EXEM_INFO'
554: and trunc(fnd_date.canonical_to_date(pi.aei_information1), 'YYYY')
555: = trunc(ppa.effective_date, 'YYYY');
556: -- BUG 14502155
557: cursor csr_get_tm_emp_card_expense is
558: select nvl(to_number(aei_information3), 0),
564: where paa.assignment_action_id = p_assignment_action_id
565: and ppa.payroll_action_id = paa.payroll_action_id
566: and pi.assignment_id = paa.assignment_id
567: and pi.information_type = 'KR_YEA_TAX_EXEM_INFO2'
568: and trunc(fnd_date.canonical_to_date(pi.aei_information1), 'YYYY')
569: = trunc(ppa.effective_date, 'YYYY');
570:
571: cursor csr_get_emp_don_educ_details is
572: select nvl(to_number(aei_information4), 0) +
581: where paa.assignment_action_id = p_assignment_action_id
582: and ppa.payroll_action_id = paa.payroll_action_id
583: and pi.assignment_id = paa.assignment_id
584: and pi.information_type = 'KR_YEA_SP_TAX_EXEM_INFO2'
585: and trunc(fnd_date.canonical_to_date(pi.aei_information1), 'YYYY')
586: = trunc(ppa.effective_date, 'YYYY');
587:
588: -- Bug 5726158
589: cursor csr_asg_details is
1513: + l_yea_info.disabled_ins_prem); -- Bug 7260606
1514: p_emp_med_exp_oth := l_yea_info.med_exp_emp - p_emp_med_exp_nts;
1515: -- Bug : 5745179
1516: --
1517: l_don_tax_break2004 := pay_kr_yea_form_pkg.get_donation_tax_break(fnd_date.date_to_canonical(l_rec.effective_date), l_yea_info.political_donation1);
1518: --
1519: p_emp_don_exp_oth := ( nvl(l_don_amount1,0) + nvl(l_don_amount2,0) - nvl(l_don_tax_break2004,0))
1520: - nvl(p_emp_don_exp_nts,0) - nvl(l_dpnt_don_total,0);
1521: p_emp_educ_exp_oth := ( l_yea_info.ee_educ_exp + l_emp_occu_trng ) - p_emp_educ_exp_nts;