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 2251: ,ben_pl_f pln

2247: ,SUM(gda.duration_in_hours) sum_of_duration_in_hours
2248: ,SUM(gda.duration/gda.working_days_per_week) sum_of_duration_per_week
2249: ,SUM(gda.duration_in_hours/fte) sum_of_fte_hours
2250: FROM pqp_gap_absence_plans gap
2251: ,ben_pl_f pln
2252: ,pqp_gap_daily_absences gda
2253: WHERE gap.assignment_id IN -- automatically makes the assignment list distinct
2254: (SELECT other_asg.assignment_id
2255: FROM per_all_assignments_f this_asg

Line 2296: ,ben_pl_f pln

2292: ,SUM(gda.duration_in_hours) sum_of_duration_in_hours
2293: ,SUM(gda.duration/gda.working_days_per_week) sum_of_duration_per_week
2294: ,SUM(gda.duration_in_hours/fte) sum_of_fte_hours
2295: FROM pqp_gap_absence_plans gap
2296: ,ben_pl_f pln
2297: ,pqp_gap_daily_absences gda
2298: WHERE gap.assignment_id IN -- automatically makes the assignment list distinct
2299: (SELECT asg.assignment_id
2300: FROM per_all_assignments_f asg

Line 2329: ,ben_pl_f pln

2325: ,SUM(gda.duration/gda.working_days_per_week) sum_of_duration_per_week
2326: -- LG/PT
2327: ,SUM(gda.duration_in_hours/fte) sum_of_fte_hours
2328: FROM pqp_gap_absence_plans gap
2329: ,ben_pl_f pln
2330: ,pqp_gap_daily_absences gda
2331: WHERE gap.assignment_id = p_assignment_id
2332: AND gda.gap_absence_plan_id = gap.gap_absence_plan_id
2333: AND pln.pl_id = gap.pl_id

Line 2429: ,ben_pl_f pln

2425: ,'FC',abs.date_start
2426: )
2427: FROM pqp_gap_absence_plans gap
2428: ,per_absence_attendances abs
2429: ,ben_pl_f pln
2430: WHERE gap.assignment_id = p_assignment_id --an absence for this assignment
2431: AND pln.pl_typ_id = p_pl_typ_id --which is relevant, ie enrolled
2432: AND gap.pl_id = pln.pl_id --into a plan of atleast the same
2433: --plan type as the current one

Line 6338: ,ben_pl_f pl

6334: CURSOR csr_css_no_pay_days IS
6335: select NVL(SUM(gda.duration),0)
6336: from pqp_gap_daily_absences gda
6337: ,pqp_gap_absence_plans gap
6338: ,ben_pl_f pl
6339: where pl.pl_id = gap.pl_id
6340: and pl.pl_typ_id = p_pl_typ_id
6341: and gap.gap_absence_plan_id = gda.gap_absence_plan_id
6342: and gap.assignment_id = p_assignment_id

Line 6357: ,ben_pl_f pl

6353: CURSOR csr_css_no_pay_curpos IS
6354: select NVL(SUM(gda.duration),0)
6355: from pqp_gap_daily_absences gda
6356: ,pqp_gap_absence_plans gap
6357: ,ben_pl_f pl
6358: where gap.assignment_id IN
6359: -- automatically makes the assignment list distinct
6360: (SELECT other_asg.assignment_id
6361: FROM per_all_assignments_f this_asg

Line 6385: ,ben_pl_f pl

6381: CURSOR csr_css_no_pay_allpos(p_person_id IN NUMBER) IS
6382: select NVL(SUM(gda.duration),0)
6383: from pqp_gap_daily_absences gda
6384: ,pqp_gap_absence_plans gap
6385: ,ben_pl_f pl
6386: where gap.assignment_id IN
6387: -- automatically makes the assignment list distinct
6388: (SELECT asg.assignment_id
6389: FROM per_all_assignments_f asg

Line 6402: l_pl_typ_id ben_pl_f.pl_typ_id%TYPE ;

6398: and gda.absence_date between p_period_start_date
6399: and (p_period_end_date - 1); -- bug 7110645
6400:
6401:
6402: l_pl_typ_id ben_pl_f.pl_typ_id%TYPE ;
6403: BEGIN
6404:
6405: g_debug := hr_utility.debug_enabled;
6406: