[Home] [Help]
630: RETURN NUMBER
631: IS
632:
633: CURSOR csr_submitted_exempt IS
634: SELECT SUM(fnd_number.canonical_to_number(pae.aei_information6)) submitted
635: FROM per_assignment_extra_info pae
636: WHERE pae.assignment_id = p_assignment_id
637: AND pae.aei_information1 = p_tax_yr
638: AND pae.aei_information_category ='PER_IN_MEDICAL_BILLS'
644: where assignment_id = p_assignment_id)
645: AND pae.aei_information7 IS NOT NULL;
646:
647: CURSOR csr_submitted_unexempt IS
648: SELECT SUM(fnd_number.canonical_to_number(pae.aei_information6)) submitted
649: FROM per_assignment_extra_info pae
650: WHERE pae.assignment_id = p_assignment_id
651: AND pae.aei_information1 = p_tax_yr
652: AND pae.aei_information_category ='PER_IN_MEDICAL_BILLS'
709: RETURN NUMBER
710: IS
711:
712: CURSOR csr_submitted_exempt IS
713: SELECT SUM(fnd_number.canonical_to_number(pae.aei_information9)) submitted
714: FROM per_assignment_extra_info pae
715: WHERE pae.assignment_id = p_assignment_id
716: AND pae.aei_information1 = p_tax_yr
717: AND pae.aei_information_category ='PER_IN_LTC_BILLS'
724: where assignment_id = p_assignment_id)
725: AND NVL(pae.aei_information18,'N') =nvl(p_carry_over,'N') ;
726:
727: CURSOR csr_submitted_unexempt IS
728: SELECT SUM(fnd_number.canonical_to_number(pae.aei_information9)) submitted
729: FROM per_assignment_extra_info pae
730: WHERE pae.assignment_id = p_assignment_id
731: AND pae.aei_information1 = p_tax_yr
732: AND pae.aei_information_category ='PER_IN_LTC_BILLS'
788: RETURN NUMBER
789: IS
790:
791: CURSOR csr_submitted_exempt IS
792: SELECT sum(nvl(fnd_number.canonical_to_number(nvl(aei_information7,0)),0)) approved
793: FROM per_assignment_extra_info pae
794: WHERE pae.assignment_id = p_assignment_id
795: AND pae.aei_information1 = p_tax_yr
796: AND pae.aei_information_category ='PER_IN_MEDICAL_BILLS'
802: where assignment_id = p_assignment_id)
803: AND pae.aei_information7 IS NOT NULL;
804:
805: CURSOR csr_submitted_unexempt IS
806: SELECT sum(nvl(fnd_number.canonical_to_number(nvl(aei_information7,0)),0)) approved
807: FROM per_assignment_extra_info pae
808: WHERE pae.assignment_id = p_assignment_id
809: AND pae.aei_information1 = p_tax_yr
810: AND pae.aei_information_category ='PER_IN_MEDICAL_BILLS'
863: RETURN NUMBER
864: IS
865:
866: CURSOR csr_submitted_exempt IS
867: SELECT SUM(fnd_number.canonical_to_number(pae.aei_information10)) submitted
868: FROM per_assignment_extra_info pae
869: WHERE pae.assignment_id = p_assignment_id
870: AND pae.aei_information1 = p_tax_yr
871: AND pae.aei_information_category ='PER_IN_LTC_BILLS'
1380: p_aei_information2 => '',
1381: p_aei_information3 => fnd_date.date_to_canonical(p_bill_date),
1382: p_aei_information4 => p_person_id,
1383: p_aei_information5 => p_bill_number,
1384: p_aei_information6 => fnd_number.number_to_canonical(p_new_bill_amt) ,
1385: p_aei_information8 => p_ee_comments,
1386: p_aei_information9 => p_er_comments,
1387: p_aei_information10 => l_element_entry_id,
1388: p_assignment_extra_info_id => l_extra_id_out,
1402: p_aei_information2 => '',
1403: p_aei_information3 => fnd_date.date_to_canonical(p_bill_date),
1404: p_aei_information4 => p_con_person_id,
1405: p_aei_information5 => p_bill_number,
1406: p_aei_information6 => fnd_number.number_to_canonical(p_new_bill_amt) ,
1407: p_aei_information8 => p_ee_comments,
1408: p_aei_information9 => p_er_comments,
1409: p_aei_information10 => l_element_entry_id,
1410: p_assignment_extra_info_id => p_asg_extra_info_id,