APPS.PQP_GB_PENSRV_SVPN dependencies on PER_ALL_ASSIGNMENTS_F

Line 31: 'from per_all_assignments_f '||' '||

27:
28: BEGIN
29:
30: l_query := 'select max(effective_start_date)'||' '||
31: 'from per_all_assignments_f '||' '||
32: 'where business_group_id = '||g_business_group_id||' '||
33: 'and assignment_id = '||p_assignment_id||' '||
34: 'and effective_start_date <= to_date('''||TO_CHAR(g_eff_end_date,'dd/mm/yyyy')||''',''dd/mm/yyyy'') '||' '||
35: 'and effective_end_date >= to_date('''||TO_CHAR(g_eff_start_date,'dd/mm/yyyy')||''',''dd/mm/yyyy'')'||' '||

Line 69: per_all_assignments_f paaf,

65: IS
66: SELECT DISTINCT papf.national_identifier,papf.person_id,paaf.assignment_id,
67: ppos.period_of_service_id,papf.employee_number,paaf.assignment_number
68: FROM per_all_people_f papf,
69: per_all_assignments_f paaf,
70: per_periods_of_service ppos
71: WHERE papf.business_group_id = g_business_group_id
72: AND papf.effective_start_date <= c_eff_end_date
73: AND papf.effective_end_date >= g_eff_start_date