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 626: AND p_date_earned BETWEEN fnd_date.canonical_to_date(hoi2.org_information2)

622: AND hoi1.org_information1 = 'NO_LOCAL_UNIT'
623: AND hoi1.org_information_context = 'CLASS'
624: AND o1.organization_id = hoi2.organization_id
625: AND hoi2.org_information_context = 'NO_NI_EXEMPTION_LIMIT'
626: AND p_date_earned BETWEEN fnd_date.canonical_to_date(hoi2.org_information2)
627: AND fnd_date.canonical_to_date(hoi2.org_information3);
628: --
629: Cursor csr_Legal_Emp_EA(csr_v_legal_emp_id hr_organization_information.organization_id%TYPE
630: ,p_date_earned DATE) IS

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

623: AND hoi1.org_information_context = 'CLASS'
624: AND o1.organization_id = hoi2.organization_id
625: AND hoi2.org_information_context = 'NO_NI_EXEMPTION_LIMIT'
626: AND p_date_earned BETWEEN fnd_date.canonical_to_date(hoi2.org_information2)
627: AND fnd_date.canonical_to_date(hoi2.org_information3);
628: --
629: Cursor csr_Legal_Emp_EA(csr_v_legal_emp_id hr_organization_information.organization_id%TYPE
630: ,p_date_earned DATE) IS
631: SELECT to_number(hoi2.org_information4)

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

638: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'
639: AND hoi1.org_information_context = 'CLASS'
640: AND o1.organization_id = hoi2.organization_id
641: AND hoi2.org_information_context ='NO_NI_EXEMPTION_LIMIT'
642: AND p_date_earned BETWEEN fnd_date.canonical_to_date(hoi2.org_information2)
643: AND fnd_date.canonical_to_date(hoi2.org_information3);
644: --
645: CURSOR csr_Local_Unit_EL(csr_v_local_unit_id hr_organization_information.organization_id%TYPE
646: ,p_date_earned DATE) IS

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

639: AND hoi1.org_information_context = 'CLASS'
640: AND o1.organization_id = hoi2.organization_id
641: AND hoi2.org_information_context ='NO_NI_EXEMPTION_LIMIT'
642: AND p_date_earned BETWEEN fnd_date.canonical_to_date(hoi2.org_information2)
643: AND fnd_date.canonical_to_date(hoi2.org_information3);
644: --
645: CURSOR csr_Local_Unit_EL(csr_v_local_unit_id hr_organization_information.organization_id%TYPE
646: ,p_date_earned DATE) IS
647: SELECT SUM(hoi2.org_information1) exempt_limit

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

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

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

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

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

674: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'
675: AND hoi1.org_information_context = 'CLASS'
676: AND o1.organization_id = hoi2.organization_id
677: AND hoi2.org_information_context ='NO_NI_EXEMPTION_LIMIT'
678: AND trunc(p_date_earned,'Y') >= fnd_date.canonical_to_date(hoi2.org_information2)
679: AND trunc(add_months(p_date_earned,12),'Y') < fnd_date.canonical_to_date(hoi2.org_information3);
680: --
681: rg_Legal_Emp_EL csr_Legal_Emp_EL%ROWTYPE;
682: --

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

675: AND hoi1.org_information_context = 'CLASS'
676: AND o1.organization_id = hoi2.organization_id
677: AND hoi2.org_information_context ='NO_NI_EXEMPTION_LIMIT'
678: AND trunc(p_date_earned,'Y') >= fnd_date.canonical_to_date(hoi2.org_information2)
679: AND trunc(add_months(p_date_earned,12),'Y') < fnd_date.canonical_to_date(hoi2.org_information3);
680: --
681: rg_Legal_Emp_EL csr_Legal_Emp_EL%ROWTYPE;
682: --
683: CURSOR csr_Local_Unit_EL_after(csr_v_local_unit_id hr_organization_information.organization_id%TYPE

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

692: AND hoi1.org_information1 = 'NO_LOCAL_UNIT'
693: AND hoi1.org_information_context = 'CLASS'
694: AND o1.organization_id = hoi2.organization_id
695: AND hoi2.org_information_context = 'NO_NI_EXEMPTION_LIMIT'
696: AND p_date_earned > fnd_date.canonical_to_date(hoi2.org_information2)
697: AND trunc(add_months(p_date_earned,12),'Y') < fnd_date.canonical_to_date(hoi2.org_information3);
698: --
699: rg_Local_Unit_EL_after csr_Local_Unit_EL_after%ROWTYPE;
700: --

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

693: AND hoi1.org_information_context = 'CLASS'
694: AND o1.organization_id = hoi2.organization_id
695: AND hoi2.org_information_context = 'NO_NI_EXEMPTION_LIMIT'
696: AND p_date_earned > fnd_date.canonical_to_date(hoi2.org_information2)
697: AND trunc(add_months(p_date_earned,12),'Y') < fnd_date.canonical_to_date(hoi2.org_information3);
698: --
699: rg_Local_Unit_EL_after csr_Local_Unit_EL_after%ROWTYPE;
700: --
701: Cursor csr_Legal_Emp_EL_after(csr_v_legal_emp_id hr_organization_information.organization_id%TYPE

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

710: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'
711: AND hoi1.org_information_context = 'CLASS'
712: AND o1.organization_id = hoi2.organization_id
713: AND hoi2.org_information_context ='NO_NI_EXEMPTION_LIMIT'
714: AND p_date_earned > fnd_date.canonical_to_date(hoi2.org_information2)
715: AND trunc(add_months(p_date_earned,12),'Y') < fnd_date.canonical_to_date(hoi2.org_information3);
716: --
717: rg_Legal_Emp_EL_after csr_Legal_Emp_EL_after%ROWTYPE;
718: --

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

711: AND hoi1.org_information_context = 'CLASS'
712: AND o1.organization_id = hoi2.organization_id
713: AND hoi2.org_information_context ='NO_NI_EXEMPTION_LIMIT'
714: AND p_date_earned > fnd_date.canonical_to_date(hoi2.org_information2)
715: AND trunc(add_months(p_date_earned,12),'Y') < fnd_date.canonical_to_date(hoi2.org_information3);
716: --
717: rg_Legal_Emp_EL_after csr_Legal_Emp_EL_after%ROWTYPE;
718: --
719: CURSOR csr_global_value (p_global_name VARCHAR2 , p_date_earned DATE) IS

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

819: FETCH csr_LE_addr INTO rg_LE_addr;
820: CLOSE csr_LE_addr;
821: --
822: pay_balance_pkg.set_context('TAX_UNIT_ID', l_legal_employer_id);
823: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(l_reporting_end_date));
824: --
825: IF l_local_unit_id IS NOT NULL THEN
826: /* Pick up the Exemption Limit details belonging to Local Unit*/
827: pay_balance_pkg.set_context('LOCAL_UNIT_ID', l_local_unit_id);