APPS.PER_VETS_MAG_REPORT dependencies on PER_ALL_ASSIGNMENTS_F

Line 1058: per_all_assignments_f ass,

1054: no_other_vets,
1055: decode(hrl.lookup_code,10,1,hrl.lookup_code) lookup_code
1056: from per_periods_of_service pds,
1057: per_all_people_f peo,
1058: per_all_assignments_f ass,
1059: hr_organization_information hoi1,
1060: hr_organization_information hoi2,
1061: per_jobs job,
1062: hr_lookups hrl

Line 1085: from per_all_assignments_f paf2

1081: and ass.primary_flag = 'Y'
1082: --
1083: and ass.effective_start_date =
1084: (select max(paf2.effective_start_date)
1085: from per_all_assignments_f paf2
1086: where paf2.person_id = ass.person_id
1087: and paf2.primary_flag = 'Y'
1088: and paf2.assignment_type = 'E'
1089: and paf2.effective_start_date <= p_end_date

Line 1219: per_all_assignments_f ass,

1215: 'AFSMNSVIET',1,'AFSMNSDISOP',1,'AFSMVIETNSOP',1,'AFSMVIETNSDIS',1,
1216: 'AFSMVIETNSDISOP',1,null)) no_nh_newly_sep_vets,
1217: decode(hrl.lookup_code,'10','1',hrl.lookup_code) lookup_code
1218: FROM per_all_people_f peo,
1219: per_all_assignments_f ass,
1220: per_jobs job,
1221: hr_lookups hrl,
1222: per_periods_of_service pps
1223: WHERE peo.person_id = ass.person_id

Line 1238: from per_all_assignments_f paf2

1234: AND ass.effective_start_date <= p_end_date
1235: AND job.job_information1 = hrl.lookup_code
1236: AND hrl.lookup_type = 'US_EEO1_JOB_CATEGORIES'
1237: AND ass.effective_start_date = (select max(paf2.effective_start_date)
1238: from per_all_assignments_f paf2
1239: where paf2.person_id = ass.person_id
1240: and paf2.assignment_id = ass.assignment_id
1241: and paf2.effective_start_date = peo.effective_start_date
1242: and paf2.primary_flag = 'Y'

Line 1301: from per_all_assignments_f ass,

1297: -- This one is quicker, more accurate and has cost of just 102
1298: /* BUT this doesn't pick up correct emp number 18-FEB-2005
1299: cursor c_min_max is
1300: select count ('x') num_people
1301: from per_all_assignments_f ass,
1302: hr_organization_information hoi1,
1303: hr_organization_information hoi2
1304: where ass.assignment_type = 'e'
1305: and ass.primary_flag = 'y'

Line 1331: FROM per_all_assignments_f paf

1327: l_month_start_date date := null;
1328: l_month_end_date date := null;
1329: cursor c_min_max is
1330: SELECT count(*) num_people
1331: FROM per_all_assignments_f paf
1332: WHERE paf.business_group_id = p_business_group_id
1333: AND paf.primary_flag = 'Y'
1334: AND paf.assignment_type = 'E'
1335: -- The following condition is modified for the bug# 5000214

Line 1339: from per_all_assignments_f paf2

1335: -- The following condition is modified for the bug# 5000214
1336: AND l_month_start_date BETWEEN paf.effective_start_date AND paf.effective_end_date
1337: -- The following 2 condtions are added to sync with perusvts.rdf min-max cursor query.
1338: AND paf.effective_start_date = (select max(paf2.effective_start_date)
1339: from per_all_assignments_f paf2
1340: where paf2.person_id = paf.person_id
1341: and paf2.primary_flag = 'Y'
1342: and paf2.assignment_type = 'E'
1343: and paf2.effective_start_date

Line 1372: FROM per_all_assignments_f paf

1368: -- Count total employee at the end of reporting period
1369: --
1370: cursor c_tot_emps is
1371: SELECT count(*) num_people
1372: FROM per_all_assignments_f paf
1373: WHERE paf.business_group_id = p_business_group_id
1374: AND paf.primary_flag = 'Y'
1375: AND paf.assignment_type = 'E'
1376: -- Bug# 5000214

Line 1381: from per_all_assignments_f paf2

1377: and p_end_date between paf.effective_start_date and paf.effective_end_date
1378: /*and paf.effective_start_date <= p_end_date
1379: and paf.effective_end_date >= p_start_date*/
1380: and paf.effective_start_date = (select max(paf2.effective_start_date)
1381: from per_all_assignments_f paf2
1382: where paf2.person_id = paf.person_id
1383: and paf2.primary_flag = 'Y'
1384: and paf2.assignment_type = 'E'
1385: and paf2.effective_start_date