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_NO_ARC_RSEA_07 dependencies on FND_DATE

Line 587: AND p_date_earned BETWEEN fnd_date.canonical_to_date(hoi2.org_information2)

583: AND hoi1.org_information1 = 'NO_LOCAL_UNIT'
584: AND hoi1.org_information_context = 'CLASS'
585: AND o1.organization_id = hoi2.organization_id
586: AND hoi2.org_information_context = 'NO_NI_EXEMPTION_LIMIT'
587: AND p_date_earned BETWEEN fnd_date.canonical_to_date(hoi2.org_information2)
588: AND fnd_date.canonical_to_date(hoi2.org_information3);
589: --
590: Cursor csr_Legal_Emp_EA(csr_v_legal_emp_id hr_organization_information.organization_id%TYPE
591: ,p_date_earned DATE) IS

Line 588: AND fnd_date.canonical_to_date(hoi2.org_information3);

584: AND hoi1.org_information_context = 'CLASS'
585: AND o1.organization_id = hoi2.organization_id
586: AND hoi2.org_information_context = 'NO_NI_EXEMPTION_LIMIT'
587: AND p_date_earned BETWEEN fnd_date.canonical_to_date(hoi2.org_information2)
588: AND fnd_date.canonical_to_date(hoi2.org_information3);
589: --
590: Cursor csr_Legal_Emp_EA(csr_v_legal_emp_id hr_organization_information.organization_id%TYPE
591: ,p_date_earned DATE) IS
592: SELECT to_number(hoi2.org_information4)

Line 603: AND p_date_earned BETWEEN fnd_date.canonical_to_date(hoi2.org_information2)

599: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'
600: AND hoi1.org_information_context = 'CLASS'
601: AND o1.organization_id = hoi2.organization_id
602: AND hoi2.org_information_context ='NO_NI_EXEMPTION_LIMIT'
603: AND p_date_earned BETWEEN fnd_date.canonical_to_date(hoi2.org_information2)
604: AND fnd_date.canonical_to_date(hoi2.org_information3);
605: --
606: CURSOR csr_Local_Unit_EL(csr_v_local_unit_id hr_organization_information.organization_id%TYPE
607: ,p_date_earned DATE) IS

Line 604: AND fnd_date.canonical_to_date(hoi2.org_information3);

600: AND hoi1.org_information_context = 'CLASS'
601: AND o1.organization_id = hoi2.organization_id
602: AND hoi2.org_information_context ='NO_NI_EXEMPTION_LIMIT'
603: AND p_date_earned BETWEEN fnd_date.canonical_to_date(hoi2.org_information2)
604: AND fnd_date.canonical_to_date(hoi2.org_information3);
605: --
606: CURSOR csr_Local_Unit_EL(csr_v_local_unit_id hr_organization_information.organization_id%TYPE
607: ,p_date_earned DATE) IS
608: SELECT SUM(hoi2.org_information1) exempt_limit

Line 620: AND trunc(p_date_earned,'Y') >= fnd_date.canonical_to_date(hoi2.org_information2)

616: AND hoi1.org_information1 = 'NO_LOCAL_UNIT'
617: AND hoi1.org_information_context = 'CLASS'
618: AND o1.organization_id = hoi2.organization_id
619: AND hoi2.org_information_context = 'NO_NI_EXEMPTION_LIMIT'
620: AND trunc(p_date_earned,'Y') >= fnd_date.canonical_to_date(hoi2.org_information2)
621: AND trunc(add_months(p_date_earned,12),'Y') < fnd_date.canonical_to_date(hoi2.org_information3);
622: --
623: rg_Local_Unit_EL csr_Local_Unit_EL%ROWTYPE;
624: --

Line 621: AND trunc(add_months(p_date_earned,12),'Y') < fnd_date.canonical_to_date(hoi2.org_information3);

617: AND hoi1.org_information_context = 'CLASS'
618: AND o1.organization_id = hoi2.organization_id
619: AND hoi2.org_information_context = 'NO_NI_EXEMPTION_LIMIT'
620: AND trunc(p_date_earned,'Y') >= fnd_date.canonical_to_date(hoi2.org_information2)
621: AND trunc(add_months(p_date_earned,12),'Y') < fnd_date.canonical_to_date(hoi2.org_information3);
622: --
623: rg_Local_Unit_EL csr_Local_Unit_EL%ROWTYPE;
624: --
625: Cursor csr_Legal_Emp_EL(csr_v_legal_emp_id hr_organization_information.organization_id%TYPE

Line 639: AND trunc(p_date_earned,'Y') >= fnd_date.canonical_to_date(hoi2.org_information2)

635: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'
636: AND hoi1.org_information_context = 'CLASS'
637: AND o1.organization_id = hoi2.organization_id
638: AND hoi2.org_information_context ='NO_NI_EXEMPTION_LIMIT'
639: AND trunc(p_date_earned,'Y') >= fnd_date.canonical_to_date(hoi2.org_information2)
640: AND trunc(add_months(p_date_earned,12),'Y') < fnd_date.canonical_to_date(hoi2.org_information3);
641: --
642: rg_Legal_Emp_EL csr_Legal_Emp_EL%ROWTYPE;
643: --

Line 640: AND trunc(add_months(p_date_earned,12),'Y') < fnd_date.canonical_to_date(hoi2.org_information3);

636: AND hoi1.org_information_context = 'CLASS'
637: AND o1.organization_id = hoi2.organization_id
638: AND hoi2.org_information_context ='NO_NI_EXEMPTION_LIMIT'
639: AND trunc(p_date_earned,'Y') >= fnd_date.canonical_to_date(hoi2.org_information2)
640: AND trunc(add_months(p_date_earned,12),'Y') < fnd_date.canonical_to_date(hoi2.org_information3);
641: --
642: rg_Legal_Emp_EL csr_Legal_Emp_EL%ROWTYPE;
643: --
644: CURSOR csr_Local_Unit_EL_after(csr_v_local_unit_id hr_organization_information.organization_id%TYPE

Line 657: AND p_date_earned > fnd_date.canonical_to_date(hoi2.org_information2)

653: AND hoi1.org_information1 = 'NO_LOCAL_UNIT'
654: AND hoi1.org_information_context = 'CLASS'
655: AND o1.organization_id = hoi2.organization_id
656: AND hoi2.org_information_context = 'NO_NI_EXEMPTION_LIMIT'
657: AND p_date_earned > fnd_date.canonical_to_date(hoi2.org_information2)
658: AND trunc(add_months(p_date_earned,12),'Y') < fnd_date.canonical_to_date(hoi2.org_information3);
659: --
660: rg_Local_Unit_EL_after csr_Local_Unit_EL_after%ROWTYPE;
661: --

Line 658: AND trunc(add_months(p_date_earned,12),'Y') < fnd_date.canonical_to_date(hoi2.org_information3);

654: AND hoi1.org_information_context = 'CLASS'
655: AND o1.organization_id = hoi2.organization_id
656: AND hoi2.org_information_context = 'NO_NI_EXEMPTION_LIMIT'
657: AND p_date_earned > fnd_date.canonical_to_date(hoi2.org_information2)
658: AND trunc(add_months(p_date_earned,12),'Y') < fnd_date.canonical_to_date(hoi2.org_information3);
659: --
660: rg_Local_Unit_EL_after csr_Local_Unit_EL_after%ROWTYPE;
661: --
662: Cursor csr_Legal_Emp_EL_after(csr_v_legal_emp_id hr_organization_information.organization_id%TYPE

Line 675: AND p_date_earned > fnd_date.canonical_to_date(hoi2.org_information2)

671: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'
672: AND hoi1.org_information_context = 'CLASS'
673: AND o1.organization_id = hoi2.organization_id
674: AND hoi2.org_information_context ='NO_NI_EXEMPTION_LIMIT'
675: AND p_date_earned > fnd_date.canonical_to_date(hoi2.org_information2)
676: AND trunc(add_months(p_date_earned,12),'Y') < fnd_date.canonical_to_date(hoi2.org_information3);
677: --
678: rg_Legal_Emp_EL_after csr_Legal_Emp_EL_after%ROWTYPE;
679: --

Line 676: AND trunc(add_months(p_date_earned,12),'Y') < fnd_date.canonical_to_date(hoi2.org_information3);

672: AND hoi1.org_information_context = 'CLASS'
673: AND o1.organization_id = hoi2.organization_id
674: AND hoi2.org_information_context ='NO_NI_EXEMPTION_LIMIT'
675: AND p_date_earned > fnd_date.canonical_to_date(hoi2.org_information2)
676: AND trunc(add_months(p_date_earned,12),'Y') < fnd_date.canonical_to_date(hoi2.org_information3);
677: --
678: rg_Legal_Emp_EL_after csr_Legal_Emp_EL_after%ROWTYPE;
679: --
680: CURSOR csr_global_value (p_global_name VARCHAR2 , p_date_earned DATE) IS

Line 752: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(l_reporting_end_date));

748: FETCH csr_LE_addr INTO rg_LE_addr;
749: CLOSE csr_LE_addr;
750: --
751: pay_balance_pkg.set_context('TAX_UNIT_ID', l_legal_employer_id);
752: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(l_reporting_end_date));
753: --
754: IF l_local_unit_id IS NOT NULL THEN
755: /* Pick up the Exemption Limit details belonging to Local Unit*/
756: pay_balance_pkg.set_context('LOCAL_UNIT_ID', l_local_unit_id);