APPS.PAY_NO_EMP_CONT dependencies on HR_ORGANIZATION_INFORMATION

Line 80: from HR_ORGANIZATION_INFORMATION

76:
77: -- cursor to get Status and Report Separately from Local Unit
78: cursor get_lu_details(l_local_unit_id NUMBER) IS
79: select ORG_INFORMATION4 status , ORG_INFORMATION5 report_sep
80: from HR_ORGANIZATION_INFORMATION
81: where ORGANIZATION_ID = l_local_unit_id
82: and org_information_context = 'NO_LOCAL_UNIT_DETAILS';
83:
84:

Line 218: from HR_ORGANIZATION_INFORMATION

214:
215: -- cursor to get STATUS from Legal Employer
216: cursor get_le_status(p_tax_unit_id pay_assignment_actions.TAX_UNIT_ID%TYPE) IS
217: select ORG_INFORMATION3
218: from HR_ORGANIZATION_INFORMATION
219: where ORGANIZATION_ID = p_tax_unit_id
220: and org_information_context = 'NO_LEGAL_EMPLOYER_DETAILS';
221:
222: /* Bug No. : 4474602 and 4463136 */

Line 227: from hr_organization_information

223:
224: -- cursor to get the Exemption Limit of Legal Employer or Local Unit
225: cursor csr_get_exemption_limit (p_org_id NUMBER , p_date_earned DATE) is
226: select nvl(to_number(ORG_INFORMATION1),0)
227: from hr_organization_information
228: where ORGANIZATION_ID = p_org_id
229: and ORG_INFORMATION_CONTEXT = 'NO_NI_EXEMPTION_LIMIT'
230: and p_date_earned between fnd_date.canonical_to_date(ORG_INFORMATION2) and fnd_date.canonical_to_date(ORG_INFORMATION3);
231: