APPS.GHR_BREAKDOWN_RPT dependencies on PER_ORG_STRUCTURE_VERSIONS

Line 9: l_org_strver_id per_org_structure_versions.org_structure_version_id%TYPE;

5: l_by_clause VARCHAR2(80) := 'GRADE/LEVEL';
6: l_within_clause VARCHAR2(80) := 'PAY_PLAN';
7: l_for_clause NUMBER(3) := 0;
8: l_extra_clause VARCHAR2(80);
9: l_org_strver_id per_org_structure_versions.org_structure_version_id%TYPE;
10:
11: PROCEDURE Set_Effective_Date(p_date IN DATE)
12: IS
13: BEGIN

Line 535: p_org_structure_version_id per_org_structure_versions.org_structure_version_id%TYPE)

531: END;
532:
533: -- Given and org structure version iud return the org structure name (ie hierarchy)
534: FUNCTION get_org_struct_name(
535: p_org_structure_version_id per_org_structure_versions.org_structure_version_id%TYPE)
536: RETURN VARCHAR2 IS
537:
538: CURSOR cur_hier IS
539: SELECT s.name

Line 541: ,per_org_structure_versions v

537:
538: CURSOR cur_hier IS
539: SELECT s.name
540: FROM per_organization_structures s
541: ,per_org_structure_versions v
542: WHERE v.org_structure_version_id = p_org_structure_version_id
543: AND v.organization_structure_id = s.organization_structure_id;
544:
545: BEGIN