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.GHR_PA_REQUESTS_PKG2 dependencies on HR_ORGANIZATION_INFORMATION

Line 286: FROM hr_organization_information hoi

282: pos.effective_end_date;
283: CURSOR cur_nfc IS
284: SELECT hoi.org_information_context
285: , hoi.org_information6
286: FROM hr_organization_information hoi
287: WHERE hoi.org_information_context = 'GHR_US_ORG_INFORMATION'
288: AND hoi.organization_id = p_bg_id
289: AND hoi.org_information6 = 'Y';
290: BEGIN

Line 316: FROM hr_organization_information hoi

312: and pos.effective_end_date;
313: CURSOR cur_nfc IS
314: SELECT hoi.org_information_context
315: , hoi.org_information6
316: FROM hr_organization_information hoi
317: WHERE hoi.org_information_context = 'GHR_US_ORG_INFORMATION'
318: AND hoi.organization_id = p_bg_id
319: AND hoi.org_information6 = 'Y';
320: BEGIN

Line 386: FROM hr_organization_information hoi

382: AND grd.grade_definition_id = gdf.grade_definition_id;
383: CURSOR cur_nfc IS
384: SELECT hoi.org_information_context
385: , hoi.org_information6
386: FROM hr_organization_information hoi
387: WHERE hoi.org_information_context = 'GHR_US_ORG_INFORMATION'
388: AND hoi.organization_id = p_bg_id
389: AND hoi.org_information6 = 'Y';
390: BEGIN

Line 447: FROM hr_organization_information oi

443: RETURN VARCHAR2 IS
444: --
445: CURSOR cur_org IS
446: SELECT oi.org_information2
447: FROM hr_organization_information oi
448: WHERE oi.organization_id = p_business_group_id
449: AND oi.org_information_context = 'GHR_US_ORG_INFORMATION';
450: BEGIN
451: FOR cur_org_rec IN cur_org LOOP