APPS.PQP_NL_ABP_FUNCTIONS dependencies on PER_ORG_STRUCTURE_VERSIONS_V

Line 5533: l_version_id per_org_structure_versions_v.org_structure_version_id%type default null;

5529: l_ret_value number := 0; --return
5530: l_asg_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type;
5531: l_org_info_id hr_organization_information.org_information_id%type;
5532: l_named_hierarchy number;
5533: l_version_id per_org_structure_versions_v.org_structure_version_id%type default null;
5534: l_loop_again number;
5535: l_is_org_info_valid varchar2(1);
5536:
5537: --Cursor to find the org id from the assignment id

Line 5555: from per_org_structure_versions_v

5551:
5552: --Cursor to find the valid version id for the particular named hierarchy
5553: CURSOR c_find_ver_frm_hierarchy(c_hierarchy_id in Number) Is
5554: select ORG_STRUCTURE_VERSION_ID
5555: from per_org_structure_versions_v
5556: where organization_structure_id = c_hierarchy_id
5557: and p_date_earned between date_from
5558: and nvl(date_to,hr_api.g_eot);
5559:

Line 5563: from per_org_structure_versions_v

5559:
5560: --Cursor to find the valid version id for a particular business group
5561: CURSOR c_find_ver_frm_bg Is
5562: select ORG_STRUCTURE_VERSION_ID
5563: from per_org_structure_versions_v
5564: where business_group_id = p_business_group_id
5565: and p_date_earned between date_from
5566: and nvl( date_to,hr_api.g_eot);
5567:

Line 5741: l_version_id per_org_structure_versions_v.org_structure_version_id%type default null;

5737: l_org_id hr_all_organization_units.organization_id%type;
5738: l_asg_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type;
5739: l_org_info_id hr_organization_information.org_information_id%type;
5740: l_named_hierarchy number;
5741: l_version_id per_org_structure_versions_v.org_structure_version_id%type default null;
5742: l_loop_again number;
5743: l_is_org_info_valid varchar2(1);
5744: l_bgid number;
5745:

Line 5763: from per_org_structure_versions_v

5759:
5760: --Cursor to find the valid version id for the particular named hierarchy
5761: CURSOR c_find_ver_frm_hierarchy(c_hierarchy_id in Number) Is
5762: select ORG_STRUCTURE_VERSION_ID
5763: from per_org_structure_versions_v
5764: where organization_structure_id = c_hierarchy_id
5765: and p_date_earned between date_from
5766: and nvl(date_to,hr_api.g_eot);
5767:

Line 5771: from per_org_structure_versions_v

5767:
5768: --Cursor to find the valid version id for a particular business group
5769: CURSOR c_find_ver_frm_bg(c_bgid in number) Is
5770: select ORG_STRUCTURE_VERSION_ID
5771: from per_org_structure_versions_v
5772: where business_group_id = c_bgid
5773: and p_date_earned between date_from
5774: and nvl( date_to,hr_api.g_eot);
5775:

Line 6472: from per_org_structure_versions_v

6468:
6469: --Cursor to find the valid version id for the particular named hierarchy
6470: CURSOR c_find_ver_frm_hierarchy(c_hierarchy_id in Number) Is
6471: select ORG_STRUCTURE_VERSION_ID
6472: from per_org_structure_versions_v
6473: where organization_structure_id = c_hierarchy_id
6474: and p_date_earned between date_from
6475: and nvl(date_to,hr_api.g_eot);
6476:

Line 6480: from per_org_structure_versions_v

6476:
6477: --Cursor to find the valid version id for a particular business group
6478: CURSOR c_find_ver_frm_bg Is
6479: select ORG_STRUCTURE_VERSION_ID
6480: from per_org_structure_versions_v
6481: where business_group_id = p_business_group_id
6482: and p_date_earned between date_from
6483: and nvl( date_to,hr_api.g_eot);
6484:

Line 6509: l_version_id per_org_structure_versions_v.org_structure_version_id%type default null;

6505: l_loop_again NUMBER;
6506: l_eoy_percent hr_organization_information.org_information3%TYPE;
6507: l_org_id hr_all_organization_units.organization_id%type;
6508: l_org_info_id hr_organization_information.org_information_id%type;
6509: l_version_id per_org_structure_versions_v.org_structure_version_id%type default null;
6510:
6511: BEGIN
6512:
6513: hr_utility.set_location('Entering get_eoy_bonus_percentage',10);