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_PENSION_EXTRACTS dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 2591: FROM per_assignment_extra_info

2587: ) RETURN Number IS
2588:
2589: CURSOR c_obj_cd IS
2590: SELECT Decode(aei_information5,'Y','J',' ') obj_cd
2591: FROM per_assignment_extra_info
2592: WHERE assignment_id = p_assignment_id
2593: AND information_type = 'NL_USZO_INFO'
2594: AND Trunc(p_effective_date) BETWEEN
2595: Fnd_Date.canonical_to_date(aei_information1)AND

Line 6476: FROM per_assignment_extra_info

6472: ) RETURN NUMBER IS
6473:
6474: CURSOR c_get_old_num IS
6475: SELECT NVL(lpad(aei_information2,2,'0'),'00') old_num
6476: FROM per_assignment_extra_info
6477: WHERE assignment_id = p_assignment_id
6478: AND information_type = 'PQP_NL_ABP_OLD_EE_INFO';
6479:
6480: l_proc_name VARCHAR2(150) := g_proc_name ||'Get_Old_Asg_Seq_Num';

Line 6767: FROM per_assignment_extra_info

6763: -- Cursor to fetch the old employee number
6764: --
6765: CURSOR csr_get_old_ee_num IS
6766: SELECT NVL(lpad(aei_information1,15,'0'),'000000000000000') old_num
6767: FROM per_assignment_extra_info
6768: WHERE assignment_id = p_assignment_id
6769: AND information_type = 'PQP_NL_ABP_OLD_EE_INFO';
6770:
6771: l_old_ee_num VARCHAR2(30) ;

Line 7287: FROM per_assignment_extra_info

7283: --
7284: CURSOR c_get_override_salary IS
7285: SELECT NVL(aei_information6,'0') ,
7286: TRUNC(fnd_date.canonical_to_date(aei_information1))
7287: FROM per_assignment_extra_info
7288: WHERE assignment_id = p_assignment_id
7289: AND information_type = 'NL_ABP_PAR_INFO'
7290: AND aei_information_category = 'NL_ABP_PAR_INFO'
7291: AND p_effective_date BETWEEN

Line 7839: FROM per_assignment_extra_info

7835: RETURN NUMBER IS
7836:
7837: CURSOR c_data_entered IS
7838: SELECT 1
7839: FROM per_assignment_extra_info
7840: WHERE assignment_id = p_assignment_id
7841: AND information_type = 'PQP_NL_ABP_OLD_EE_INFO';
7842:
7843: l_proc_name VARCHAR2(150) := g_proc_name ||'Record01_Display_Criteria';

Line 9917: FROM per_assignment_extra_info paei,

9913: AND bec.business_group_id = p_business_group_id;
9914:
9915: CURSOR c_ppp_asg1 IS
9916: SELECT 1
9917: FROM per_assignment_extra_info paei,
9918: pqp_pension_types_f pty
9919: WHERE paei.information_type = 'NL_ABP_PI'
9920: AND paei.aei_information_category = 'NL_ABP_PI'
9921: AND paei.assignment_id = p_assignment_id

Line 10139: FROM per_assignment_extra_info paei1

10135: AND p_effective_date BETWEEN fnd_date.canonical_to_date(hoi.org_information1)
10136: AND fnd_date.canonical_to_date(NVL(hoi.org_information2,
10137: fnd_date.date_to_canonical(hr_api.g_eot)))
10138: AND NOT EXISTS (SELECT 1
10139: FROM per_assignment_extra_info paei1
10140: WHERE paei1.information_type='NL_ABP_RI'
10141: AND paei1.aei_information_category='NL_ABP_RI'
10142: AND paei1.assignment_id = p_assignment_id
10143: AND paei1.aei_information3 = 'G'

Line 10155: FROM per_assignment_extra_info paei,

10151: ,'FPU_E','C'
10152: ,'FPU_R','A'
10153: ,'FPU_S','S'
10154: ,'FPU_T' ,'B') fpu_code
10155: FROM per_assignment_extra_info paei,
10156: pqp_pension_types_f pty
10157: WHERE paei.information_type = 'NL_ABP_PI'
10158: AND paei.aei_information_category = 'NL_ABP_PI'
10159: AND paei.assignment_id = p_assignment_id

Line 10171: FROM per_assignment_extra_info paei1

10167: AND p_effective_date between fnd_date.canonical_to_date(paei.aei_information1)
10168: AND fnd_date.canonical_to_date(NVL(paei.aei_information2,
10169: fnd_date.date_to_canonical(hr_api.g_eot)))
10170: AND NOT EXISTS (SELECT 1
10171: FROM per_assignment_extra_info paei1
10172: WHERE paei1.information_type='NL_ABP_RI'
10173: AND paei1.aei_information_category='NL_ABP_RI'
10174: AND paei1.assignment_id = p_assignment_id
10175: AND paei1.aei_information3 = 'G'

Line 10237: FROM per_assignment_extra_info

10233:
10234: --cursor to fetch the contribution kind from the ASG EIT
10235: CURSOR c_get_contrib_kind IS
10236: SELECT Substr(Nvl(aei_information4,'G'),0,1)
10237: FROM per_assignment_extra_info
10238: WHERE assignment_id = p_assignment_id
10239: AND p_effective_date BETWEEN Fnd_Date.canonical_to_date(aei_information1)
10240: AND Fnd_Date.canonical_to_date(Nvl(aei_information2,Fnd_Date.date_to_canonical(Hr_Api.g_eot)))
10241: AND aei_information_category = 'NL_ABP_RI'

Line 10281: FROM per_assignment_extra_info paei

10277: SELECT fnd_date.canonical_to_date(aei_information1) start_dt
10278: ,fnd_date.canonical_to_date(NVL(aei_information2,'4712/12/31 00:00:00')) end_dt
10279: ,aei_information4 kind
10280: ,LEAST(fnd_number.canonical_to_number(aei_information5),1) * 100 value
10281: FROM per_assignment_extra_info paei
10282: WHERE paei.assignment_id = p_assignment_id
10283: AND aei_information4 IS NOT NULL
10284: AND paei.information_type = 'NL_ABP_PAR_INFO'
10285: AND fnd_date.canonical_to_date(aei_information1)

Line 10289: FROM per_assignment_extra_info paei1

10285: AND fnd_date.canonical_to_date(aei_information1)
10286: BETWEEN g_extract_params(p_business_group_id).extract_start_date
10287: AND g_extract_params(p_business_group_id).extract_end_date
10288: AND NOT EXISTS ( SELECT 1
10289: FROM per_assignment_extra_info paei1
10290: WHERE paei1.assignment_id = p_assignment_id
10291: AND paei1.information_type = 'NL_ABP_PAR_INFO'
10292: AND fnd_date.canonical_to_date(paei1.aei_information1) <
10293: g_extract_params(p_business_group_id).extract_start_date

Line 10304: FROM per_assignment_extra_info paei

10300: SELECT fnd_date.canonical_to_date(aei_information1) start_dt
10301: ,fnd_date.canonical_to_date(NVL(aei_information2,'4712/12/31 00:00:00')) end_dt
10302: ,aei_information4 kind
10303: ,LEAST(fnd_number.canonical_to_number(aei_information5),1) * 100 value
10304: FROM per_assignment_extra_info paei
10305: WHERE paei.assignment_id = p_assignment_id
10306: AND aei_information4 IS NOT NULL
10307: AND paei.information_type = 'NL_ABP_PAR_INFO'
10308: AND fnd_date.canonical_to_date(aei_information1)

Line 10324: FROM per_assignment_extra_info paei

10320:
10321: CURSOR c_chk_ptpn_continues (c_end_date IN DATE
10322: ,c_ptpn_kind IN VARCHAR2) IS
10323: SELECT 1
10324: FROM per_assignment_extra_info paei
10325: WHERE paei.assignment_id = p_assignment_id
10326: AND aei_information4 = c_ptpn_kind
10327: AND aei_information4 is not null
10328: AND paei.information_type = 'NL_ABP_PAR_INFO'

Line 10419: FROM per_assignment_extra_info paei

10415:
10416: CURSOR c_asg_info ( c_pt_id IN NUMBER) IS
10417: SELECT fnd_date.canonical_to_date(aei_information1) start_dt
10418: ,fnd_date.canonical_to_date(NVL(aei_information2,'4712/12/31 00:00:00')) end_dt
10419: FROM per_assignment_extra_info paei
10420: WHERE paei.assignment_id = p_assignment_id
10421: AND fnd_number.canonical_to_number(aei_information3) = c_pt_id
10422: AND paei.information_type = 'NL_ABP_PI'
10423: AND fnd_date.canonical_to_date(aei_information1)

Line 10427: FROM per_assignment_extra_info paei1

10423: AND fnd_date.canonical_to_date(aei_information1)
10424: BETWEEN g_extract_params(p_business_group_id).extract_start_date
10425: AND g_extract_params(p_business_group_id).extract_end_date
10426: AND NOT EXISTS ( SELECT 1
10427: FROM per_assignment_extra_info paei1
10428: WHERE paei1.assignment_id = p_assignment_id
10429: AND paei1.information_type = 'NL_ABP_PI'
10430: AND fnd_date.canonical_to_date(paei1.aei_information1) <
10431: g_extract_params(p_business_group_id).extract_start_date

Line 10439: FROM per_assignment_extra_info paei

10435: )
10436: UNION
10437: SELECT fnd_date.canonical_to_date(aei_information1) start_dt
10438: ,fnd_date.canonical_to_date(NVL(aei_information2,'4712/12/31 00:00:00')) end_dt
10439: FROM per_assignment_extra_info paei
10440: WHERE paei.assignment_id = p_assignment_id
10441: AND fnd_number.canonical_to_number(aei_information3) = c_pt_id
10442: AND paei.information_type = 'NL_ABP_PI'
10443: AND fnd_date.canonical_to_date(aei_information1)

Line 10459: FROM per_assignment_extra_info paei

10455:
10456: CURSOR c_chk_ptpn_continues (c_end_date IN DATE,
10457: c_pt_id IN NUMBER) IS
10458: SELECT 1
10459: FROM per_assignment_extra_info paei
10460: WHERE paei.assignment_id = p_assignment_id
10461: AND fnd_number.canonical_to_number(aei_information3) = c_pt_id
10462: AND paei.information_type = 'NL_ABP_PI'
10463: AND fnd_date.canonical_to_date(aei_information1) = c_end_date + 1;

Line 10653: FROM per_assignment_extra_info

10649: --
10650: CURSOR c_get_participation_detl IS
10651: SELECT Nvl(aei_information4,'WNE') kind,
10652: LEAST(Nvl(fnd_number.canonical_to_number(aei_information5),1),1) VALUE
10653: FROM per_assignment_extra_info
10654: WHERE information_type = 'NL_ABP_PAR_INFO'
10655: AND aei_information_category = 'NL_ABP_PAR_INFO'
10656: AND assignment_id = p_assignment_id
10657: AND p_effective_date BETWEEN Fnd_Date.canonical_to_date(aei_information1)

Line 10806: FROM per_assignment_extra_info paei

10802:
10803: CURSOR c_chk_ptpn_continues (c_end_date IN DATE,
10804: c_pt_id IN NUMBER) IS
10805: SELECT 1
10806: FROM per_assignment_extra_info paei
10807: WHERE paei.assignment_id = p_assignment_id
10808: AND fnd_number.canonical_to_number(aei_information3) = c_pt_id
10809: AND paei.information_type = 'NL_ABP_PI'
10810: AND fnd_date.canonical_to_date(aei_information1) = c_end_date + 1;

Line 10815: FROM per_assignment_extra_info paei

10811:
10812: CURSOR c_chk_ptpn_continues_kind (c_end_date IN DATE
10813: ,c_ptpn_kind IN VARCHAR2) IS
10814: SELECT 1
10815: FROM per_assignment_extra_info paei
10816: WHERE paei.assignment_id = p_assignment_id
10817: AND aei_information4 = c_ptpn_kind
10818: AND aei_information4 is not null
10819: AND paei.information_type = 'NL_ABP_PAR_INFO'

Line 12479: FROM per_assignment_extra_info

12475: ORDER BY ext_chg_evt_log_id desc;
12476:
12477: CURSOR or_pen_sal ( c_nh_date IN DATE) IS
12478: SELECT 1
12479: FROM per_assignment_extra_info
12480: WHERE assignment_id = p_assignment_id
12481: AND aei_information_category = 'NL_ABP_PAR_INFO'
12482: AND information_type = 'NL_ABP_PAR_INFO'
12483: AND trunc(c_nh_date) BETWEEN fnd_date.canonical_to_date(aei_information1)

Line 13956: FROM per_assignment_extra_info

13952:
13953: --cursor to fetch the contribution kind from the ASG EIT
13954: CURSOR c_get_contrib_kind IS
13955: SELECT Substr(Nvl(aei_information7,'D'),0,1)
13956: FROM per_assignment_extra_info
13957: WHERE assignment_id = p_assignment_id
13958: AND p_effective_date BETWEEN Fnd_Date.canonical_to_date(aei_information1)
13959: AND Fnd_Date.canonical_to_date(Nvl(aei_information2,Fnd_Date.date_to_canonical(Hr_Api.g_eot)))
13960: AND aei_information_category = 'NL_ABP_RI'

Line 14037: FROM per_assignment_extra_info

14033:
14034: --cursor to fetch the insurance type data from the assignment EIT
14035: CURSOR c_get_ins_type IS
14036: SELECT Substr(Nvl(aei_information5,'01'),0,2),Substr(Nvl(aei_information6,'01'),0,2)
14037: FROM per_assignment_extra_info
14038: WHERE assignment_id = p_assignment_id
14039: AND aei_information_category = 'NL_ABP_RI'
14040: AND information_type = 'NL_ABP_RI'
14041: AND p_effective_date BETWEEN Fnd_Date.canonical_to_date(aei_information1)

Line 14088: FROM per_assignment_extra_info

14084:
14085: --cursor to fetch the incidental worker status from the ASG EIT
14086: CURSOR c_get_incidental_wrkr IS
14087: SELECT Nvl(aei_information3,'0')
14088: FROM per_assignment_extra_info
14089: WHERE information_type = 'NL_USZO_INFO'
14090: AND aei_information_category = 'NL_USZO_INFO'
14091: AND assignment_id = p_assignment_id
14092: AND p_effective_date BETWEEN Fnd_Date.canonical_to_date(aei_information1)

Line 14203: FROM per_assignment_extra_info

14199: ) RETURN NUMBER IS
14200:
14201: CURSOR csr_get_dt (c_assignment_id IN NUMBER) IS
14202: SELECT fnd_date.canonical_to_date(aei_information3)
14203: FROM per_assignment_extra_info
14204: WHERE assignment_id = p_assignment_id
14205: AND information_type = 'PQP_NL_ABP_OLD_EE_INFO';
14206:
14207: l_return_value NUMBER := -1;