DBA Data[Home] [Help]

APPS.GHR_MASS_ACTIONS_PKG dependencies on GHR_POIS

Line 338: from ghr_pois gpoi,

334: l_count number;
335:
336: Cursor c_gbx is
337: select gbx.groupbox_id gpid, gbx.routing_group_id rgpid
338: from ghr_pois gpoi,
339: ghr_groupboxes gbx,
340: ghr_routing_groups rgp
341: where gbx.groupbox_id = gpoi.groupbox_id
342: and gpoi.personnel_office_id = l_personnel_office_id

Line 413: FROM ghr_pois

409:
410: CURSOR c_get_person_id(c_personnel_office_id varchar2)
411: IS
412: SELECT person_id
413: FROM ghr_pois
414: WHERE personnel_office_id = c_personnel_office_id;
415:
416: l_person_id per_people_f.person_id%type;
417: