APPS.PQP_ABSVAL_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 171: FROM per_all_assignments_f assign

167: -- Added cursor for anniversary year changes
168: CURSOR csr_get_emp_hire_date
169: IS
170: SELECT service.date_start
171: FROM per_all_assignments_f assign
172: ,per_periods_of_service service
173: WHERE p_balance_effective_date BETWEEN assign.effective_start_date
174: AND assign.effective_end_date
175: AND assign.assignment_id = p_assignment_id

Line 2276: FROM per_all_assignments_f this_asg

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
2277: ,per_all_assignments_f other_asg
2278: WHERE this_asg.assignment_id = p_assignment_id
2279: AND other_asg.person_id = this_asg.person_id
2280: AND other_asg.primary_flag = 'Y'

Line 2277: ,per_all_assignments_f other_asg

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
2277: ,per_all_assignments_f other_asg
2278: WHERE this_asg.assignment_id = p_assignment_id
2279: AND other_asg.person_id = this_asg.person_id
2280: AND other_asg.primary_flag = 'Y'
2281: AND other_asg.period_of_service_id = this_asg.period_of_service_id

Line 2304: FROM per_all_assignments_f asg

2300: debug(l_proc_name,l_proc_step);
2301: END IF;
2302: SELECT asg.person_id
2303: INTO l_person_id
2304: FROM per_all_assignments_f asg
2305: WHERE asg.assignment_id = p_assignment_id
2306: AND ROWNUM < 2;
2307: IF g_debug THEN
2308: debug('l_person_id:' ,l_person_id);

Line 2321: FROM per_all_assignments_f asg

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
2322: WHERE asg.person_id = l_person_id
2323: AND asg.primary_flag = 'Y'
2324: )
2325: AND gda.gap_absence_plan_id = gap.gap_absence_plan_id

Line 2439: (p_assignment_id per_all_assignments_f.assignment_id%TYPE

2435: ) RETURN DATE
2436: IS
2437:
2438: CURSOR csr_adjusted_scheme_start_date
2439: (p_assignment_id per_all_assignments_f.assignment_id%TYPE
2440: ,p_pl_typ_id ben_pl_typ_f.pl_typ_id%TYPE
2441: ,p_scheme_start_date DATE
2442: ) IS
2443: SELECT

Line 6407: FROM per_all_assignments_f this_asg

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
6408: ,per_all_assignments_f other_asg
6409: WHERE this_asg.assignment_id = p_assignment_id
6410: AND other_asg.person_id = this_asg.person_id
6411: AND other_asg.primary_flag = 'Y'

Line 6408: ,per_all_assignments_f other_asg

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
6408: ,per_all_assignments_f other_asg
6409: WHERE this_asg.assignment_id = p_assignment_id
6410: AND other_asg.person_id = this_asg.person_id
6411: AND other_asg.primary_flag = 'Y'
6412: AND other_asg.period_of_service_id = this_asg.period_of_service_id

Line 6447: FROM per_all_assignments_f asg

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
6448: WHERE asg.person_id = p_person_id
6449: AND asg.primary_flag = 'Y'
6450: )
6451:

Line 6522: FROM per_all_assignments_f asg

6518: CLOSE csr_css_no_pay_curpos ;
6519: ELSIF (g_deduct_absence_for = 'PRIMASGALLPOS') THEN
6520: SELECT asg.person_id
6521: INTO l_person_id
6522: FROM per_all_assignments_f asg
6523: WHERE asg.assignment_id = p_assignment_id
6524: AND ROWNUM < 2;
6525: IF g_debug THEN
6526: debug('l_person_id:' ,l_person_id);