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_NL_ABP_FUNCTIONS dependencies on HR_ORGANIZATION_INFORMATION

Line 444: FROM hr_organization_information

440: ) IS
441: CURSOR cur_abp_pt IS
442: SELECT org_information1
443: ,nvl(org_information2,'4712/12/31') org_information2
444: FROM hr_organization_information
445: WHERE org_information3 = p_org_information3
446: AND organization_id = p_organization_id
447: AND org_information_id <> p_org_information_id
448: AND org_information_context = 'PQP_NL_ABP_PT';

Line 453: FROM hr_organization_information

449:
450: CURSOR cur_pggm_pt IS
451: SELECT org_information1
452: ,nvl(org_information2,'4712/12/31') org_information2
453: FROM hr_organization_information
454: WHERE org_information3 = p_org_information3
455: AND organization_id = p_organization_id
456: AND org_information_id <> p_org_information_id
457: AND org_information_context = 'PQP_NL_PGGM_PT';

Line 462: FROM hr_organization_information

458:
459: CURSOR cur_pggm_info IS
460: SELECT org_information1
461: ,nvl(org_information2,'4712/12/31') org_information2
462: FROM hr_organization_information
463: WHERE organization_id = p_organization_id
464: AND org_information_id <> p_org_information_id
465: AND org_information_context = 'PQP_NL_PGGM_INFO';
466:

Line 500: FROM hr_organization_information

496: --Cursor to find all rows which have dates overlapping the current record dates
497: --
498: CURSOR cur_get_overlap_rows IS
499: SELECT org_information3
500: FROM hr_organization_information
501: WHERE organization_id = p_organization_id
502: AND org_information_id <> p_org_information_id
503: AND org_information_context = 'PQP_NL_ABP_PT'
504: AND ((trunc(to_date(substr(org_information1,1,10),'YYYY/MM/DD'))

Line 1041: FROM hr_organization_information

1037: ) IS
1038: CURSOR cur_abp_pt IS
1039: SELECT org_information1
1040: ,nvl(org_information2,'4712/12/31') org_information2
1041: FROM hr_organization_information
1042: WHERE org_information3 = p_org_information3
1043: AND organization_id = p_organization_id
1044: AND org_information_id <> p_org_information_id
1045: AND org_information_context = 'PQP_NL_ABP_PT';

Line 1050: FROM hr_organization_information

1046:
1047: CURSOR cur_pggm_pt IS
1048: SELECT org_information1
1049: ,nvl(org_information2,'4712/12/31') org_information2
1050: FROM hr_organization_information
1051: WHERE org_information3 = p_org_information3
1052: AND organization_id = p_organization_id
1053: AND org_information_id <> p_org_information_id
1054: AND org_information_context = 'PQP_NL_PGGM_PT';

Line 1059: FROM hr_organization_information

1055:
1056: CURSOR cur_pggm_info IS
1057: SELECT org_information1
1058: ,nvl(org_information2,'4712/12/31') org_information2
1059: FROM hr_organization_information
1060: WHERE organization_id = p_organization_id
1061: AND org_information_id <> p_org_information_id
1062: AND org_information_context = 'PQP_NL_PGGM_INFO';
1063:

Line 1082: FROM hr_organization_information

1078:
1079: --Cursor to find all rows which have dates overlapping the current record dates
1080: CURSOR cur_get_overlap_rows IS
1081: SELECT org_information3
1082: FROM hr_organization_information
1083: WHERE organization_id = p_organization_id
1084: AND org_information_id <> p_org_information_id
1085: AND org_information_context = 'PQP_NL_ABP_PT'
1086: AND ((trunc(to_date(substr(org_information1,1,10),'YYYY/MM/DD'))

Line 4535: FROM hr_organization_information hoi

4531: -- "Applicable to all EE" flags
4532: --
4533: CURSOR c_pt_valid_hr_org IS
4534: SELECT 1
4535: FROM hr_organization_information hoi
4536: WHERE hoi.org_information_context = 'PQP_NL_ABP_PT'
4537: AND hoi.org_information3 = TO_CHAR(p_pt_id)
4538: AND NVL(hoi.org_information6,'N') = 'Y'
4539: AND NVL(hoi.org_information7,'N') = 'Y'

Line 4554: FROM hr_organization_information hoi

4550: --
4551:
4552: CURSOR c_pt_valid_le IS
4553: SELECT 1
4554: FROM hr_organization_information hoi
4555: WHERE hoi.org_information_context = 'PQP_NL_ABP_PT'
4556: AND hoi.org_information3 = TO_CHAR(p_pt_id)
4557: AND NVL(hoi.org_information6,'N') = 'Y'
4558: AND NVL(hoi.org_information7,'N') = 'Y'

Line 4564: FROM hr_organization_information hoi

4560: AND p_date_earned BETWEEN fnd_date.canonical_to_date(hoi.org_information1)
4561: AND fnd_date.canonical_to_date(NVL(hoi.org_information2,
4562: fnd_date.date_to_canonical(hr_api.g_eot)))
4563: AND NOT EXISTS ( SELECT 1
4564: FROM hr_organization_information hoi
4565: WHERE hoi.org_information_context = 'PQP_NL_ABP_PT'
4566: AND hoi.org_information3 = TO_CHAR(p_pt_id)
4567: AND ( NVL(hoi.org_information6,'N')= 'N'
4568: OR NVL(hoi.org_information7,'N')= 'N')

Line 4648: (c_org_id IN hr_organization_information.organization_id%TYPE) IS

4644: -- all EE's flag does not matter as the PT is attached
4645: -- at the assignment level.
4646: --
4647: CURSOR c_get_contribution
4648: (c_org_id IN hr_organization_information.organization_id%TYPE) IS
4649: SELECT fnd_number.canonical_to_number(NVL(hoi.org_information4,'-1'))
4650: ,fnd_number.canonical_to_number(NVL(hoi.org_information5,'-1'))
4651: FROM hr_organization_information hoi
4652: WHERE hoi.org_information_context = 'PQP_NL_ABP_PT'

Line 4651: FROM hr_organization_information hoi

4647: CURSOR c_get_contribution
4648: (c_org_id IN hr_organization_information.organization_id%TYPE) IS
4649: SELECT fnd_number.canonical_to_number(NVL(hoi.org_information4,'-1'))
4650: ,fnd_number.canonical_to_number(NVL(hoi.org_information5,'-1'))
4651: FROM hr_organization_information hoi
4652: WHERE hoi.org_information_context = 'PQP_NL_ABP_PT'
4653: AND hoi.org_information3 = TO_CHAR(p_pension_type_id)
4654: AND hoi.org_information6 = 'Y'
4655: AND hoi.organization_id = c_org_id

Line 4959: (c_org_id IN hr_organization_information.organization_id%TYPE

4955: -- Note that this fetches the values for the information
4956: -- with "Applicable to all EE" flag as a param
4957: --
4958: CURSOR c_get_contribution
4959: (c_org_id IN hr_organization_information.organization_id%TYPE
4960: ,c_pt_id IN NUMBER
4961: ,c_date_earned IN DATE) IS
4962: SELECT fnd_number.canonical_to_number(NVL(hoi.org_information4,'-1'))
4963: ,fnd_number.canonical_to_number(NVL(hoi.org_information5,'-1'))

Line 4964: FROM hr_organization_information hoi

4960: ,c_pt_id IN NUMBER
4961: ,c_date_earned IN DATE) IS
4962: SELECT fnd_number.canonical_to_number(NVL(hoi.org_information4,'-1'))
4963: ,fnd_number.canonical_to_number(NVL(hoi.org_information5,'-1'))
4964: FROM hr_organization_information hoi
4965: WHERE hoi.org_information_context = 'PQP_NL_ABP_PT'
4966: AND hoi.org_information3 = TO_CHAR(c_pt_id)
4967: AND hoi.org_information6 = 'Y'
4968: AND NVL(hoi.org_information7,'Y') = 'Y'

Line 5531: l_org_info_id hr_organization_information.org_information_id%type;

5527:
5528: l_org_id hr_all_organization_units.organization_id%type;
5529: l_ret_value number := 0; --return
5530: l_asg_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type;
5531: l_org_info_id hr_organization_information.org_information_id%type;
5532: l_named_hierarchy number;
5533: l_version_id per_org_structure_versions_v.org_structure_version_id%type default null;
5534: l_loop_again number;
5535: l_is_org_info_valid varchar2(1);

Line 5548: from hr_organization_information

5544:
5545: --Cursor to find the named hierarchy associated with the BG
5546: CURSOR c_find_named_hierarchy Is
5547: select org_information1
5548: from hr_organization_information
5549: where organization_id = p_business_group_id
5550: and org_information_context = 'NL_BG_INFO';
5551:
5552: --Cursor to find the valid version id for the particular named hierarchy

Line 5591: from hr_organization_information hoi

5587: --Cursor to find if there is any information record at the org level
5588: --if so return the org info id
5589: CURSOR c_get_valid_org_info(c_org_id in hr_all_organization_units.organization_id%type) IS
5590: Select hoi.org_information_id
5591: from hr_organization_information hoi
5592: where hoi.org_information_context = 'PQP_NL_ABP_PT'
5593: and hoi.org_information3 = to_char(p_pension_type_id)
5594: AND hoi.org_information6 = 'Y'
5595: AND NVL(hoi.org_information7,'Y') = 'Y'

Line 5610: CURSOR c_get_org_info(c_org_id in hr_organization_information.organization_id%type) Is

5606: and p_date_earned between fnd_date.canonical_to_date(paei.aei_information1)
5607: and fnd_date.canonical_to_date(nvl(paei.aei_information2,fnd_date.date_to_canonical(hr_api.g_eot)));
5608:
5609: --Cursor to find the participation start date from org level information
5610: CURSOR c_get_org_info(c_org_id in hr_organization_information.organization_id%type) Is
5611: SELECT fnd_date.canonical_to_date(hoi.org_information1)
5612: FROM hr_organization_information hoi
5613: where hoi.org_information_context = 'PQP_NL_ABP_PT'
5614: and hoi.org_information3 = to_char(p_pension_type_id)

Line 5612: FROM hr_organization_information hoi

5608:
5609: --Cursor to find the participation start date from org level information
5610: CURSOR c_get_org_info(c_org_id in hr_organization_information.organization_id%type) Is
5611: SELECT fnd_date.canonical_to_date(hoi.org_information1)
5612: FROM hr_organization_information hoi
5613: where hoi.org_information_context = 'PQP_NL_ABP_PT'
5614: and hoi.org_information3 = to_char(p_pension_type_id)
5615: and hoi.org_information6 = 'Y'
5616: and NVL(hoi.org_information7,'Y') = 'Y'

Line 5739: l_org_info_id hr_organization_information.org_information_id%type;

5735: IS
5736:
5737: l_org_id hr_all_organization_units.organization_id%type;
5738: l_asg_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type;
5739: l_org_info_id hr_organization_information.org_information_id%type;
5740: l_named_hierarchy number;
5741: l_version_id per_org_structure_versions_v.org_structure_version_id%type default null;
5742: l_loop_again number;
5743: l_is_org_info_valid varchar2(1);

Line 5756: from hr_organization_information

5752:
5753: --Cursor to find the named hierarchy associated with the BG
5754: CURSOR c_find_named_hierarchy(c_bgid in number) Is
5755: select org_information1
5756: from hr_organization_information
5757: where organization_id = c_bgid
5758: and org_information_context = 'NL_BG_INFO';
5759:
5760: --Cursor to find the valid version id for the particular named hierarchy

Line 5802: from hr_organization_information hoi

5798: --Cursor to find if the information record at the org level is valid
5799: --on the date earned and if so return the org info id
5800: CURSOR c_get_valid_org_info(c_org_id in hr_all_organization_units.organization_id%type) IS
5801: Select hoi.org_information_id
5802: from hr_organization_information hoi
5803: where hoi.org_information_context = 'PQP_NL_ABP_PT'
5804: and hoi.org_information3 = to_char(p_pension_type_id)
5805: and hoi.org_information6 = 'Y'
5806: AND NVL(hoi.org_information7,'Y') = 'Y'

Line 5913: FROM hr_organization_information

5909:
5910: --cursor to check to see if there are any rows in the ORG EIT
5911: CURSOR c_rows_exist IS
5912: SELECT 1
5913: FROM hr_organization_information
5914: WHERE EXISTS
5915: (SELECT 1
5916: FROM hr_organization_information
5917: WHERE organization_id = p_organization_id

Line 5916: FROM hr_organization_information

5912: SELECT 1
5913: FROM hr_organization_information
5914: WHERE EXISTS
5915: (SELECT 1
5916: FROM hr_organization_information
5917: WHERE organization_id = p_organization_id
5918: AND org_information_context = p_org_information_context
5919: AND org_information_id <> p_org_information_id
5920: );

Line 6465: from hr_organization_information

6461:
6462: --Cursor to find the named hierarchy associated with the BG
6463: CURSOR c_find_named_hierarchy Is
6464: select org_information1
6465: from hr_organization_information
6466: where organization_id = p_business_group_id
6467: and org_information_context = 'NL_BG_INFO';
6468:
6469: --Cursor to find the valid version id for the particular named hierarchy

Line 6498: FROM hr_organization_information

6494: --Cursor to find the eoy bonus percentage
6495: --if entered at the org level
6496: CURSOR c_find_eoy_percent(c_org_id IN NUMBER) IS
6497: SELECT org_information3
6498: FROM hr_organization_information
6499: WHERE organization_id = c_org_id
6500: AND org_information_context = 'PQP_NL_ABP_PTP_METHOD'
6501: AND org_information3 IS NOT NULL;
6502:

Line 6506: l_eoy_percent hr_organization_information.org_information3%TYPE;

6502:
6503: l_ret_val NUMBER;
6504: l_named_hierarchy NUMBER;
6505: l_loop_again NUMBER;
6506: l_eoy_percent hr_organization_information.org_information3%TYPE;
6507: l_org_id hr_all_organization_units.organization_id%type;
6508: l_org_info_id hr_organization_information.org_information_id%type;
6509: l_version_id per_org_structure_versions_v.org_structure_version_id%type default null;
6510:

Line 6508: l_org_info_id hr_organization_information.org_information_id%type;

6504: l_named_hierarchy NUMBER;
6505: l_loop_again NUMBER;
6506: l_eoy_percent hr_organization_information.org_information3%TYPE;
6507: l_org_id hr_all_organization_units.organization_id%type;
6508: l_org_info_id hr_organization_information.org_information_id%type;
6509: l_version_id per_org_structure_versions_v.org_structure_version_id%type default null;
6510:
6511: BEGIN
6512: