[Home] [Help]
2111: AND assignment_id = p_assignment_id
2112: AND aei_information10 IS NOT NULL
2113: AND c_eff_date BETWEEN fnd_date.canonical_to_date(aei_information1)
2114: AND fnd_date.canonical_to_date(nvl(aei_information2
2115: ,fnd_date.date_to_canonical(hr_api.g_eot)));
2116:
2117: -- =======================================================================
2118: -- Cursor to get the choice for average PTP calculation from ORG EIT
2119: -- =======================================================================
2135: AND assignment_id = p_assignment_id
2136: AND aei_information11 IS NOT NULL
2137: AND c_eff_date BETWEEN fnd_date.canonical_to_date(aei_information1)
2138: AND fnd_date.canonical_to_date(nvl(aei_information2
2139: ,fnd_date.date_to_canonical(hr_api.g_eot)));
2140:
2141: -- =======================================================================
2142: -- Cursor to get the choice for OHT from ORG EIT
2143: -- =======================================================================
2161: select ORG_STRUCTURE_VERSION_ID
2162: from per_org_structure_versions_v
2163: where organization_structure_id = c_hierarchy_id
2164: and c_eff_date between date_from
2165: and nvl(date_to,hr_api.g_eot);
2166:
2167: --Cursor to find the valid version id for a particular business group
2168: CURSOR c_find_ver_frm_bg(c_eff_date in date) Is
2169: select ORG_STRUCTURE_VERSION_ID
2169: select ORG_STRUCTURE_VERSION_ID
2170: from per_org_structure_versions_v
2171: where business_group_id = p_business_group_id
2172: and c_eff_date between date_from
2173: and nvl( date_to,hr_api.g_eot);
2174:
2175: --cursor to fetch the org id for the organization
2176: --attached to this assignment
2177: CURSOR c_get_org_id(c_eff_date IN DATE) IS
3306: where org_information_context = 'PQP_NL_ER_PENSION_TYPES'
3307: AND organization_id = c_org_id
3308: AND p_date_earned between fnd_date.canonical_to_date(org_information4)
3309: and fnd_date.canonical_to_date(nvl(org_information5,
3310: fnd_date.date_to_canonical(hr_api.g_eot)))
3311: );
3312:
3313: --Cursor to find the parent id from the org id
3314: CURSOR c_find_parent_id(c_org_id in number
3331: AND p_date_earned between pty.effective_start_date
3332: and pty.effective_end_date
3333: AND p_date_earned between fnd_date.canonical_to_date(hoi.org_information4)
3334: and fnd_date.canonical_to_date(nvl(hoi.org_information5,
3335: fnd_date.date_to_canonical(hr_api.g_eot))
3336: );
3337: --Cursor to find the pension type name from the pension type id
3338: CURSOR c_find_pen_type_name Is
3339: SELECT pension_type_name
3361: select ORG_STRUCTURE_VERSION_ID
3362: from per_org_structure_versions_v
3363: where organization_structure_id = c_hierarchy_id
3364: and p_date_earned between date_from
3365: and nvl(date_to,hr_api.g_eot);
3366:
3367: --Cursor to find the valid version id for a particular business group
3368: CURSOR c_find_ver_frm_bg Is
3369: select ORG_STRUCTURE_VERSION_ID
3369: select ORG_STRUCTURE_VERSION_ID
3370: from per_org_structure_versions_v
3371: where business_group_id = p_business_group_id
3372: and p_date_earned between date_from
3373: and nvl( date_to,hr_api.g_eot);
3374:
3375:
3376: l_org_id NUMBER;
3377: l_ret_value NUMBER;
5288: select ORG_STRUCTURE_VERSION_ID
5289: from per_org_structure_versions_v
5290: where organization_structure_id = c_hierarchy_id
5291: and p_date_earned between date_from
5292: and nvl(date_to,hr_api.g_eot);
5293:
5294: --Cursor to find the valid version id for a particular business group
5295: CURSOR c_find_ver_frm_bg Is
5296: select ORG_STRUCTURE_VERSION_ID
5296: select ORG_STRUCTURE_VERSION_ID
5297: from per_org_structure_versions_v
5298: where business_group_id = p_business_group_id
5299: and p_date_earned between date_from
5300: and nvl( date_to,hr_api.g_eot);
5301:
5302: l_named_hierarchy number;
5303: l_version_id per_org_structure_versions_v.org_structure_version_id%type
5304: default -99;