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

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
2256: ,per_all_assignments_f other_asg
2257: WHERE this_asg.assignment_id = p_assignment_id
2258: AND other_asg.person_id = this_asg.person_id
2259: AND other_asg.primary_flag = 'Y'

Line 2256: ,per_all_assignments_f other_asg

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
2256: ,per_all_assignments_f other_asg
2257: WHERE this_asg.assignment_id = p_assignment_id
2258: AND other_asg.person_id = this_asg.person_id
2259: AND other_asg.primary_flag = 'Y'
2260: AND other_asg.period_of_service_id = this_asg.period_of_service_id

Line 2283: FROM per_all_assignments_f asg

2279: debug(l_proc_name,l_proc_step);
2280: END IF;
2281: SELECT asg.person_id
2282: INTO l_person_id
2283: FROM per_all_assignments_f asg
2284: WHERE asg.assignment_id = p_assignment_id
2285: AND ROWNUM < 2;
2286: IF g_debug THEN
2287: debug('l_person_id:' ,l_person_id);

Line 2300: FROM per_all_assignments_f asg

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
2301: WHERE asg.person_id = l_person_id
2302: AND asg.primary_flag = 'Y'
2303: )
2304: AND gda.gap_absence_plan_id = gap.gap_absence_plan_id

Line 2418: (p_assignment_id per_all_assignments_f.assignment_id%TYPE

2414: ) RETURN DATE
2415: IS
2416:
2417: CURSOR csr_adjusted_scheme_start_date
2418: (p_assignment_id per_all_assignments_f.assignment_id%TYPE
2419: ,p_pl_typ_id ben_pl_typ_f.pl_typ_id%TYPE
2420: ,p_scheme_start_date DATE
2421: ) IS
2422: SELECT

Line 6361: FROM per_all_assignments_f this_asg

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
6362: ,per_all_assignments_f other_asg
6363: WHERE this_asg.assignment_id = p_assignment_id
6364: AND other_asg.person_id = this_asg.person_id
6365: AND other_asg.primary_flag = 'Y'

Line 6362: ,per_all_assignments_f other_asg

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
6362: ,per_all_assignments_f other_asg
6363: WHERE this_asg.assignment_id = p_assignment_id
6364: AND other_asg.person_id = this_asg.person_id
6365: AND other_asg.primary_flag = 'Y'
6366: AND other_asg.period_of_service_id = this_asg.period_of_service_id

Line 6389: FROM per_all_assignments_f asg

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
6390: WHERE asg.person_id = p_person_id
6391: AND asg.primary_flag = 'Y'
6392: )
6393:

Line 6462: FROM per_all_assignments_f asg

6458: CLOSE csr_css_no_pay_curpos ;
6459: ELSIF (g_deduct_absence_for = 'PRIMASGALLPOS') THEN
6460: SELECT asg.person_id
6461: INTO l_person_id
6462: FROM per_all_assignments_f asg
6463: WHERE asg.assignment_id = p_assignment_id
6464: AND ROWNUM < 2;
6465: IF g_debug THEN
6466: debug('l_person_id:' ,l_person_id);