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_ABSVAL_PKG dependencies on BEN_PL_F

Line 9: g_pl_id ben_pl_f.pl_typ_id%TYPE;

5:
6: g_package_name VARCHAR2(31):= 'pqp_absval_pkg.';
7:
8: g_plan_information rec_plan_information;
9: g_pl_id ben_pl_f.pl_typ_id%TYPE;
10: g_debug BOOLEAN:= hr_utility.debug_enabled;
11: -- Person Absence Aggregation globals
12: g_deduct_absence_for pqp_configuration_values.PCV_INFORMATION9%TYPE;
13:

Line 2272: ,ben_pl_f pln

2268: ,SUM(gda.duration_in_hours) sum_of_duration_in_hours
2269: ,SUM(gda.duration/gda.working_days_per_week) sum_of_duration_per_week
2270: ,SUM(gda.duration_in_hours/fte) sum_of_fte_hours
2271: FROM pqp_gap_absence_plans gap
2272: ,ben_pl_f pln
2273: ,pqp_gap_daily_absences gda
2274: WHERE gap.assignment_id IN -- automatically makes the assignment list distinct
2275: (SELECT other_asg.assignment_id
2276: FROM per_all_assignments_f this_asg

Line 2317: ,ben_pl_f pln

2313: ,SUM(gda.duration_in_hours) sum_of_duration_in_hours
2314: ,SUM(gda.duration/gda.working_days_per_week) sum_of_duration_per_week
2315: ,SUM(gda.duration_in_hours/fte) sum_of_fte_hours
2316: FROM pqp_gap_absence_plans gap
2317: ,ben_pl_f pln
2318: ,pqp_gap_daily_absences gda
2319: WHERE gap.assignment_id IN -- automatically makes the assignment list distinct
2320: (SELECT asg.assignment_id
2321: FROM per_all_assignments_f asg

Line 2350: ,ben_pl_f pln

2346: ,SUM(gda.duration/gda.working_days_per_week) sum_of_duration_per_week
2347: -- LG/PT
2348: ,SUM(gda.duration_in_hours/fte) sum_of_fte_hours
2349: FROM pqp_gap_absence_plans gap
2350: ,ben_pl_f pln
2351: ,pqp_gap_daily_absences gda
2352: WHERE gap.assignment_id = p_assignment_id
2353: AND gda.gap_absence_plan_id = gap.gap_absence_plan_id
2354: AND pln.pl_id = gap.pl_id

Line 2450: ,ben_pl_f pln

2446: ,'FC',abs.date_start
2447: )
2448: FROM pqp_gap_absence_plans gap
2449: ,per_absence_attendances abs
2450: ,ben_pl_f pln
2451: WHERE gap.assignment_id = p_assignment_id --an absence for this assignment
2452: AND pln.pl_typ_id = p_pl_typ_id --which is relevant, ie enrolled
2453: AND gap.pl_id = pln.pl_id --into a plan of atleast the same
2454: --plan type as the current one

Line 6373: ,ben_pl_f pl

6369: CURSOR csr_css_no_pay_days IS
6370: select NVL(SUM(gda.duration),0)
6371: from pqp_gap_daily_absences gda
6372: ,pqp_gap_absence_plans gap
6373: ,ben_pl_f pl
6374: ,hr_lookups hrl --added extra 7585452
6375: where pl.pl_id = gap.pl_id
6376: and pl.pl_typ_id = p_pl_typ_id
6377: and gap.gap_absence_plan_id = gda.gap_absence_plan_id

Line 6402: ,ben_pl_f pl

6398: CURSOR csr_css_no_pay_curpos IS
6399: select NVL(SUM(gda.duration),0)
6400: from pqp_gap_daily_absences gda
6401: ,pqp_gap_absence_plans gap
6402: ,ben_pl_f pl
6403: ,hr_lookups hrl --added extra 7585452
6404: where gap.assignment_id IN
6405: -- automatically makes the assignment list distinct
6406: (SELECT other_asg.assignment_id

Line 6442: ,ben_pl_f pl

6438: CURSOR csr_css_no_pay_allpos(p_person_id IN NUMBER) IS
6439: select NVL(SUM(gda.duration),0)
6440: from pqp_gap_daily_absences gda
6441: ,pqp_gap_absence_plans gap
6442: ,ben_pl_f pl
6443: ,hr_lookups hrl --added extra 7585452
6444: where gap.assignment_id IN
6445: -- automatically makes the assignment list distinct
6446: (SELECT asg.assignment_id

Line 6462: l_pl_typ_id ben_pl_f.pl_typ_id%TYPE ;

6458: and gda.absence_date between p_period_start_date
6459: and (p_period_end_date - 1); -- bug 7110645
6460:
6461:
6462: l_pl_typ_id ben_pl_f.pl_typ_id%TYPE ;
6463: BEGIN
6464:
6465: g_debug := hr_utility.debug_enabled;
6466: