APPS.HRBISORGPARAMS dependencies on PER_ORGANIZATION_STRUCTURES

Line 74: l_ost_id per_organization_structures.organization_structure_id%TYPE;

70: from per_org_structure_versions osv
71: where osv.org_structure_version_id = cp_osv_id
72: and trunc(sysdate) between nvl(osv.date_from,trunc(sysdate)) and nvl(osv.date_to,sysdate);
73:
74: l_ost_id per_organization_structures.organization_structure_id%TYPE;
75:
76: begin
77: open c_ost (p_org_structure_version_id);
78: fetch c_ost into l_ost_id;

Line 99: from per_organization_structures ost

95: cursor c_osv
96: ( cp_ost_id Number )
97: is
98: select osv.org_structure_version_id
99: from per_organization_structures ost
100: , per_org_structure_versions osv
101: where ost.organization_structure_id = cp_ost_id
102: and ost.organization_structure_id = osv.organization_structure_id
103: and trunc(sysdate) between nvl(osv.date_from,trunc(sysdate)) and nvl(osv.date_to,sysdate);

Line 150: from per_organization_structures ost

146: cursor c_toporg
147: ( cp_ost_id Number )
148: is
149: select ose.organization_id_parent
150: from per_organization_structures ost
151: , per_org_structure_versions osv
152: , per_org_structure_elements ose
153: where ost.organization_structure_id = cp_ost_id
154: and ost.organization_structure_id = osv.organization_structure_id

Line 499: from per_organization_structures ost

495: select distinct
496: ost.organization_structure_id ost_id
497: , ose.organization_id_parent top_org_id
498: , ose.org_structure_version_id ver_id
499: from per_organization_structures ost
500: , per_org_structure_versions osv
501: , per_org_structure_elements ose
502: where ost.organization_structure_id = osv.organization_structure_id
503: and osv.org_structure_version_id = ose.org_structure_version_id