[Home] [Help]
2176: AND assignment_id = p_assignment_id
2177: AND aei_information10 IS NOT NULL
2178: AND c_eff_date BETWEEN fnd_date.canonical_to_date(aei_information1)
2179: AND fnd_date.canonical_to_date(nvl(aei_information2
2180: ,fnd_date.date_to_canonical(hr_api.g_eot)));
2181:
2182: -- =======================================================================
2183: -- Cursor to get the choice for average PTP calculation from ORG EIT
2184: -- =======================================================================
2200: AND assignment_id = p_assignment_id
2201: AND aei_information11 IS NOT NULL
2202: AND c_eff_date BETWEEN fnd_date.canonical_to_date(aei_information1)
2203: AND fnd_date.canonical_to_date(nvl(aei_information2
2204: ,fnd_date.date_to_canonical(hr_api.g_eot)));
2205:
2206: -- =======================================================================
2207: -- Cursor to get the choice for OHT from ORG EIT
2208: -- =======================================================================
2226: select ORG_STRUCTURE_VERSION_ID
2227: from per_org_structure_versions_v
2228: where organization_structure_id = c_hierarchy_id
2229: and c_eff_date between date_from
2230: and nvl(date_to,hr_api.g_eot);
2231:
2232: --Cursor to find the valid version id for a particular business group
2233: CURSOR c_find_ver_frm_bg(c_eff_date in date) Is
2234: select ORG_STRUCTURE_VERSION_ID
2234: select ORG_STRUCTURE_VERSION_ID
2235: from per_org_structure_versions_v
2236: where business_group_id = p_business_group_id
2237: and c_eff_date between date_from
2238: and nvl( date_to,hr_api.g_eot);
2239:
2240: --cursor to fetch the org id for the organization
2241: --attached to this assignment
2242: CURSOR c_get_org_id(c_eff_date IN DATE) IS
3403: where org_information_context = 'PQP_NL_ER_PENSION_TYPES'
3404: AND organization_id = c_org_id
3405: AND p_date_earned between fnd_date.canonical_to_date(org_information4)
3406: and fnd_date.canonical_to_date(nvl(org_information5,
3407: fnd_date.date_to_canonical(hr_api.g_eot)))
3408: );
3409:
3410: --Cursor to find the parent id from the org id
3411: CURSOR c_find_parent_id(c_org_id in number
3428: AND p_date_earned between pty.effective_start_date
3429: and pty.effective_end_date
3430: AND p_date_earned between fnd_date.canonical_to_date(hoi.org_information4)
3431: and fnd_date.canonical_to_date(nvl(hoi.org_information5,
3432: fnd_date.date_to_canonical(hr_api.g_eot))
3433: );
3434: --Cursor to find the pension type name from the pension type id
3435: CURSOR c_find_pen_type_name Is
3436: SELECT pension_type_name
3458: select ORG_STRUCTURE_VERSION_ID
3459: from per_org_structure_versions_v
3460: where organization_structure_id = c_hierarchy_id
3461: and p_date_earned between date_from
3462: and nvl(date_to,hr_api.g_eot);
3463:
3464: --Cursor to find the valid version id for a particular business group
3465: CURSOR c_find_ver_frm_bg Is
3466: select ORG_STRUCTURE_VERSION_ID
3466: select ORG_STRUCTURE_VERSION_ID
3467: from per_org_structure_versions_v
3468: where business_group_id = p_business_group_id
3469: and p_date_earned between date_from
3470: and nvl( date_to,hr_api.g_eot);
3471:
3472:
3473: l_org_id NUMBER;
3474: l_ret_value NUMBER;
5385: select ORG_STRUCTURE_VERSION_ID
5386: from per_org_structure_versions_v
5387: where organization_structure_id = c_hierarchy_id
5388: and p_date_earned between date_from
5389: and nvl(date_to,hr_api.g_eot);
5390:
5391: --Cursor to find the valid version id for a particular business group
5392: CURSOR c_find_ver_frm_bg Is
5393: select ORG_STRUCTURE_VERSION_ID
5393: select ORG_STRUCTURE_VERSION_ID
5394: from per_org_structure_versions_v
5395: where business_group_id = p_business_group_id
5396: and p_date_earned between date_from
5397: and nvl( date_to,hr_api.g_eot);
5398:
5399: l_named_hierarchy number;
5400: l_version_id per_org_structure_versions_v.org_structure_version_id%type
5401: default -99;