APPS.PQP_PENSION_FUNCTIONS dependencies on HR_ORGANIZATION_INFORMATION

Line 562: FROM per_all_assignments_f paa,hr_organization_information hoi

558: c_get_average_days_per_month(c_assignment_id IN NUMBER,
559: c_effective_date IN DATE
560: ) IS
561: SELECT hoi.org_information5
562: FROM per_all_assignments_f paa,hr_organization_information hoi
563: WHERE paa.organization_id = hoi.organization_id
564: AND hoi.org_information_context='NL_ORG_INFORMATION'
565: AND paa.assignment_id = c_assignment_id
566: AND trunc(c_effective_date) between effective_start_date and effective_end_date;

Line 2187: FROM hr_organization_information hoi

2183: -- Cursor to get the choice for average PTP calculation from ORG EIT
2184: -- =======================================================================
2185: CURSOR c_org_ptp_choice(c_org_id IN NUMBER) IS
2186: SELECT hoi.org_information1
2187: FROM hr_organization_information hoi
2188: WHERE hoi.organization_id = c_org_id
2189: AND hoi.org_information_context = 'PQP_NL_ABP_PTP_METHOD'
2190: AND hoi.org_information1 IS NOT NULL;
2191:

Line 2211: FROM hr_organization_information hoi

2207: -- Cursor to get the choice for OHT from ORG EIT
2208: -- =======================================================================
2209: CURSOR c_org_oht_choice(c_org_id IN NUMBER) IS
2210: SELECT hoi.org_information2
2211: FROM hr_organization_information hoi
2212: WHERE hoi.organization_id = c_org_id
2213: AND hoi.org_information_context = 'PQP_NL_ABP_PTP_METHOD'
2214: AND hoi.org_information2 IS NOT NULL;
2215:

Line 2219: from hr_organization_information

2215:
2216: --Cursor to find the named hierarchy associated with the BG
2217: CURSOR c_find_named_hierarchy Is
2218: select org_information1
2219: from hr_organization_information
2220: where organization_id = p_business_group_id
2221: and org_information_context = 'NL_BG_INFO';
2222:
2223: --Cursor to find the valid version id for the particular named hierarchy

Line 3402: where exists (select 1 from hr_organization_information

3398:
3399: --Cursor to chk if the organization has any overridden pension types attached
3400: CURSOR c_is_any_pt_assigned(c_org_id in number) IS
3401: select 1 from dual
3402: where exists (select 1 from hr_organization_information
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,

Line 3422: FROM hr_organization_information hoi,

3418:
3419: --Cursor to find if the pension type is assigned to this org
3420: CURSOR c_is_pen_type_assigned(c_org_id in number) Is
3421: SELECT 1
3422: FROM hr_organization_information hoi,
3423: pqp_pension_types_f pty
3424: WHERE hoi.org_information_context = 'PQP_NL_ER_PENSION_TYPES'
3425: AND hoi.org_information2 = TO_CHAR(p_pension_type_id)
3426: AND hoi.organization_id = c_org_id

Line 3452: from hr_organization_information

3448:
3449: --Cursor to find the named hierarchy associated with the BG
3450: CURSOR c_find_named_hierarchy Is
3451: select org_information1
3452: from hr_organization_information
3453: where organization_id = p_business_group_id
3454: and org_information_context = 'NL_BG_INFO';
3455:
3456: --Cursor to find the valid version id for the particular named hierarchy

Line 5379: from hr_organization_information

5375:
5376: --Cursor to find the named hierarchy associated with the BG
5377: CURSOR c_find_named_hierarchy Is
5378: select org_information1
5379: from hr_organization_information
5380: where organization_id = p_business_group_id
5381: and org_information_context = 'NL_BG_INFO';
5382:
5383: --Cursor to find the valid version id for the particular named hierarchy