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 PER_ASSIGNMENT_EXTRA_INFO

Line 1798: FROM per_assignment_extra_info

1794: ) IS
1795: CURSOR cur_abp_asg_info IS
1796: SELECT aei_information1
1797: ,nvl(aei_information2,'4712/12/31') aei_information2
1798: FROM per_assignment_extra_info
1799: WHERE aei_information3 = p_aei_information3
1800: AND assignment_id = p_assignment_id
1801: AND assignment_extra_info_id <> p_assignment_extra_info_id
1802: AND aei_information_category = 'NL_ABP_PI'

Line 1808: FROM per_assignment_extra_info

1804:
1805: CURSOR cur_abp_asg_info1 IS
1806: SELECT aei_information1
1807: ,nvl(aei_information2,'4712/12/31') aei_information2
1808: FROM per_assignment_extra_info
1809: WHERE assignment_id = p_assignment_id
1810: AND assignment_extra_info_id <> p_assignment_extra_info_id
1811: AND aei_information_category = 'NL_ABP_PAR_INFO'
1812: AND information_type = 'NL_ABP_PAR_INFO';

Line 1818: FROM per_assignment_extra_info

1814: --cursor to find all other rows with the same period number
1815: --and the same savings type
1816: CURSOR cur_sav_asg_info IS
1817: SELECT 1
1818: FROM per_assignment_extra_info
1819: WHERE assignment_id = p_assignment_id
1820: AND assignment_extra_info_id <> p_assignment_extra_info_id
1821: AND aei_information_category = 'NL_SAV_INFO'
1822: AND information_type = 'NL_SAV_INFO'

Line 1856: FROM per_assignment_extra_info

1852: --cursor to find all the EIT rows which have a salary override
1853: --and fall in the current year
1854: CURSOR cur_get_sal_rows(c_year IN varchar2) IS
1855: SELECT aei_information1,aei_information2
1856: FROM per_assignment_extra_info
1857: WHERE assignment_id = p_assignment_id
1858: AND assignment_extra_info_id <> p_assignment_extra_info_id
1859: AND aei_information_category = 'NL_ABP_PAR_INFO'
1860: AND information_type = 'NL_ABP_PAR_INFO'

Line 1880: FROM per_assignment_extra_info

1876:
1877: --Cursor to find all rows which have dates overlapping the current record dates
1878: CURSOR cur_get_overlap_rows IS
1879: SELECT aei_information3
1880: FROM per_assignment_extra_info
1881: WHERE assignment_id = p_assignment_id
1882: AND assignment_extra_info_id <> p_assignment_extra_info_id
1883: AND aei_information_category = 'NL_ABP_PI'
1884: AND information_type = 'NL_ABP_PI'

Line 1935: FROM per_assignment_extra_info

1931:
1932: CURSOR cur_ret_addl_info_calc IS
1933: SELECT aei_information1
1934: ,nvl(aei_information2,'4712/12/31') aei_information2
1935: FROM per_assignment_extra_info
1936: WHERE assignment_id = p_assignment_id
1937: AND assignment_extra_info_id <> p_assignment_extra_info_id
1938: AND aei_information_category = 'NL_ADDL_CALC'
1939: AND information_type = 'NL_ADDL_CALC';

Line 2756: FROM per_assignment_extra_info

2752: ) IS
2753: CURSOR cur_abp_asg_info IS
2754: SELECT aei_information1
2755: ,nvl(aei_information2,'4712/12/31') aei_information2
2756: FROM per_assignment_extra_info
2757: WHERE aei_information3 = p_aei_information3
2758: AND assignment_id = p_assignment_id
2759: AND assignment_extra_info_id <> p_assignment_extra_info_id
2760: AND aei_information_category = 'NL_ABP_PI'

Line 2766: FROM per_assignment_extra_info

2762:
2763: CURSOR cur_abp_asg_info1 IS
2764: SELECT aei_information1
2765: ,nvl(aei_information2,'4712/12/31') aei_information2
2766: FROM per_assignment_extra_info
2767: WHERE assignment_id = p_assignment_id
2768: AND assignment_extra_info_id <> p_assignment_extra_info_id
2769: AND aei_information_category = 'NL_ABP_PAR_INFO'
2770: AND information_type = 'NL_ABP_PAR_INFO';

Line 2776: FROM per_assignment_extra_info

2772: --cursor to find all other rows with the same period number
2773: --and the same savings type
2774: CURSOR cur_sav_asg_info IS
2775: SELECT 1
2776: FROM per_assignment_extra_info
2777: WHERE assignment_id = p_assignment_id
2778: AND assignment_extra_info_id <> p_assignment_extra_info_id
2779: AND aei_information_category = 'NL_SAV_INFO'
2780: AND information_type = 'NL_SAV_INFO'

Line 2788: FROM per_assignment_extra_info

2784: --cursor to find all the EIT rows which have a salary override
2785: --and fall in the current year
2786: CURSOR cur_get_sal_rows(c_year IN varchar2) IS
2787: SELECT aei_information1,aei_information2
2788: FROM per_assignment_extra_info
2789: WHERE assignment_id = p_assignment_id
2790: AND assignment_extra_info_id <> p_assignment_extra_info_id
2791: AND aei_information_category = 'NL_ABP_PAR_INFO'
2792: AND information_type = 'NL_ABP_PAR_INFO'

Line 2838: FROM per_assignment_extra_info

2834:
2835: --Cursor to find all rows which have dates overlapping the current record dates
2836: CURSOR cur_get_overlap_rows IS
2837: SELECT aei_information3
2838: FROM per_assignment_extra_info
2839: WHERE assignment_id = p_assignment_id
2840: AND assignment_extra_info_id <> p_assignment_extra_info_id
2841: AND information_type = 'NL_ABP_PI'
2842: AND aei_information_category = 'NL_ABP_PI'

Line 2915: FROM per_assignment_extra_info

2911:
2912: CURSOR cur_ret_addl_info_calc IS
2913: SELECT aei_information1
2914: ,nvl(aei_information2,'4712/12/31') aei_information2
2915: FROM per_assignment_extra_info
2916: WHERE assignment_id = p_assignment_id
2917: AND assignment_extra_info_id <> p_assignment_extra_info_id
2918: AND aei_information_category = 'NL_ADDL_CALC'
2919: AND information_type = 'NL_ADDL_CALC';

Line 3879: FROM per_assignment_extra_info

3875: --
3876: SELECT fnd_number.canonical_to_number(nvl(aei_information5,'1')) VOP
3877: ,TRUNC(fnd_date.canonical_to_date(aei_information1)) St_Dt
3878: ,TRUNC(NVL(fnd_date.canonical_to_date(aei_information2),c_ed_dt)) Ed_Dt
3879: FROM per_assignment_extra_info
3880: WHERE assignment_id = p_assignment_id
3881: AND information_type = 'NL_ABP_PAR_INFO'
3882: AND aei_information_category = 'NL_ABP_PAR_INFO'
3883: AND TRUNC(fnd_date.canonical_to_date(aei_information1))

Line 3892: FROM per_assignment_extra_info

3888: --
3889: SELECT fnd_number.canonical_to_number(nvl(aei_information5,'1')) VOP
3890: ,TRUNC(fnd_date.canonical_to_date(aei_information1)) St_Dt
3891: ,TRUNC(NVL(fnd_date.canonical_to_date(aei_information2),c_ed_dt)) Ed_Dt
3892: FROM per_assignment_extra_info
3893: WHERE assignment_id = p_assignment_id
3894: AND information_type = 'NL_ABP_PAR_INFO'
3895: AND aei_information_category = 'NL_ABP_PAR_INFO'
3896: AND TRUNC(NVL(fnd_date.canonical_to_date(aei_information2),c_ed_dt))

Line 3906: FROM per_assignment_extra_info

3902: --
3903: SELECT fnd_number.canonical_to_number(nvl(aei_information5,'1')) VOP
3904: ,TRUNC(fnd_date.canonical_to_date(aei_information1)) St_Dt
3905: ,TRUNC(NVL(fnd_date.canonical_to_date(aei_information2),c_ed_dt)) Ed_Dt
3906: FROM per_assignment_extra_info
3907: WHERE assignment_id = p_assignment_id
3908: AND information_type = 'NL_ABP_PAR_INFO'
3909: AND aei_information_category = 'NL_ABP_PAR_INFO'
3910: AND c_ed_dt BETWEEN TRUNC(fnd_date.canonical_to_date(aei_information1))

Line 3923: FROM per_assignment_extra_info aei,

3919: --
3920: SELECT fnd_number.canonical_to_number(nvl(aei_information23,'1')) VOP
3921: ,TRUNC(fnd_date.canonical_to_date(aei_information1)) St_Dt
3922: ,TRUNC(NVL(fnd_date.canonical_to_date(aei_information2),c_ed_dt)) Ed_Dt
3923: FROM per_assignment_extra_info aei,
3924: pqp_pension_types_f pty
3925: WHERE assignment_id = p_assignment_id
3926: AND aei_information3 = p_pension_type_id
3927: AND pty.pension_type_id = fnd_number.canonical_to_number(aei.aei_information3)

Line 3944: FROM per_assignment_extra_info aei,

3940: --
3941: SELECT fnd_number.canonical_to_number(nvl(aei_information23,'1')) VOP
3942: ,TRUNC(fnd_date.canonical_to_date(aei_information1)) St_Dt
3943: ,TRUNC(NVL(fnd_date.canonical_to_date(aei_information2),c_ed_dt)) Ed_Dt
3944: FROM per_assignment_extra_info aei,
3945: pqp_pension_types_f pty
3946: WHERE assignment_id = p_assignment_id
3947: AND aei_information3 = p_pension_type_id
3948: AND pty.pension_type_id = fnd_number.canonical_to_number(aei.aei_information3)

Line 3966: FROM per_assignment_extra_info aei,

3962: --
3963: SELECT fnd_number.canonical_to_number(nvl(aei_information23,'1')) VOP
3964: ,TRUNC(fnd_date.canonical_to_date(aei_information1)) St_Dt
3965: ,TRUNC(NVL(fnd_date.canonical_to_date(aei_information2),c_ed_dt)) Ed_Dt
3966: FROM per_assignment_extra_info aei,
3967: pqp_pension_types_f pty
3968: WHERE assignment_id = p_assignment_id
3969: AND aei_information3 = p_pension_type_id
3970: AND pty.pension_type_id = fnd_number.canonical_to_number(aei.aei_information3)

Line 4132: type t_asg_extra_info is table of per_assignment_extra_info%rowtype index by Binary_Integer;

4128: )
4129:
4130: RETURN number IS
4131:
4132: type t_asg_extra_info is table of per_assignment_extra_info%rowtype index by Binary_Integer;
4133:
4134: g_asg_extra_info_rec t_asg_extra_info;
4135:
4136: --new record structure for fetching the override for salary,basis,value and kind of

Line 4143: l_asg_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type;

4139:
4140: l_ret_value number := 0; --return
4141: l_is_ptype_valid number;
4142: l_pen_type_name pqp_pension_types_f.pension_type_name%type;
4143: l_asg_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type;
4144: l_asg_extra_info_id1 per_assignment_extra_info.assignment_extra_info_id%type;
4145: l_override_found number := 0;
4146: l_vop_ret_val NUMBER;
4147:

Line 4144: l_asg_extra_info_id1 per_assignment_extra_info.assignment_extra_info_id%type;

4140: l_ret_value number := 0; --return
4141: l_is_ptype_valid number;
4142: l_pen_type_name pqp_pension_types_f.pension_type_name%type;
4143: l_asg_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type;
4144: l_asg_extra_info_id1 per_assignment_extra_info.assignment_extra_info_id%type;
4145: l_override_found number := 0;
4146: l_vop_ret_val NUMBER;
4147:
4148: --Cursor to check if the pension type is valid on the date earned

Line 4167: from per_assignment_extra_info paei,

4163: --Cursor to find if the pension type has a valid information row at the --assignment level
4164: -- if so qry up the asg extra info id
4165: CURSOR c_get_asg_extra_info_id IS
4166: Select paei.assignment_extra_info_id
4167: from per_assignment_extra_info paei,
4168: pqp_pension_types_f pty
4169: where paei.information_type = 'NL_ABP_PI'
4170: and paei.aei_information_category = 'NL_ABP_PI'
4171: and paei.aei_information3 = to_char(p_pension_type_id)

Line 4176: -- cursor to get the data in per_assignment_extra_info for a particular --asg_extra_info_id

4172: and paei.assignment_id = p_assignment_id
4173: and p_date_earned between trunc(to_date(substr(paei.aei_information1,1,10),'YYYY/MM/DD'))
4174: and trunc(to_date(substr(nvl(paei.aei_information2,'4712/12/31'),1,10),'YYYY/MM/DD'));
4175:
4176: -- cursor to get the data in per_assignment_extra_info for a particular --asg_extra_info_id
4177: Cursor c_get_asg_extra_info(c_asg_extra_info_id in per_assignment_extra_info.assignment_extra_info_id%type) Is
4178: Select *
4179: from per_assignment_extra_info
4180: where assignment_extra_info_id = c_asg_extra_info_id;

Line 4177: Cursor c_get_asg_extra_info(c_asg_extra_info_id in per_assignment_extra_info.assignment_extra_info_id%type) Is

4173: and p_date_earned between trunc(to_date(substr(paei.aei_information1,1,10),'YYYY/MM/DD'))
4174: and trunc(to_date(substr(nvl(paei.aei_information2,'4712/12/31'),1,10),'YYYY/MM/DD'));
4175:
4176: -- cursor to get the data in per_assignment_extra_info for a particular --asg_extra_info_id
4177: Cursor c_get_asg_extra_info(c_asg_extra_info_id in per_assignment_extra_info.assignment_extra_info_id%type) Is
4178: Select *
4179: from per_assignment_extra_info
4180: where assignment_extra_info_id = c_asg_extra_info_id;
4181:

Line 4179: from per_assignment_extra_info

4175:
4176: -- cursor to get the data in per_assignment_extra_info for a particular --asg_extra_info_id
4177: Cursor c_get_asg_extra_info(c_asg_extra_info_id in per_assignment_extra_info.assignment_extra_info_id%type) Is
4178: Select *
4179: from per_assignment_extra_info
4180: where assignment_extra_info_id = c_asg_extra_info_id;
4181:
4182: --cursor to get the assignment extra info id for the NL_ABP_PAR_INFO context
4183: CURSOR c_get_extra_info_id IS

Line 4185: FROM per_assignment_extra_info

4181:
4182: --cursor to get the assignment extra info id for the NL_ABP_PAR_INFO context
4183: CURSOR c_get_extra_info_id IS
4184: SELECT assignment_extra_info_id
4185: FROM per_assignment_extra_info
4186: WHERE assignment_id = p_assignment_id
4187: AND information_type = 'NL_ABP_PAR_INFO'
4188: AND aei_information_category = 'NL_ABP_PAR_INFO'
4189: AND p_date_earned BETWEEN trunc(fnd_date.canonical_to_date(aei_information1))

Line 4435: FROM per_assignment_extra_info

4431:
4432:
4433: CURSOR c_get_part_st_age IS
4434: SELECT aei_information3
4435: FROM per_assignment_extra_info
4436: WHERE p_date_earned between fnd_date.canonical_to_date(aei_information1)
4437: AND fnd_date.canonical_to_date(nvl(aei_information2,fnd_date.date_to_canonical(hr_api.g_eot)))
4438: AND assignment_id = p_assignment_id
4439: AND aei_information_category = 'NL_ABP_PAR_INFO';

Line 4944: FROM per_assignment_extra_info paei

4940: SELECT NVL(paei.aei_information13,'PE'),
4941: fnd_number.canonical_to_number(NVL(paei.aei_information14,'-1'))
4942: ,NVL(paei.aei_information15,'PE'),
4943: fnd_number.canonical_to_number(NVL(paei.aei_information16,'-1'))
4944: FROM per_assignment_extra_info paei
4945: WHERE paei.information_type = 'NL_ABP_PI'
4946: AND paei.aei_information_category = 'NL_ABP_PI'
4947: AND paei.assignment_id = p_assignment_id
4948: AND fnd_number.canonical_to_number(NVL(aei_information3,-1)) = c_pty_id

Line 5530: l_asg_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type;

5526: RETURN number IS
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;

Line 5581: from per_assignment_extra_info paei

5577: --Cursor to find if there is any information record at the assignment level
5578: --if so return the asg extra info id
5579: CURSOR c_get_valid_asg_info Is
5580: Select paei.assignment_extra_info_id
5581: from per_assignment_extra_info paei
5582: where paei.information_type = 'NL_ABP_PI'
5583: and paei.aei_information_category = 'NL_ABP_PI'
5584: and paei.aei_information3 = to_char(p_pension_type_id)
5585: and paei.assignment_id = p_assignment_id;

Line 5601: FROM per_assignment_extra_info paei

5597:
5598: --Cursor to find the participation start date from assignment level information
5599: CURSOR c_get_asg_info Is
5600: SELECT fnd_date.canonical_to_date(paei.aei_information1)
5601: FROM per_assignment_extra_info paei
5602: WHERE paei.information_type = 'NL_ABP_PI'
5603: and paei.aei_information_category = 'NL_ABP_PI'
5604: and paei.aei_information3 = to_char(p_pension_type_id)
5605: and paei.assignment_id = p_assignment_id

Line 5738: l_asg_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type;

5734: )
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;

Line 5790: from per_assignment_extra_info paei

5786: --Cursor to find if the information record at the assignment level is valid
5787: -- on the date earned and if so return the asg extra info id
5788: CURSOR c_get_valid_asg_info Is
5789: Select paei.assignment_extra_info_id
5790: from per_assignment_extra_info paei
5791: where paei.information_type = 'NL_ABP_PI'
5792: and paei.aei_information_category = 'NL_ABP_PI'
5793: and paei.aei_information3 = to_char(p_pension_type_id)
5794: and paei.assignment_id = p_assignment_id

Line 7099: update per_assignment_extra_info

7095: hr_utility.set_location('... -- Updated prmtr_09 to the reporting date',10 );
7096:
7097: ELSIF p_chg_evt_cd = 'COAPP' THEN
7098:
7099: update per_assignment_extra_info
7100: set aei_information22 = NULL
7101: where assignment_extra_info_id = fnd_number.canonical_to_number(p_prmtr_03);
7102:
7103: END IF; -- If the change event code is COSCKFF

Line 7321: FROM per_assignment_extra_info

7317: --Cursor To detect Whether do additional calculation with Old/New functionality.
7318: CURSOR csr_addl_calc
7319: IS
7320: SELECT NVL(aei_information3,'Y') aei_information3
7321: FROM per_assignment_extra_info
7322: WHERE information_type = 'NL_ADDL_CALC'
7323: AND assignment_id = p_asg_id
7324: --AND p_date_earned BETWEEN fnd_date.canonical_to_date(aei_information1) AND fnd_date.canonical_to_date(nvl(aei_information2,'4712/12/31'));
7325: AND p_date_earned BETWEEN trunc(to_date(substr(aei_information1,1,10),'YYYY/MM/DD'))

Line 7328: l_addl_calc_flag per_assignment_extra_info.aei_information3%TYPE;

7324: --AND p_date_earned BETWEEN fnd_date.canonical_to_date(aei_information1) AND fnd_date.canonical_to_date(nvl(aei_information2,'4712/12/31'));
7325: AND p_date_earned BETWEEN trunc(to_date(substr(aei_information1,1,10),'YYYY/MM/DD'))
7326: AND trunc(to_date(substr(nvl(aei_information2,'4712/12/31'),1,10),'YYYY/MM/DD'));
7327:
7328: l_addl_calc_flag per_assignment_extra_info.aei_information3%TYPE;
7329:
7330: BEGIN
7331:
7332: hr_utility.set_location ('Entering function: pqp_nl_abp_functions.Get_Retro_Addnl_Amt' , 2100);