APPS.PER_VETS_MAG_REPORT dependencies on PER_ALL_ASSIGNMENTS_F

Line 1172: per_all_assignments_f ass,

1168: ,0) no_newlysep_vets, --added for bug 13905482
1169: decode(hrl.lookup_code,10,1,hrl.lookup_code) lookup_code
1170: from per_periods_of_service pds,
1171: per_all_people_f peo,
1172: per_all_assignments_f ass,
1173: hr_organization_information hoi1,
1174: hr_organization_information hoi2,
1175: per_jobs job,
1176: hr_lookups hrl

Line 1199: from per_all_assignments_f paf2

1195: and ass.primary_flag = 'Y'
1196: --
1197: and ass.effective_start_date =
1198: (select max(paf2.effective_start_date)
1199: from per_all_assignments_f paf2
1200: where paf2.person_id = ass.person_id
1201: and paf2.primary_flag = 'Y'
1202: and paf2.assignment_type = 'E'
1203: and paf2.effective_start_date <= p_end_date

Line 1335: per_all_assignments_f ass,

1331: 'AFSMNSVIET',1,'AFSMNSDISOP',1,'AFSMVIETNSOP',1,'AFSMVIETNSDIS',1,
1332: 'AFSMVIETNSDISOP',1,null)) no_nh_newly_sep_vets,
1333: decode(hrl.lookup_code,'10','1',hrl.lookup_code) lookup_code
1334: FROM per_all_people_f peo,
1335: per_all_assignments_f ass,
1336: per_jobs job,
1337: hr_lookups hrl,
1338: per_periods_of_service pps
1339: WHERE peo.person_id = ass.person_id

Line 1354: from per_all_assignments_f paf2

1350: AND ass.effective_start_date <= p_end_date
1351: AND job.job_information1 = hrl.lookup_code
1352: AND hrl.lookup_type = 'US_EEO1_JOB_CATEGORIES'
1353: AND ass.effective_start_date = (select max(paf2.effective_start_date)
1354: from per_all_assignments_f paf2
1355: where paf2.person_id = ass.person_id
1356: and paf2.assignment_id = ass.assignment_id
1357: and paf2.effective_start_date = peo.effective_start_date
1358: and paf2.primary_flag = 'Y'

Line 1417: from per_all_assignments_f ass,

1413: -- This one is quicker, more accurate and has cost of just 102
1414: /* BUT this doesn't pick up correct emp number 18-FEB-2005
1415: cursor c_min_max is
1416: select count ('x') num_people
1417: from per_all_assignments_f ass,
1418: hr_organization_information hoi1,
1419: hr_organization_information hoi2
1420: where ass.assignment_type = 'e'
1421: and ass.primary_flag = 'y'

Line 1447: FROM per_all_assignments_f paf

1443: l_month_start_date date := null;
1444: l_month_end_date date := null;
1445: cursor c_min_max is
1446: SELECT count(*) num_people
1447: FROM per_all_assignments_f paf
1448: WHERE paf.business_group_id = p_business_group_id
1449: AND paf.primary_flag = 'Y'
1450: AND paf.assignment_type = 'E'
1451: -- The following condition is modified for the bug# 5000214

Line 1457: from per_all_assignments_f paf2

1453: --AND l_month_start_date between asg.effective_start_date and asg.effective_end_date
1454: and paf.effective_end_date >= l_month_start_date
1455: AND l_month_end_date between paf.effective_start_date and paf.effective_end_date
1456: AND paf.effective_start_date = (select max(paf2.effective_start_date)
1457: from per_all_assignments_f paf2
1458: where paf2.person_id = paf.person_id
1459: and paf2.primary_flag = 'Y'
1460: and paf2.assignment_type = 'E'
1461: and paf2.effective_start_date

Line 1490: FROM per_all_assignments_f paf

1486: -- Count total employee at the end of reporting period
1487: --
1488: cursor c_tot_emps is
1489: SELECT count(distinct paf.person_id) num_people
1490: FROM per_all_assignments_f paf
1491: ,per_periods_of_service pps --8667924
1492: WHERE paf.business_group_id = p_business_group_id
1493: AND paf.primary_flag = 'Y'
1494: AND paf.assignment_type = 'E'

Line 1502: from per_all_assignments_f paf2

1498: and p_end_date between paf.effective_start_date and paf.effective_end_date
1499: /*and paf.effective_start_date <= p_end_date
1500: and paf.effective_end_date >= p_start_date*/
1501: and paf.effective_start_date = (select max(paf2.effective_start_date)
1502: from per_all_assignments_f paf2
1503: where paf2.person_id = paf.person_id
1504: and paf2.primary_flag = 'Y'
1505: and paf2.assignment_type = 'E'
1506: and paf2.effective_start_date