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
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
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) between trunc(p_date_earned,'YYYY') and add_months(trunc(p_date_earned,'YYYY')-1,12)
202: and fnd_date.canonical_to_date(ORG_INFORMATION3) between trunc(p_date_earned,'YYYY') and add_months(trunc(p_date_earned,'YYYY')-1,12);
203:
204: ----------------------------------Function declarations----------------------------------------------
205:
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) between trunc(p_date_earned,'YYYY') and add_months(trunc(p_date_earned,'YYYY')-1,12)
202: and fnd_date.canonical_to_date(ORG_INFORMATION3) between trunc(p_date_earned,'YYYY') and add_months(trunc(p_date_earned,'YYYY')-1,12);
203:
204: ----------------------------------Function declarations----------------------------------------------
205:
206: