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

Line 2720: FROM per_assignment_extra_info

2716:
2717: --cursor to check if an asg eit row exists for the PT
2718: CURSOR c_chk_asg_info(c_pension_type_id IN pqp_pension_types_f.pension_type_id%TYPE) IS
2719: SELECT 1
2720: FROM per_assignment_extra_info
2721: WHERE aei_information_category = 'NL_ABP_PI'
2722: AND information_type = 'NL_ABP_PI'
2723: AND aei_information3 = to_char(c_pension_type_id);
2724:

Line 2742: FROM per_assignment_extra_info

2738:
2739: --cursor to get the end date for the asg eit row for this PT
2740: CURSOR c_asg_info_end_dt(c_pension_type_id IN pqp_pension_types_f.pension_type_id%TYPE) IS
2741: SELECT fnd_date.canonical_to_date(nvl(aei_information2,'4712/12/31')) asg_info_end_dt
2742: FROM per_assignment_extra_info
2743: WHERE aei_information3 = to_char(c_pension_type_id)
2744: AND aei_information_category = 'NL_ABP_PI'
2745: AND information_type = 'NL_ABP_PI';
2746: