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_NUMBER

Line 183: select nvl(fnd_number.canonical_to_number(ORG_INFORMATION1),0) exemption_limit

179: -- cursor to get the Exemption Limit of Legal Employer or Local Unit
180:
181: /*
182: cursor csr_get_exemption_limit (p_org_id NUMBER , p_date_earned DATE) is
183: select nvl(fnd_number.canonical_to_number(ORG_INFORMATION1),0) exemption_limit
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'

Line 184: ,nvl(fnd_number.canonical_to_number(ORG_INFORMATION4),0) economic_aid

180:
181: /*
182: cursor csr_get_exemption_limit (p_org_id NUMBER , p_date_earned DATE) is
183: select nvl(fnd_number.canonical_to_number(ORG_INFORMATION1),0) exemption_limit
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);

Line 196: select sum(nvl(fnd_number.canonical_to_number(ORG_INFORMATION1),0)) exemption_limit

192: -- cursor to get the Exemption Limit And Economic Aid of Legal Employer or Local Unit
193: -- modified the cursor to fetch the sum of exemption limit and economic aid values over the entire year
194:
195: cursor csr_get_exemption_limit (p_org_id NUMBER , p_date_earned DATE) is
196: select sum(nvl(fnd_number.canonical_to_number(ORG_INFORMATION1),0)) exemption_limit
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'

Line 197: ,sum(nvl(fnd_number.canonical_to_number(ORG_INFORMATION4),0)) economic_aid

193: -- modified the cursor to fetch the sum of exemption limit and economic aid values over the entire year
194:
195: cursor csr_get_exemption_limit (p_org_id NUMBER , p_date_earned DATE) is
196: select sum(nvl(fnd_number.canonical_to_number(ORG_INFORMATION1),0)) exemption_limit
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)