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

Line 172: and p_date_earned between fnd_date.canonical_to_date(ORG_INFORMATION2) and fnd_date.canonical_to_date(ORG_INFORMATION3);

168: select nvl(to_number(ORG_INFORMATION1),0)
169: from hr_organization_information
170: where ORGANIZATION_ID = p_org_id
171: and ORG_INFORMATION_CONTEXT = 'NO_NI_EXEMPTION_LIMIT'
172: and p_date_earned between fnd_date.canonical_to_date(ORG_INFORMATION2) and fnd_date.canonical_to_date(ORG_INFORMATION3);
173:
174: */
175:
176: -- 2007 Legislative changes for Economic support to Employer

Line 188: and p_date_earned between fnd_date.canonical_to_date(ORG_INFORMATION2) and fnd_date.canonical_to_date(ORG_INFORMATION3);

184: ,nvl(fnd_number.canonical_to_number(ORG_INFORMATION4),0) economic_aid
185: from hr_organization_information
186: where ORGANIZATION_ID = p_org_id
187: and ORG_INFORMATION_CONTEXT = 'NO_NI_EXEMPTION_LIMIT'
188: and p_date_earned between fnd_date.canonical_to_date(ORG_INFORMATION2) and fnd_date.canonical_to_date(ORG_INFORMATION3);
189:
190: */
191:
192: -- cursor to get the Exemption Limit And Economic Aid of Legal Employer or Local Unit

Line 201: and fnd_date.canonical_to_date(ORG_INFORMATION2) <= add_months(trunc(p_date_earned,'YYYY')-1,12)

197: ,sum(nvl(fnd_number.canonical_to_number(ORG_INFORMATION4),0)) economic_aid
198: from hr_organization_information
199: where ORGANIZATION_ID = p_org_id
200: and ORG_INFORMATION_CONTEXT = 'NO_NI_EXEMPTION_LIMIT'
201: and fnd_date.canonical_to_date(ORG_INFORMATION2) <= add_months(trunc(p_date_earned,'YYYY')-1,12)
202: and fnd_date.canonical_to_date(ORG_INFORMATION3) >= trunc(p_date_earned,'YYYY');
203: --and fnd_date.canonical_to_date(ORG_INFORMATION2) between trunc(p_date_earned,'YYYY') and add_months(trunc(p_date_earned,'YYYY')-1,12)
204: --and fnd_date.canonical_to_date(ORG_INFORMATION3) between trunc(p_date_earned,'YYYY') and add_months(trunc(p_date_earned,'YYYY')-1,12);
205:

Line 202: and fnd_date.canonical_to_date(ORG_INFORMATION3) >= trunc(p_date_earned,'YYYY');

198: from hr_organization_information
199: where ORGANIZATION_ID = p_org_id
200: and ORG_INFORMATION_CONTEXT = 'NO_NI_EXEMPTION_LIMIT'
201: and fnd_date.canonical_to_date(ORG_INFORMATION2) <= add_months(trunc(p_date_earned,'YYYY')-1,12)
202: and fnd_date.canonical_to_date(ORG_INFORMATION3) >= trunc(p_date_earned,'YYYY');
203: --and fnd_date.canonical_to_date(ORG_INFORMATION2) between trunc(p_date_earned,'YYYY') and add_months(trunc(p_date_earned,'YYYY')-1,12)
204: --and fnd_date.canonical_to_date(ORG_INFORMATION3) between trunc(p_date_earned,'YYYY') and add_months(trunc(p_date_earned,'YYYY')-1,12);
205:
206: ----------------------------------Function declarations----------------------------------------------

Line 203: --and fnd_date.canonical_to_date(ORG_INFORMATION2) between trunc(p_date_earned,'YYYY') and add_months(trunc(p_date_earned,'YYYY')-1,12)

199: where ORGANIZATION_ID = p_org_id
200: and ORG_INFORMATION_CONTEXT = 'NO_NI_EXEMPTION_LIMIT'
201: and fnd_date.canonical_to_date(ORG_INFORMATION2) <= add_months(trunc(p_date_earned,'YYYY')-1,12)
202: and fnd_date.canonical_to_date(ORG_INFORMATION3) >= trunc(p_date_earned,'YYYY');
203: --and fnd_date.canonical_to_date(ORG_INFORMATION2) between trunc(p_date_earned,'YYYY') and add_months(trunc(p_date_earned,'YYYY')-1,12)
204: --and fnd_date.canonical_to_date(ORG_INFORMATION3) between trunc(p_date_earned,'YYYY') and add_months(trunc(p_date_earned,'YYYY')-1,12);
205:
206: ----------------------------------Function declarations----------------------------------------------
207:

Line 204: --and fnd_date.canonical_to_date(ORG_INFORMATION3) between trunc(p_date_earned,'YYYY') and add_months(trunc(p_date_earned,'YYYY')-1,12);

200: and ORG_INFORMATION_CONTEXT = 'NO_NI_EXEMPTION_LIMIT'
201: and fnd_date.canonical_to_date(ORG_INFORMATION2) <= add_months(trunc(p_date_earned,'YYYY')-1,12)
202: and fnd_date.canonical_to_date(ORG_INFORMATION3) >= trunc(p_date_earned,'YYYY');
203: --and fnd_date.canonical_to_date(ORG_INFORMATION2) between trunc(p_date_earned,'YYYY') and add_months(trunc(p_date_earned,'YYYY')-1,12)
204: --and fnd_date.canonical_to_date(ORG_INFORMATION3) between trunc(p_date_earned,'YYYY') and add_months(trunc(p_date_earned,'YYYY')-1,12);
205:
206: ----------------------------------Function declarations----------------------------------------------
207:
208: