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.

[Home] [Help]

APPS.PQP_PENSION_FUNCTIONS dependencies on PER_ORG_STRUCTURE_VERSIONS_V

Line 2162: from per_org_structure_versions_v

2158: --Cursor to find the valid version id for the particular named hierarchy
2159: CURSOR c_find_ver_frm_hierarchy(c_hierarchy_id in Number
2160: ,c_eff_date in Date) Is
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:

Line 2170: from per_org_structure_versions_v

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
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:

Line 3362: from per_org_structure_versions_v

3358:
3359: --Cursor to find the valid version id for the particular named hierarchy
3360: CURSOR c_find_ver_frm_hierarchy(c_hierarchy_id in Number) Is
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:

Line 3370: from per_org_structure_versions_v

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
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:

Line 5289: from per_org_structure_versions_v

5285:
5286: --Cursor to find the valid version id for the particular named hierarchy
5287: CURSOR c_find_ver_frm_hierarchy(c_hierarchy_id in Number) Is
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:

Line 5297: from per_org_structure_versions_v

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
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:

Line 5303: l_version_id per_org_structure_versions_v.org_structure_version_id%type

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;
5305: l_proc_name varchar2(30) := 'Get_Version_id';
5306:
5307: BEGIN