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.HRBISORGPARAMS dependencies on PER_ORG_STRUCTURE_VERSIONS

Line 70: from per_org_structure_versions osv

66: cursor c_ost
67: ( cp_osv_id Number )
68: is
69: select osv.organization_structure_id
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;

Line 100: , per_org_structure_versions 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);
104:

Line 105: l_osv_id per_org_structure_versions.org_structure_version_id%TYPE;

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);
104:
105: l_osv_id per_org_structure_versions.org_structure_version_id%TYPE;
106:
107: begin
108: open c_osv (p_organization_structure_id);
109: fetch c_osv into l_osv_id;

Line 151: , per_org_structure_versions osv

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
155: and osv.org_structure_version_id = ose.org_structure_version_id

Line 500: , per_org_structure_versions osv

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
504: and trunc(sysdate) between nvl(osv.date_from,trunc(sysdate)) and nvl(osv.date_to,sysdate)