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_PENSION_FUNCTIONS dependencies on PER_ORG_STRUCTURE_VERSIONS_V

Line 2227: from per_org_structure_versions_v

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

Line 2235: from per_org_structure_versions_v

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

Line 3459: from per_org_structure_versions_v

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

Line 3467: from per_org_structure_versions_v

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

Line 5386: from per_org_structure_versions_v

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

Line 5394: from per_org_structure_versions_v

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

Line 5400: l_version_id per_org_structure_versions_v.org_structure_version_id%type

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;
5402: l_proc_name varchar2(30) := 'Get_Version_id';
5403:
5404: BEGIN