[Home] [Help]
581: RETURN NUMBER
582: IS
583:
584: CURSOR csr_submitted_exempt IS
585: SELECT SUM(fnd_number.canonical_to_number(pae.aei_information6)) submitted
586: FROM per_assignment_extra_info pae
587: WHERE pae.assignment_id = p_assignment_id
588: AND pae.aei_information1 = p_tax_yr
589: AND pae.aei_information_category ='PER_IN_MEDICAL_BILLS'
595: where assignment_id = p_assignment_id)
596: AND pae.aei_information7 IS NOT NULL;
597:
598: CURSOR csr_submitted_unexempt IS
599: SELECT SUM(fnd_number.canonical_to_number(pae.aei_information6)) submitted
600: FROM per_assignment_extra_info pae
601: WHERE pae.assignment_id = p_assignment_id
602: AND pae.aei_information1 = p_tax_yr
603: AND pae.aei_information_category ='PER_IN_MEDICAL_BILLS'
660: RETURN NUMBER
661: IS
662:
663: CURSOR csr_submitted_exempt IS
664: SELECT SUM(fnd_number.canonical_to_number(pae.aei_information9)) submitted
665: FROM per_assignment_extra_info pae
666: WHERE pae.assignment_id = p_assignment_id
667: AND pae.aei_information1 = p_tax_yr
668: AND pae.aei_information_category ='PER_IN_LTC_BILLS'
675: where assignment_id = p_assignment_id)
676: AND NVL(pae.aei_information18,'N') =nvl(p_carry_over,'N') ;
677:
678: CURSOR csr_submitted_unexempt IS
679: SELECT SUM(fnd_number.canonical_to_number(pae.aei_information9)) submitted
680: FROM per_assignment_extra_info pae
681: WHERE pae.assignment_id = p_assignment_id
682: AND pae.aei_information1 = p_tax_yr
683: AND pae.aei_information_category ='PER_IN_LTC_BILLS'
739: RETURN NUMBER
740: IS
741:
742: CURSOR csr_submitted_exempt IS
743: SELECT sum(nvl(fnd_number.canonical_to_number(nvl(aei_information7,0)),0)) approved
744: FROM per_assignment_extra_info pae
745: WHERE pae.assignment_id = p_assignment_id
746: AND pae.aei_information1 = p_tax_yr
747: AND pae.aei_information_category ='PER_IN_MEDICAL_BILLS'
753: where assignment_id = p_assignment_id)
754: AND pae.aei_information7 IS NOT NULL;
755:
756: CURSOR csr_submitted_unexempt IS
757: SELECT sum(nvl(fnd_number.canonical_to_number(nvl(aei_information7,0)),0)) approved
758: FROM per_assignment_extra_info pae
759: WHERE pae.assignment_id = p_assignment_id
760: AND pae.aei_information1 = p_tax_yr
761: AND pae.aei_information_category ='PER_IN_MEDICAL_BILLS'
814: RETURN NUMBER
815: IS
816:
817: CURSOR csr_submitted_exempt IS
818: SELECT SUM(fnd_number.canonical_to_number(pae.aei_information10)) submitted
819: FROM per_assignment_extra_info pae
820: WHERE pae.assignment_id = p_assignment_id
821: AND pae.aei_information1 = p_tax_yr
822: AND pae.aei_information_category ='PER_IN_LTC_BILLS'
1331: p_aei_information2 => '',
1332: p_aei_information3 => fnd_date.date_to_canonical(p_bill_date),
1333: p_aei_information4 => p_person_id,
1334: p_aei_information5 => p_bill_number,
1335: p_aei_information6 => fnd_number.number_to_canonical(p_new_bill_amt) ,
1336: p_aei_information8 => p_ee_comments,
1337: p_aei_information9 => p_er_comments,
1338: p_aei_information10 => l_element_entry_id,
1339: p_assignment_extra_info_id => l_extra_id_out,
1353: p_aei_information2 => '',
1354: p_aei_information3 => fnd_date.date_to_canonical(p_bill_date),
1355: p_aei_information4 => p_con_person_id,
1356: p_aei_information5 => p_bill_number,
1357: p_aei_information6 => fnd_number.number_to_canonical(p_new_bill_amt) ,
1358: p_aei_information8 => p_ee_comments,
1359: p_aei_information9 => p_er_comments,
1360: p_aei_information10 => l_element_entry_id,
1361: p_assignment_extra_info_id => p_asg_extra_info_id,