APPS.PAY_NO_ARCHIVE_RSEA dependencies on FND_DATE

Line 525: AND p_date_earned between fnd_date.canonical_to_date(hoi2.org_information2)

521: AND hoi1.org_information1 = 'NO_LOCAL_UNIT'
522: AND hoi1.org_information_context = 'CLASS'
523: AND o1.organization_id =hoi2.organization_id
524: AND hoi2.ORG_INFORMATION_CONTEXT='NO_NI_EXEMPTION_LIMIT'
525: AND p_date_earned between fnd_date.canonical_to_date(hoi2.org_information2)
526: AND fnd_date.canonical_to_date(hoi2.org_information3);
527:
528: rg_Local_Unit_EL csr_Local_Unit_EL%rowtype;
529:

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

522: AND hoi1.org_information_context = 'CLASS'
523: AND o1.organization_id =hoi2.organization_id
524: AND hoi2.ORG_INFORMATION_CONTEXT='NO_NI_EXEMPTION_LIMIT'
525: AND p_date_earned between fnd_date.canonical_to_date(hoi2.org_information2)
526: AND fnd_date.canonical_to_date(hoi2.org_information3);
527:
528: rg_Local_Unit_EL csr_Local_Unit_EL%rowtype;
529:
530: Cursor csr_Legal_Emp_EL( csr_v_legal_emp_id hr_organization_information.ORGANIZATION_ID%TYPE, p_date_earned DATE)

Line 543: AND p_date_earned between fnd_date.canonical_to_date(hoi2.org_information2)

539: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'
540: AND hoi1.org_information_context = 'CLASS'
541: AND o1.organization_id =hoi2.organization_id
542: AND hoi2.ORG_INFORMATION_CONTEXT='NO_NI_EXEMPTION_LIMIT'
543: AND p_date_earned between fnd_date.canonical_to_date(hoi2.org_information2)
544: AND fnd_date.canonical_to_date(hoi2.org_information3);
545:
546: rg_Legal_Emp_EL csr_Legal_Emp_EL%rowtype;
547:

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

540: AND hoi1.org_information_context = 'CLASS'
541: AND o1.organization_id =hoi2.organization_id
542: AND hoi2.ORG_INFORMATION_CONTEXT='NO_NI_EXEMPTION_LIMIT'
543: AND p_date_earned between fnd_date.canonical_to_date(hoi2.org_information2)
544: AND fnd_date.canonical_to_date(hoi2.org_information3);
545:
546: rg_Legal_Emp_EL csr_Legal_Emp_EL%rowtype;
547:
548: /* End of Cursors */

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

897:
898: /* Setting contexts for balances*/
899: pay_balance_pkg.set_context('TAX_UNIT_ID',l_legal_employer_id);
900: pay_balance_pkg.set_context('JURISDICTION_CODE',l_municipal_no);
901: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(l_reporting_end_date));
902:
903: IF g_debug THEN
904: hr_utility.set_location(' Inside Procedure RANGE_CODE',50);
905: END IF;