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.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 197: FROM hr_organization_information hoi

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

Line 209: FROM hr_organization_information

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

Line 277: FROM hr_organization_information hoi

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

Line 741: FROM hr_organization_information

737: ,org_information17
738: ,org_information18
739: ,org_information19
740: ,org_information20
741: FROM hr_organization_information
742: WHERE org_information_id = p_org_information_id;
743:
744: BEGIN
745: