APPS.PQP_PENSION_FUNCTIONS dependencies on HR_ORGANIZATION_INFORMATION

Line 520: FROM per_all_assignments_f paa,hr_organization_information hoi

516: c_get_average_days_per_month(c_assignment_id IN NUMBER,
517: c_effective_date IN DATE
518: ) IS
519: SELECT hoi.org_information5
520: FROM per_all_assignments_f paa,hr_organization_information hoi
521: WHERE paa.organization_id = hoi.organization_id
522: AND hoi.org_information_context='NL_ORG_INFORMATION'
523: AND paa.assignment_id = c_assignment_id
524: AND trunc(c_effective_date) between effective_start_date and effective_end_date;

Line 2122: FROM hr_organization_information hoi

2118: -- Cursor to get the choice for average PTP calculation from ORG EIT
2119: -- =======================================================================
2120: CURSOR c_org_ptp_choice(c_org_id IN NUMBER) IS
2121: SELECT hoi.org_information1
2122: FROM hr_organization_information hoi
2123: WHERE hoi.organization_id = c_org_id
2124: AND hoi.org_information_context = 'PQP_NL_ABP_PTP_METHOD'
2125: AND hoi.org_information1 IS NOT NULL;
2126:

Line 2146: FROM hr_organization_information hoi

2142: -- Cursor to get the choice for OHT from ORG EIT
2143: -- =======================================================================
2144: CURSOR c_org_oht_choice(c_org_id IN NUMBER) IS
2145: SELECT hoi.org_information2
2146: FROM hr_organization_information hoi
2147: WHERE hoi.organization_id = c_org_id
2148: AND hoi.org_information_context = 'PQP_NL_ABP_PTP_METHOD'
2149: AND hoi.org_information2 IS NOT NULL;
2150:

Line 2154: from hr_organization_information

2150:
2151: --Cursor to find the named hierarchy associated with the BG
2152: CURSOR c_find_named_hierarchy Is
2153: select org_information1
2154: from hr_organization_information
2155: where organization_id = p_business_group_id
2156: and org_information_context = 'NL_BG_INFO';
2157:
2158: --Cursor to find the valid version id for the particular named hierarchy

Line 3305: where exists (select 1 from hr_organization_information

3301:
3302: --Cursor to chk if the organization has any overridden pension types attached
3303: CURSOR c_is_any_pt_assigned(c_org_id in number) IS
3304: select 1 from dual
3305: where exists (select 1 from hr_organization_information
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,

Line 3325: FROM hr_organization_information hoi,

3321:
3322: --Cursor to find if the pension type is assigned to this org
3323: CURSOR c_is_pen_type_assigned(c_org_id in number) Is
3324: SELECT 1
3325: FROM hr_organization_information hoi,
3326: pqp_pension_types_f pty
3327: WHERE hoi.org_information_context = 'PQP_NL_ER_PENSION_TYPES'
3328: AND hoi.org_information2 = TO_CHAR(p_pension_type_id)
3329: AND hoi.organization_id = c_org_id

Line 3355: from hr_organization_information

3351:
3352: --Cursor to find the named hierarchy associated with the BG
3353: CURSOR c_find_named_hierarchy Is
3354: select org_information1
3355: from hr_organization_information
3356: where organization_id = p_business_group_id
3357: and org_information_context = 'NL_BG_INFO';
3358:
3359: --Cursor to find the valid version id for the particular named hierarchy

Line 5282: from hr_organization_information

5278:
5279: --Cursor to find the named hierarchy associated with the BG
5280: CURSOR c_find_named_hierarchy Is
5281: select org_information1
5282: from hr_organization_information
5283: where organization_id = p_business_group_id
5284: and org_information_context = 'NL_BG_INFO';
5285:
5286: --Cursor to find the valid version id for the particular named hierarchy