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.PQP_NL_PENSION_EXTRACTS dependencies on PER_ORG_STRUCTURE_VERSIONS_V

Line 2739: FROM per_org_structure_versions_v pos,

2735: -- If it is attached get the valid version as of the effective date.
2736: -- If a valid version is not found then do nothing.
2737: CURSOR c_get_org_hierarchy IS
2738: SELECT pos.org_structure_version_id
2739: FROM per_org_structure_versions_v pos,
2740: hr_organization_information hoi
2741: WHERE hoi.organization_id = p_business_group_id
2742: AND To_Number(hoi.org_information1) = pos.organization_structure_id
2743: AND Trunc(p_effective_date) BETWEEN date_from

Line 2749: c_org_struct_ver_id per_org_structure_versions_v.org_structure_version_id%TYPE

2745: AND hoi.org_information_context = 'NL_BG_INFO';
2746:
2747: --Cursor to fetch immediate children of org
2748: CURSOR csr_get_children(c_org_id hr_all_organization_units.organization_id%TYPE,
2749: c_org_struct_ver_id per_org_structure_versions_v.org_structure_version_id%TYPE
2750: ) IS
2751: SELECT os.organization_id_child
2752: FROM (SELECT *
2753: FROM per_org_structure_elements a

Line 2768: c_org_struct_ver_id per_org_structure_versions_v.org_structure_version_id%TYPE

2764: AND org_information3 IS NOT NULL
2765: AND org_information4 IS NOT NULL;
2766:
2767: CURSOR csr_any_child_exists(c_org_id hr_all_organization_units.organization_id%TYPE,
2768: c_org_struct_ver_id per_org_structure_versions_v.org_structure_version_id%TYPE
2769: ) IS
2770: SELECT 'x'
2771: FROM (SELECT *
2772: FROM per_org_structure_elements a

Line 2778: l_org_struct_ver_id per_org_structure_versions_v.org_structure_version_id%TYPE;

2774: WHERE os.organization_id_parent = c_org_id;
2775:
2776: l_error_message Varchar2(10);
2777: l_proc_name Varchar2(150) := g_proc_name ||'Set_Er_Children';
2778: l_org_struct_ver_id per_org_structure_versions_v.org_structure_version_id%TYPE;
2779: l_tax_org_flag varchar2(1);
2780: l_child_org_flag varchar2(1);
2781: BEGIN
2782: Hr_Utility.set_location(' Entering ' || l_proc_name , 30);

Line 5720: FROM per_org_structure_versions_v pos,

5716: -- If it is attached get the valid version as of the effective date.
5717: -- If a valid version is not found then do nothing.
5718: CURSOR c_get_org_hierarchy IS
5719: SELECT pos.org_structure_version_id
5720: FROM per_org_structure_versions_v pos,
5721: hr_organization_information hoi
5722: WHERE hoi.organization_id = p_business_group_id
5723: AND To_Number(hoi.org_information1) = pos.organization_structure_id
5724: AND Trunc(p_effective_date) BETWEEN date_from

Line 6869: FROM per_org_structure_versions_v

6865: -- Cursor to find the valid version id for the particular named hierarchy
6866: --
6867: CURSOR c_find_ver_frm_hierarchy(c_hierarchy_id IN NUMBER) IS
6868: SELECT org_structure_version_id
6869: FROM per_org_structure_versions_v
6870: WHERE organization_structure_id = c_hierarchy_id
6871: AND g_extract_params(p_business_group_id).extract_end_date BETWEEN date_from
6872: AND nvl(date_to,hr_api.g_eot);
6873:

Line 6879: FROM per_org_structure_versions_v

6875: -- Cursor to find the valid version id for a particular business group
6876: --
6877: CURSOR c_find_ver_frm_bg IS
6878: SELECT org_structure_version_id
6879: FROM per_org_structure_versions_v
6880: WHERE business_group_id = p_business_group_id
6881: AND g_extract_params(p_business_group_id).extract_end_date BETWEEN date_from
6882: AND nvl( date_to,hr_api.g_eot);
6883: --

Line 6918: l_version_id per_org_structure_versions_v.org_structure_version_id%TYPE DEFAULT NULL;

6914:
6915: l_old_er_num ben_ext_chg_evt_log.old_val1%TYPE := '-1';
6916: l_new_er_num hr_organization_information.org_information2%TYPE := '-1';
6917: l_org_info_id hr_organization_information.org_information_id%TYPE;
6918: l_version_id per_org_structure_versions_v.org_structure_version_id%TYPE DEFAULT NULL;
6919: l_proc_name VARCHAR2(150) := g_proc_name ||'Get_ABP_ER_Num';
6920: l_ret_val NUMBER := -1;
6921: l_org_id NUMBER;
6922: l_named_hierarchy NUMBER;

Line 9359: FROM per_org_structure_versions_v

9355:
9356: --Cursor to find the valid version id for the particular named hierarchy
9357: CURSOR c_find_ver_frm_hierarchy(c_hierarchy_id IN Number) IS
9358: SELECT ORG_STRUCTURE_VERSION_ID
9359: FROM per_org_structure_versions_v
9360: WHERE organization_structure_id = c_hierarchy_id
9361: AND p_effective_date BETWEEN date_from
9362: AND Nvl(date_to,Hr_Api.g_eot);
9363:

Line 9367: FROM per_org_structure_versions_v

9363:
9364: --Cursor to find the valid version id for a particular business group
9365: CURSOR c_find_ver_frm_bg IS
9366: SELECT ORG_STRUCTURE_VERSION_ID
9367: FROM per_org_structure_versions_v
9368: WHERE business_group_id = p_business_group_id
9369: AND p_effective_date BETWEEN date_from
9370: AND Nvl( date_to,Hr_Api.g_eot);
9371:

Line 9422: l_version_id per_org_structure_versions_v.org_structure_version_id%TYPE DEFAULT NULL;

9418:
9419: l_proc_name Varchar2(150) := 'Record40_30_Disp_Criteria';
9420: l_return_value Number := -1;
9421: l_named_hierarchy Number;
9422: l_version_id per_org_structure_versions_v.org_structure_version_id%TYPE DEFAULT NULL;
9423: l_rows_exist Number := 0;
9424: l_asg_rows_exist Number;
9425: l_org_rows_exist Number;
9426: l_org_id Number;

Line 9648: l_version_id per_org_structure_versions_v.org_structure_version_id%TYPE DEFAULT NULL;

9644: l_org_id hr_all_organization_units.organization_id%TYPE;
9645: l_ret_value Number := 0; --return
9646: l_org_info_id hr_organization_information.org_information_id%TYPE;
9647: l_named_hierarchy Number;
9648: l_version_id per_org_structure_versions_v.org_structure_version_id%TYPE DEFAULT NULL;
9649: l_loop_again Number;
9650: l_is_org_info_valid Varchar2(1);
9651:
9652: --Cursor to find the org id from the assignment id

Line 9670: FROM per_org_structure_versions_v

9666:
9667: --Cursor to find the valid version id for the particular named hierarchy
9668: CURSOR c_find_ver_frm_hierarchy(c_hierarchy_id IN Number) IS
9669: SELECT ORG_STRUCTURE_VERSION_ID
9670: FROM per_org_structure_versions_v
9671: WHERE organization_structure_id = c_hierarchy_id
9672: AND p_date_earned BETWEEN date_from
9673: AND Nvl(date_to,Hr_Api.g_eot);
9674:

Line 9678: FROM per_org_structure_versions_v

9674:
9675: --Cursor to find the valid version id for a particular business group
9676: CURSOR c_find_ver_frm_bg IS
9677: SELECT ORG_STRUCTURE_VERSION_ID
9678: FROM per_org_structure_versions_v
9679: WHERE business_group_id = p_business_group_id
9680: AND p_date_earned BETWEEN date_from
9681: AND Nvl( date_to,Hr_Api.g_eot);
9682:

Line 9885: FROM per_org_structure_versions_v

9881:
9882: --Cursor to find the valid version id for the particular named hierarchy
9883: CURSOR c_find_ver_frm_hierarchy(c_hierarchy_id IN Number) IS
9884: SELECT ORG_STRUCTURE_VERSION_ID
9885: FROM per_org_structure_versions_v
9886: WHERE organization_structure_id = c_hierarchy_id
9887: AND p_effective_date BETWEEN date_from
9888: AND Nvl(date_to,Hr_Api.g_eot);
9889:

Line 9893: FROM per_org_structure_versions_v

9889:
9890: --Cursor to find the valid version id for a particular business group
9891: CURSOR c_find_ver_frm_bg IS
9892: SELECT ORG_STRUCTURE_VERSION_ID
9893: FROM per_org_structure_versions_v
9894: WHERE business_group_id = p_business_group_id
9895: AND p_effective_date BETWEEN date_from
9896: AND Nvl( date_to,Hr_Api.g_eot);
9897:

Line 9947: l_version_id per_org_structure_versions_v.org_structure_version_id%TYPE DEFAULT NULL;

9943:
9944: l_proc_name Varchar2(150) := g_proc_name ||'get_fur_participation_dates';
9945: l_return_value Number := -1;
9946: l_named_hierarchy Number;
9947: l_version_id per_org_structure_versions_v.org_structure_version_id%TYPE DEFAULT NULL;
9948: l_asg_rows_exist Number;
9949: l_org_rows_exist Number;
9950: l_org_id Number;
9951: i Number := 0;

Line 11259: per_org_structure_versions_v.org_structure_version_id%TYPE DEFAULT NULL;

11255: l_proc_name VARCHAR2(150) := g_proc_name ||'get_rec05_participation';
11256: l_return_value NUMBER := -1;
11257: l_named_hierarchy NUMBER;
11258: l_version_id
11259: per_org_structure_versions_v.org_structure_version_id%TYPE DEFAULT NULL;
11260: l_asg_rows_exist NUMBER;
11261: l_org_rows_exist NUMBER;
11262: l_kind VARCHAR2(30) := 'WNE';
11263: l_value VARCHAR2(30) := '100';

Line 12275: FROM per_org_structure_versions_v

12271:
12272: --Cursor to find the valid version id for the particular named hierarchy
12273: CURSOR c_find_ver_frm_hierarchy(c_hierarchy_id IN Number) IS
12274: SELECT ORG_STRUCTURE_VERSION_ID
12275: FROM per_org_structure_versions_v
12276: WHERE organization_structure_id = c_hierarchy_id
12277: AND p_effective_date BETWEEN date_from
12278: AND Nvl(date_to,Hr_Api.g_eot);
12279:

Line 12283: FROM per_org_structure_versions_v

12279:
12280: --Cursor to find the valid version id for a particular business group
12281: CURSOR c_find_ver_frm_bg IS
12282: SELECT ORG_STRUCTURE_VERSION_ID
12283: FROM per_org_structure_versions_v
12284: WHERE business_group_id = p_business_group_id
12285: AND p_effective_date BETWEEN date_from
12286: AND Nvl( date_to,Hr_Api.g_eot);
12287:

Line 12337: l_version_id per_org_structure_versions_v.org_structure_version_id%TYPE DEFAULT NULL;

12333:
12334: l_proc_name Varchar2(150) := g_proc_name ||'get_ipap_participation_dates';
12335: l_return_value Number := -1;
12336: l_named_hierarchy Number;
12337: l_version_id per_org_structure_versions_v.org_structure_version_id%TYPE DEFAULT NULL;
12338: l_asg_rows_exist Number;
12339: l_org_rows_exist Number;
12340: l_org_id Number;
12341: i Number := 0;