APPS.PER_CN_ORG_INFO_LEG_HOOK dependencies on HR_ORGANIZATION_INFORMATION

Line 45: FROM hr_organization_information

41:
42: CURSOR csr_check_cont_base_setup
43: IS
44: SELECT count(org_information_id)
45: FROM hr_organization_information
46: WHERE org_information_context= 'PER_CONT_AREA_CONT_BASE_CN'
47: AND org_information1 = p_org_information1
48: AND org_information2 = p_org_information2
49: AND nvl(org_information3,'X') = nvl(p_org_information3,'X')

Line 60: FROM hr_organization_information

56:
57: CURSOR csr_check_phf_si_rates_setup
58: IS
59: SELECT count(org_information_id)
60: FROM hr_organization_information
61: WHERE org_information_context='PER_CONT_AREA_PHF_SI_RATES_CN'
62: AND org_information1 = p_org_information1
63: AND nvl(org_information2,'X') = nvl(p_org_information2,'X')
64: AND org_information3 = p_org_information3

Line 75: FROM hr_organization_information

71:
72: CURSOR csr_future_rec_cont_base
73: IS
74: SELECT min(fnd_date.canonical_to_date(org_information15))
75: FROM hr_organization_information
76: WHERE org_information1 = p_org_information1
77: AND org_information2 = p_org_information2
78: AND nvl(org_information3,'X') = nvl(p_org_information3,'X')
79: AND org_information_context='PER_CONT_AREA_CONT_BASE_CN'

Line 89: FROM hr_organization_information

85:
86: CURSOR csr_future_rec_phfsi_base
87: IS
88: SELECT min(fnd_date.canonical_to_date(org_information10))
89: FROM hr_organization_information
90: WHERE org_information1 = p_org_information1
91: AND NVL(org_information2,'X') = NVL(p_org_information2,'X')
92: AND nvl(org_information3,'X') = nvl(p_org_information3,'X')
93: AND org_information_context='PER_CONT_AREA_PHF_SI_RATES_CN'

Line 199: FROM hr_organization_information hoi

195:
196: CURSOR c_term_info_setup
197: IS
198: SELECT COUNT (org_information_id)
199: FROM hr_organization_information hoi
200: WHERE hoi.organization_id = p_organization_id
201: AND hoi.org_information_context = p_org_info_type_code
202: AND p_effective_start_date BETWEEN
203: fnd_date.canonical_to_date(NVL(hoi.org_information3,'1900/01/01 00:00:00'))

Line 211: FROM hr_organization_information

207:
208: CURSOR c_fut_term_info_setup
209: IS
210: SELECT min(fnd_date.canonical_to_date(org_information3))
211: FROM hr_organization_information
212: WHERE org_information_context= p_org_info_type_code
213: AND NVL(org_information_id,-1) <> NVL(p_org_information_id,-1)
214: AND fnd_date.canonical_to_date(NVL(org_information3,'1900/01/01 00:00:00')) > p_effective_start_date
215: AND organization_id = p_organization_id

Line 279: FROM hr_organization_information hoi

275:
276: CURSOR c_phf_high_limit_exempt_setup
277: IS
278: SELECT COUNT (org_information_id) -- Y/N
279: FROM hr_organization_information hoi
280: WHERE hoi.organization_id = p_organization_id
281: AND hoi.org_information_context = 'PER_PHF_STAT_INFO_CN'
282: AND hoi.org_information1 = p_org_information1
283: AND (org_information_id <>p_org_information_id OR p_org_information_id IS NULL);

Line 350: FROM hr_organization_information hoi

346:
347: CURSOR c_phf_high_limit_exempt_setup
348: IS
349: SELECT COUNT (org_information_id)
350: FROM hr_organization_information hoi
351: WHERE hoi.organization_id = p_organization_id
352: AND hoi.org_information_context = 'PER_ENN_ANN_TAX_CN'
353: AND hoi.org_information1 = p_org_information1;
354:

Line 835: FROM hr_organization_information

831: ,org_information17
832: ,org_information18
833: ,org_information19
834: ,org_information20
835: FROM hr_organization_information
836: WHERE org_information_id = p_org_information_id;
837:
838: BEGIN
839: