APPS.PQH_LENGTH_OF_SERVICE_PKG dependencies on HR_ORGANIZATION_INFORMATION
Line 54: FROM hr_organization_information
50: SELECT org_information1, -- normal start time
51: org_information2, -- normal end time
52: NVL(org_information3,0), -- normal hours
53: org_information4 -- frequency 54: FROM hr_organization_information 55: WHERE organization_id = p_bg_id
56: AND org_information_context = 'Work Day Information';
57: BEGIN
58: OPEN Csr_bg_norm_hours;