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 HR_LOOKUPS

Line 2582: FROM hr_lookups hrl

2578:
2579: CURSOR csr_ckh_lookup(p_lookup_type VARCHAR2)
2580: IS
2581: SELECT *
2582: FROM hr_lookups hrl
2583: WHERE hrl.lookup_type = p_lookup_type ;
2584:
2585:
2586:

Line 6374: ,hr_lookups hrl --added extra 7585452

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
6378: and gap.assignment_id = p_assignment_id

Line 6403: ,hr_lookups hrl --added extra 7585452

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
6407: FROM per_all_assignments_f this_asg

Line 6443: ,hr_lookups hrl --added extra 7585452

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
6447: FROM per_all_assignments_f asg