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

Line 189: AND p_effective_date between fnd_date.canonical_to_date(hoi2.org_information1) AND

185: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'
186: AND hoi1.org_information_context = 'CLASS'
187: AND o1.organization_id =hoi2.organization_id
188: AND hoi2.ORG_INFORMATION_CONTEXT='FI_ACCIDENT_PROVIDERS'
189: AND p_effective_date between fnd_date.canonical_to_date(hoi2.org_information1) AND
190: nvl(fnd_date.canonical_to_date(hoi2.org_information2),to_date('31/12/4712','DD/MM/YYYY')) ;
191:
192:
193: CURSOR c_effective_date(p_asg_act_id NUMBER ) IS

Line 190: nvl(fnd_date.canonical_to_date(hoi2.org_information2),to_date('31/12/4712','DD/MM/YYYY')) ;

186: AND hoi1.org_information_context = 'CLASS'
187: AND o1.organization_id =hoi2.organization_id
188: AND hoi2.ORG_INFORMATION_CONTEXT='FI_ACCIDENT_PROVIDERS'
189: AND p_effective_date between fnd_date.canonical_to_date(hoi2.org_information1) AND
190: nvl(fnd_date.canonical_to_date(hoi2.org_information2),to_date('31/12/4712','DD/MM/YYYY')) ;
191:
192:
193: CURSOR c_effective_date(p_asg_act_id NUMBER ) IS
194: SELECT effective_date

Line 224: AND p_effective_date between fnd_date.canonical_to_date(hoi2.org_information1) AND

220: AND hoi1.org_information_context = 'CLASS'
221: AND o1.organization_id =hoi2.organization_id
222: AND hoi2.ORG_INFORMATION_CONTEXT='FI_PENSION_PROVIDERS'
223: AND hoi2.org_information6 = p_pension_num
224: AND p_effective_date between fnd_date.canonical_to_date(hoi2.org_information1) AND
225: nvl(fnd_date.canonical_to_date(hoi2.org_information2),to_date('31/12/4712','DD/MM/YYYY'))
226: AND hoi2.org_information6 IN
227: (
228: SELECT NVL(hoi2.org_information1,0 )

Line 225: nvl(fnd_date.canonical_to_date(hoi2.org_information2),to_date('31/12/4712','DD/MM/YYYY'))

221: AND o1.organization_id =hoi2.organization_id
222: AND hoi2.ORG_INFORMATION_CONTEXT='FI_PENSION_PROVIDERS'
223: AND hoi2.org_information6 = p_pension_num
224: AND p_effective_date between fnd_date.canonical_to_date(hoi2.org_information1) AND
225: nvl(fnd_date.canonical_to_date(hoi2.org_information2),to_date('31/12/4712','DD/MM/YYYY'))
226: AND hoi2.org_information6 IN
227: (
228: SELECT NVL(hoi2.org_information1,0 )
229: FROM hr_organization_units o1