APPS.PAY_NO_EMP_CONT_2007 dependencies on HR_ORGANIZATION_INFORMATION

Line 75: from HR_ORGANIZATION_INFORMATION

71:
72: -- cursor to get Status and Report Separately from Local Unit
73: cursor get_lu_details(l_local_unit_id NUMBER) IS
74: select ORG_INFORMATION4 status , ORG_INFORMATION5 report_sep , ORG_INFORMATION6 lu_tax_mun
75: from HR_ORGANIZATION_INFORMATION
76: where ORGANIZATION_ID = l_local_unit_id
77: and org_information_context = 'NO_LOCAL_UNIT_DETAILS';
78:
79:

Line 161: from HR_ORGANIZATION_INFORMATION

157:
158: -- cursor to get STATUS from Legal Employer
159: cursor get_le_status(p_tax_unit_id pay_assignment_actions.TAX_UNIT_ID%TYPE) IS
160: select ORG_INFORMATION3
161: from HR_ORGANIZATION_INFORMATION
162: where ORGANIZATION_ID = p_tax_unit_id
163: and org_information_context = 'NO_LEGAL_EMPLOYER_DETAILS';
164:
165: /*

Line 169: from hr_organization_information

165: /*
166: -- cursor to get the Exemption Limit of Legal Employer or Local Unit
167: cursor csr_get_exemption_limit (p_org_id NUMBER , p_date_earned DATE) is
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:

Line 185: from hr_organization_information

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);
189:

Line 198: from hr_organization_information

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) <= add_months(trunc(p_date_earned,'YYYY')-1,12)
202: and fnd_date.canonical_to_date(ORG_INFORMATION3) >= trunc(p_date_earned,'YYYY');