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

Line 2625: FROM per_person_analyses ppa

2621: ,c_person_id IN NUMBER
2622: ,c_id_flex_num IN NUMBER
2623: ,c_effective_date IN DATE) IS
2624: SELECT *
2625: FROM per_person_analyses ppa
2626: WHERE ppa.business_group_id = c_business_group_id
2627: AND ppa.person_id = c_person_id
2628: AND ppa.id_flex_num = c_id_flex_num
2629: AND c_effective_date BETWEEN nvl(ppa.date_from,c_effective_date)

Line 2631: l_per_analysis_rec per_person_analyses%ROWTYPE;

2627: AND ppa.person_id = c_person_id
2628: AND ppa.id_flex_num = c_id_flex_num
2629: AND c_effective_date BETWEEN nvl(ppa.date_from,c_effective_date)
2630: AND nvl(ppa.date_to,c_effective_date);
2631: l_per_analysis_rec per_person_analyses%ROWTYPE;
2632:
2633: CURSOR csr_kff_seg (c_anal_criteria_id IN NUMBER
2634: ,c_flex_num IN NUMBER
2635: ,c_effective_date IN DATE) IS