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.PQH_CORPS_EXTRA_INFO_API dependencies on HR_GENERAL

Line 17: AND p_effective_date BETWEEN date_from AND NVL(date_to,hr_general.end_of_time));

13: FROM DUAL
14: WHERE EXISTS (SELECT 1
15: FROM hr_all_organization_units
16: WHERE organization_id = fnd_number.canonical_to_number(p_organization_id)
17: AND p_effective_date BETWEEN date_from AND NVL(date_to,hr_general.end_of_time));
18: l_valid_org varchar2(10) := 'N';
19: CURSOR csr_dup_org_chk IS
20: SELECT 'Y'
21: FROM DUAL

Line 113: AND p_effective_date BETWEEN date_from AND nvl(date_to,hr_general.end_of_time));

109: FROM dual
110: WHERE EXISTS (SELECT 1
111: FROM hr_all_organization_units
112: WHERE organization_id = fnd_number.canonical_to_number(p_institution_id)
113: AND p_effective_date BETWEEN date_from AND nvl(date_to,hr_general.end_of_time));
114: l_valid_institution varchar2(10) :='N';
115: CURSOR csr_chk_dup_exam IS
116: SELECT 'Y'
117: FROM dual

Line 188: AND p_effective_date BETWEEN date_from AND nvl(date_to,hr_general.end_of_time));

184: FROM dual
185: WHERE EXISTS (SELECT 1
186: FROM hr_all_organization_units
187: WHERE organization_id = fnd_number.canonical_to_number(p_institution_id)
188: AND p_effective_date BETWEEN date_from AND nvl(date_to,hr_general.end_of_time));
189: l_valid_institution varchar2(10) :='N';
190: CURSOR csr_dup_train_dtls IS
191: SELECT 'Y'
192: FROM dual