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 2612: FROM per_assignment_extra_info

2608: ) RETURN Number IS
2609:
2610: CURSOR c_obj_cd IS
2611: SELECT Decode(aei_information5,'Y','J',' ') obj_cd
2612: FROM per_assignment_extra_info
2613: WHERE assignment_id = p_assignment_id
2614: AND information_type = 'NL_USZO_INFO'
2615: AND Trunc(p_effective_date) BETWEEN
2616: Fnd_Date.canonical_to_date(aei_information1)AND

Line 6814: FROM per_assignment_extra_info

6810: ) RETURN NUMBER IS
6811:
6812: CURSOR c_get_old_num IS
6813: SELECT NVL(lpad(aei_information2,2,'0'),'00') old_num
6814: FROM per_assignment_extra_info
6815: WHERE assignment_id = p_assignment_id
6816: AND information_type = 'PQP_NL_ABP_OLD_EE_INFO';
6817:
6818: l_proc_name VARCHAR2(150) := g_proc_name ||'Get_Old_Asg_Seq_Num';

Line 7106: FROM per_assignment_extra_info

7102: -- Cursor to fetch the old employee number
7103: --
7104: CURSOR csr_get_old_ee_num IS
7105: SELECT NVL(lpad(aei_information1,15,'0'),'000000000000000') old_num
7106: FROM per_assignment_extra_info
7107: WHERE assignment_id = p_assignment_id
7108: AND information_type = 'PQP_NL_ABP_OLD_EE_INFO';
7109:
7110: l_old_ee_num VARCHAR2(30) ;

Line 7626: FROM per_assignment_extra_info

7622: --
7623: CURSOR c_get_override_salary IS
7624: SELECT NVL(aei_information6,'0') ,
7625: TRUNC(fnd_date.canonical_to_date(aei_information1))
7626: FROM per_assignment_extra_info
7627: WHERE assignment_id = p_assignment_id
7628: AND information_type = 'NL_ABP_PAR_INFO'
7629: AND aei_information_category = 'NL_ABP_PAR_INFO'
7630: AND p_effective_date BETWEEN

Line 8178: FROM per_assignment_extra_info

8174: RETURN NUMBER IS
8175:
8176: CURSOR c_data_entered IS
8177: SELECT 1
8178: FROM per_assignment_extra_info
8179: WHERE assignment_id = p_assignment_id
8180: AND information_type = 'PQP_NL_ABP_OLD_EE_INFO';
8181:
8182: l_proc_name VARCHAR2(150) := g_proc_name ||'Record01_Display_Criteria';

Line 10256: FROM per_assignment_extra_info paei,

10252: AND bec.business_group_id = p_business_group_id;
10253:
10254: CURSOR c_ppp_asg1 IS
10255: SELECT 1
10256: FROM per_assignment_extra_info paei,
10257: pqp_pension_types_f pty
10258: WHERE paei.information_type = 'NL_ABP_PI'
10259: AND paei.aei_information_category = 'NL_ABP_PI'
10260: AND paei.assignment_id = p_assignment_id

Line 10478: FROM per_assignment_extra_info paei1

10474: AND p_effective_date BETWEEN fnd_date.canonical_to_date(hoi.org_information1)
10475: AND fnd_date.canonical_to_date(NVL(hoi.org_information2,
10476: fnd_date.date_to_canonical(hr_api.g_eot)))
10477: AND NOT EXISTS (SELECT 1
10478: FROM per_assignment_extra_info paei1
10479: WHERE paei1.information_type='NL_ABP_RI'
10480: AND paei1.aei_information_category='NL_ABP_RI'
10481: AND paei1.assignment_id = p_assignment_id
10482: AND paei1.aei_information3 = 'G'

Line 10494: FROM per_assignment_extra_info paei,

10490: ,'FPU_E','C'
10491: ,'FPU_R','A'
10492: ,'FPU_S','S'
10493: ,'FPU_T' ,'B') fpu_code
10494: FROM per_assignment_extra_info paei,
10495: pqp_pension_types_f pty
10496: WHERE paei.information_type = 'NL_ABP_PI'
10497: AND paei.aei_information_category = 'NL_ABP_PI'
10498: AND paei.assignment_id = p_assignment_id

Line 10510: FROM per_assignment_extra_info paei1

10506: AND p_effective_date between fnd_date.canonical_to_date(paei.aei_information1)
10507: AND fnd_date.canonical_to_date(NVL(paei.aei_information2,
10508: fnd_date.date_to_canonical(hr_api.g_eot)))
10509: AND NOT EXISTS (SELECT 1
10510: FROM per_assignment_extra_info paei1
10511: WHERE paei1.information_type='NL_ABP_RI'
10512: AND paei1.aei_information_category='NL_ABP_RI'
10513: AND paei1.assignment_id = p_assignment_id
10514: AND paei1.aei_information3 = 'G'

Line 10576: FROM per_assignment_extra_info

10572:
10573: --cursor to fetch the contribution kind from the ASG EIT
10574: CURSOR c_get_contrib_kind IS
10575: SELECT Substr(Nvl(aei_information4,'G'),0,1)
10576: FROM per_assignment_extra_info
10577: WHERE assignment_id = p_assignment_id
10578: AND p_effective_date BETWEEN Fnd_Date.canonical_to_date(aei_information1)
10579: AND Fnd_Date.canonical_to_date(Nvl(aei_information2,Fnd_Date.date_to_canonical(Hr_Api.g_eot)))
10580: AND aei_information_category = 'NL_ABP_RI'

Line 10620: FROM per_assignment_extra_info paei

10616: SELECT fnd_date.canonical_to_date(aei_information1) start_dt
10617: ,fnd_date.canonical_to_date(NVL(aei_information2,'4712/12/31 00:00:00')) end_dt
10618: ,aei_information4 kind
10619: ,LEAST(fnd_number.canonical_to_number(aei_information5),1) * 100 value
10620: FROM per_assignment_extra_info paei
10621: WHERE paei.assignment_id = p_assignment_id
10622: AND aei_information4 IS NOT NULL
10623: AND paei.information_type = 'NL_ABP_PAR_INFO'
10624: AND fnd_date.canonical_to_date(aei_information1)

Line 10628: FROM per_assignment_extra_info paei1

10624: AND fnd_date.canonical_to_date(aei_information1)
10625: BETWEEN g_extract_params(p_business_group_id).extract_start_date
10626: AND g_extract_params(p_business_group_id).extract_end_date
10627: AND NOT EXISTS ( SELECT 1
10628: FROM per_assignment_extra_info paei1
10629: WHERE paei1.assignment_id = p_assignment_id
10630: AND paei1.information_type = 'NL_ABP_PAR_INFO'
10631: AND fnd_date.canonical_to_date(paei1.aei_information1) <
10632: g_extract_params(p_business_group_id).extract_start_date

Line 10643: FROM per_assignment_extra_info paei

10639: SELECT fnd_date.canonical_to_date(aei_information1) start_dt
10640: ,fnd_date.canonical_to_date(NVL(aei_information2,'4712/12/31 00:00:00')) end_dt
10641: ,aei_information4 kind
10642: ,LEAST(fnd_number.canonical_to_number(aei_information5),1) * 100 value
10643: FROM per_assignment_extra_info paei
10644: WHERE paei.assignment_id = p_assignment_id
10645: AND aei_information4 IS NOT NULL
10646: AND paei.information_type = 'NL_ABP_PAR_INFO'
10647: AND fnd_date.canonical_to_date(aei_information1)

Line 10663: FROM per_assignment_extra_info paei

10659:
10660: CURSOR c_chk_ptpn_continues (c_end_date IN DATE
10661: ,c_ptpn_kind IN VARCHAR2) IS
10662: SELECT 1
10663: FROM per_assignment_extra_info paei
10664: WHERE paei.assignment_id = p_assignment_id
10665: AND aei_information4 = c_ptpn_kind
10666: AND aei_information4 is not null
10667: AND paei.information_type = 'NL_ABP_PAR_INFO'

Line 10758: FROM per_assignment_extra_info paei

10754:
10755: CURSOR c_asg_info ( c_pt_id IN NUMBER) IS
10756: SELECT fnd_date.canonical_to_date(aei_information1) start_dt
10757: ,fnd_date.canonical_to_date(NVL(aei_information2,'4712/12/31 00:00:00')) end_dt
10758: FROM per_assignment_extra_info paei
10759: WHERE paei.assignment_id = p_assignment_id
10760: AND fnd_number.canonical_to_number(aei_information3) = c_pt_id
10761: AND paei.information_type = 'NL_ABP_PI'
10762: AND fnd_date.canonical_to_date(aei_information1)

Line 10766: FROM per_assignment_extra_info paei1

10762: AND fnd_date.canonical_to_date(aei_information1)
10763: BETWEEN g_extract_params(p_business_group_id).extract_start_date
10764: AND g_extract_params(p_business_group_id).extract_end_date
10765: AND NOT EXISTS ( SELECT 1
10766: FROM per_assignment_extra_info paei1
10767: WHERE paei1.assignment_id = p_assignment_id
10768: AND paei1.information_type = 'NL_ABP_PI'
10769: AND fnd_date.canonical_to_date(paei1.aei_information1) <
10770: g_extract_params(p_business_group_id).extract_start_date

Line 10778: FROM per_assignment_extra_info paei

10774: )
10775: UNION
10776: SELECT fnd_date.canonical_to_date(aei_information1) start_dt
10777: ,fnd_date.canonical_to_date(NVL(aei_information2,'4712/12/31 00:00:00')) end_dt
10778: FROM per_assignment_extra_info paei
10779: WHERE paei.assignment_id = p_assignment_id
10780: AND fnd_number.canonical_to_number(aei_information3) = c_pt_id
10781: AND paei.information_type = 'NL_ABP_PI'
10782: AND fnd_date.canonical_to_date(aei_information1)

Line 10798: FROM per_assignment_extra_info paei

10794:
10795: CURSOR c_chk_ptpn_continues (c_end_date IN DATE,
10796: c_pt_id IN NUMBER) IS
10797: SELECT 1
10798: FROM per_assignment_extra_info paei
10799: WHERE paei.assignment_id = p_assignment_id
10800: AND fnd_number.canonical_to_number(aei_information3) = c_pt_id
10801: AND paei.information_type = 'NL_ABP_PI'
10802: AND fnd_date.canonical_to_date(aei_information1) = c_end_date + 1;

Line 10992: FROM per_assignment_extra_info

10988: --
10989: CURSOR c_get_participation_detl IS
10990: SELECT Nvl(aei_information4,'WNE') kind,
10991: LEAST(Nvl(fnd_number.canonical_to_number(aei_information5),1),1) VALUE
10992: FROM per_assignment_extra_info
10993: WHERE information_type = 'NL_ABP_PAR_INFO'
10994: AND aei_information_category = 'NL_ABP_PAR_INFO'
10995: AND assignment_id = p_assignment_id
10996: AND p_effective_date BETWEEN Fnd_Date.canonical_to_date(aei_information1)

Line 11145: FROM per_assignment_extra_info paei

11141:
11142: CURSOR c_chk_ptpn_continues (c_end_date IN DATE,
11143: c_pt_id IN NUMBER) IS
11144: SELECT 1
11145: FROM per_assignment_extra_info paei
11146: WHERE paei.assignment_id = p_assignment_id
11147: AND fnd_number.canonical_to_number(aei_information3) = c_pt_id
11148: AND paei.information_type = 'NL_ABP_PI'
11149: AND fnd_date.canonical_to_date(aei_information1) = c_end_date + 1;

Line 11154: FROM per_assignment_extra_info paei

11150:
11151: CURSOR c_chk_ptpn_continues_kind (c_end_date IN DATE
11152: ,c_ptpn_kind IN VARCHAR2) IS
11153: SELECT 1
11154: FROM per_assignment_extra_info paei
11155: WHERE paei.assignment_id = p_assignment_id
11156: AND aei_information4 = c_ptpn_kind
11157: AND aei_information4 is not null
11158: AND paei.information_type = 'NL_ABP_PAR_INFO'

Line 12848: FROM per_assignment_extra_info

12844: ORDER BY ext_chg_evt_log_id desc;
12845:
12846: CURSOR or_pen_sal ( c_nh_date IN DATE) IS
12847: SELECT 1
12848: FROM per_assignment_extra_info
12849: WHERE assignment_id = p_assignment_id
12850: AND aei_information_category = 'NL_ABP_PAR_INFO'
12851: AND information_type = 'NL_ABP_PAR_INFO'
12852: AND trunc(c_nh_date) BETWEEN fnd_date.canonical_to_date(aei_information1)

Line 14325: FROM per_assignment_extra_info

14321:
14322: --cursor to fetch the contribution kind from the ASG EIT
14323: CURSOR c_get_contrib_kind IS
14324: SELECT Substr(Nvl(aei_information7,'D'),0,1)
14325: FROM per_assignment_extra_info
14326: WHERE assignment_id = p_assignment_id
14327: AND p_effective_date BETWEEN Fnd_Date.canonical_to_date(aei_information1)
14328: AND Fnd_Date.canonical_to_date(Nvl(aei_information2,Fnd_Date.date_to_canonical(Hr_Api.g_eot)))
14329: AND aei_information_category = 'NL_ABP_RI'

Line 14406: FROM per_assignment_extra_info

14402:
14403: --cursor to fetch the insurance type data from the assignment EIT
14404: CURSOR c_get_ins_type IS
14405: SELECT Substr(Nvl(aei_information5,'01'),0,2),Substr(Nvl(aei_information6,'01'),0,2)
14406: FROM per_assignment_extra_info
14407: WHERE assignment_id = p_assignment_id
14408: AND aei_information_category = 'NL_ABP_RI'
14409: AND information_type = 'NL_ABP_RI'
14410: AND p_effective_date BETWEEN Fnd_Date.canonical_to_date(aei_information1)

Line 14457: FROM per_assignment_extra_info

14453:
14454: --cursor to fetch the incidental worker status from the ASG EIT
14455: CURSOR c_get_incidental_wrkr IS
14456: SELECT Nvl(aei_information3,'0')
14457: FROM per_assignment_extra_info
14458: WHERE information_type = 'NL_USZO_INFO'
14459: AND aei_information_category = 'NL_USZO_INFO'
14460: AND assignment_id = p_assignment_id
14461: AND p_effective_date BETWEEN Fnd_Date.canonical_to_date(aei_information1)

Line 14572: FROM per_assignment_extra_info

14568: ) RETURN NUMBER IS
14569:
14570: CURSOR csr_get_dt (c_assignment_id IN NUMBER) IS
14571: SELECT fnd_date.canonical_to_date(aei_information3)
14572: FROM per_assignment_extra_info
14573: WHERE assignment_id = p_assignment_id
14574: AND information_type = 'PQP_NL_ABP_OLD_EE_INFO';
14575:
14576: l_return_value NUMBER := -1;