eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_US_VETS_100A_SINGLE_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 250: FROM per_all_assignments_f asg

246:
247: cursor c_minmax_emps(l_month_start_date date,l_month_end_date date) is
248: SELECT
249: count ('person')
250: FROM per_all_assignments_f asg
251: WHERE asg.assignment_type = 'E'
252: AND asg.primary_flag = 'Y'
253: --9011580
254: --AND l_month_start_date between asg.effective_start_date and asg.effective_end_date

Line 258: from per_all_assignments_f paf2

254: --AND l_month_start_date between asg.effective_start_date and asg.effective_end_date
255: and asg.effective_end_date >= l_month_start_date
256: AND l_month_end_date between asg.effective_start_date and asg.effective_end_date
257: AND asg.effective_start_date = (select max(paf2.effective_start_date)
258: from per_all_assignments_f paf2
259: where paf2.person_id = asg.person_id
260: and paf2.primary_flag = 'Y'
261: and paf2.assignment_type = 'E'
262: and paf2.effective_start_date

Line 382: per_all_assignments_f asg,

378: count(decode(peo.per_information25,'NOTVET',1,NULL,1,'VET',1,null)) loc_no_not_vets,
379: count(1) loc_tot_emps -- #10113747
380: FROM
381: per_all_people_f peo,
382: per_all_assignments_f asg,
383: per_jobs_vl job
384: WHERE
385: peo.person_id = asg.person_id
386: AND l_month_end_date between peo.effective_start_date and peo.effective_end_date

Line 400: from per_all_assignments_f paf2

396: AND peo.business_group_id = P_BUSINESS_GROUP_ID
397: AND job.business_group_id = P_BUSINESS_GROUP_ID
398: AND asg.effective_start_date =
399: (select max(paf2.effective_start_date)
400: from per_all_assignments_f paf2
401: where paf2.person_id = asg.person_id
402: and paf2.primary_flag = 'Y'
403: and paf2.assignment_type = 'E'
404: and paf2.effective_start_date <= l_month_end_date)

Line 434: per_all_assignments_f asg,

430: null loc_no_not_vets,
431: null loc_tot_emps -- #10113747
432: FROM
433: per_all_people_f peo,
434: per_all_assignments_f asg,
435: per_jobs_vl job
436: WHERE
437: peo.person_id = asg.person_id
438: AND l_month_end_date between peo.effective_start_date and peo.effective_end_date

Line 452: from per_all_assignments_f paf2

448: AND peo.business_group_id = P_BUSINESS_GROUP_ID
449: AND job.business_group_id = P_BUSINESS_GROUP_ID
450: AND asg.effective_start_date =
451: (select max(paf2.effective_start_date)
452: from per_all_assignments_f paf2
453: where paf2.person_id = asg.person_id
454: and paf2.primary_flag = 'Y'
455: and paf2.assignment_type = 'E'
456: and paf2.effective_start_date <= l_month_end_date)

Line 494: per_all_assignments_f asg,

490: NULL loc_nh_recsep_vets,
491: count(decode(peo.per_information25,'NOTVET',1,NULL,1,'VET',1,null)) loc_nh_not_vets,
492: count(1) loc_nh_tot_emps -- #10113747
493: FROM per_all_people_f peo,
494: per_all_assignments_f asg,
495: per_jobs_vl job,
496: per_periods_of_service pps
497: WHERE peo.person_id = asg.person_id
498: AND peo.person_id = pps.person_id

Line 508: from per_all_assignments_f paf2

504: AND asg.assignment_type = 'E'
505: AND asg.primary_flag = 'Y'
506: AND asg.effective_start_date <= l_month_end_date
507: AND asg.effective_start_date = (select max(paf2.effective_start_date)
508: from per_all_assignments_f paf2
509: where paf2.person_id = asg.person_id
510: and paf2.assignment_id = asg.assignment_id
511: and paf2.effective_start_date = peo.effective_start_date
512: and paf2.primary_flag = 'Y'

Line 544: per_all_assignments_f asg,

540: count(decode(peo.per_information25,'NS',1,'AFSMNSDIS',1,'NSDIS',1,'AFSMNSDISOP',1,'NSOP',1,'AFSMNSOP',1,'AFSMNS',1,'NSDISOP',1,null)) loc_nh_recsep_vets,
541: NULL loc_nh_not_vets,
542: NULL loc_nh_tot_emps -- #10113747
543: FROM per_all_people_f peo,
544: per_all_assignments_f asg,
545: per_jobs_vl job,
546: per_periods_of_service pps
547: WHERE peo.person_id = asg.person_id
548: AND peo.person_id = pps.person_id

Line 558: from per_all_assignments_f paf2

554: AND asg.assignment_type = 'E'
555: AND asg.primary_flag = 'Y'
556: AND asg.effective_start_date <= l_month_end_date
557: AND asg.effective_start_date = (select max(paf2.effective_start_date)
558: from per_all_assignments_f paf2
559: where paf2.person_id = asg.person_id
560: and paf2.assignment_id = asg.assignment_id
561: and paf2.effective_start_date = peo.effective_start_date
562: and paf2.primary_flag = 'Y'

Line 603: per_all_assignments_f asg,

599: decode(peo.per_information25,'VETDIS','Q','AFSMNSDIS','Q','OTEDV','Q','AFSMDIS','Q','NSDIS','Q','AFSMDISOP','Q','AFSMNSDISOP','Q','NSDISOP','Q')||
600: decode(peo.per_information25,'OTEV','R','OTEDV','R','AFSMDISOP','R','AFSMNSDISOP','R','AFSMOP','R','NSOP','R','AFSMNSOP','R','NSDISOP','R')||
601: decode(peo.per_information25,'AFSM','S','AFSMNSDIS','S','AFSMDIS','S','AFSMDISOP','S','AFSMNSDISOP','S','AFSMOP','S','AFSMNSOP','S','AFSMNS','S') veteran_category
602: FROM per_all_people_f peo,
603: per_all_assignments_f asg,
604: per_jobs_vl job,
605: per_periods_of_service pps
606:
607: WHERE peo.person_id = asg.person_id

Line 618: from per_all_assignments_f paf2

614: AND asg.assignment_type = 'E'
615: AND asg.primary_flag = 'Y'
616: AND asg.effective_start_date <= l_month_end_date
617: AND asg.effective_start_date = (select max(paf2.effective_start_date)
618: from per_all_assignments_f paf2
619: where paf2.person_id = asg.person_id
620: and paf2.assignment_id = asg.assignment_id
621: and paf2.effective_start_date = peo.effective_start_date
622: and paf2.primary_flag = 'Y'

Line 657: per_all_assignments_f asg,

653: ,job.job_information1 job_category
654: ,asg.assignment_id
655: ,decode(peo.per_information25,'NS','T','AFSMNSDIS','T','NSDIS','T','AFSMNSDISOP','T', 'NSOP','T','AFSMNSOP','T','AFSMNS','T','NSDISOP','T') veteran_category
656: FROM per_all_people_f peo,
657: per_all_assignments_f asg,
658: per_jobs_vl job,
659: per_periods_of_service pps
660:
661: WHERE peo.person_id = asg.person_id

Line 672: from per_all_assignments_f paf2

668: AND asg.assignment_type = 'E'
669: AND asg.primary_flag = 'Y'
670: AND asg.effective_start_date <= l_month_end_date
671: AND asg.effective_start_date = (select max(paf2.effective_start_date)
672: from per_all_assignments_f paf2
673: where paf2.person_id = asg.person_id
674: and paf2.assignment_id = asg.assignment_id
675: and paf2.effective_start_date = peo.effective_start_date
676: and paf2.primary_flag = 'Y'

Line 718: per_all_assignments_f asg,

714: decode(peo.per_information25,'AFSM','N','AFSMNSDIS','N','AFSMDIS','N','AFSMDISOP','N','AFSMNSDISOP','N','AFSMOP','N','AFSMNSOP','N','AFSMNS','N') veteran_category
715:
716: FROM
717: per_all_people_f peo,
718: per_all_assignments_f asg,
719: per_jobs_vl job
720: WHERE
721: peo.person_id = asg.person_id
722: AND l_month_end_date between peo.effective_start_date and peo.effective_end_date

Line 736: from per_all_assignments_f paf2

732: AND peo.business_group_id = P_BUSINESS_GROUP_ID
733: AND job.business_group_id = P_BUSINESS_GROUP_ID
734: AND asg.effective_start_date =
735: (select max(paf2.effective_start_date)
736: from per_all_assignments_f paf2
737: where paf2.person_id = asg.person_id
738: and paf2.primary_flag = 'Y'
739: and paf2.assignment_type = 'E'
740: and paf2.effective_start_date <= l_month_end_date)

Line 774: per_all_assignments_f asg,

770: ,decode(peo.per_information25,'NS','O','AFSMNSDIS','O','NSDIS','O','AFSMNSDISOP','O', 'NSOP','O','AFSMNSOP','O','AFSMNS','O','NSDISOP','O') veteran_category
771:
772: FROM
773: per_all_people_f peo,
774: per_all_assignments_f asg,
775: per_jobs_vl job
776: WHERE
777: peo.person_id = asg.person_id
778: AND l_month_end_date between peo.effective_start_date and peo.effective_end_date

Line 792: from per_all_assignments_f paf2

788: AND peo.business_group_id = P_BUSINESS_GROUP_ID
789: AND job.business_group_id = P_BUSINESS_GROUP_ID
790: AND asg.effective_start_date =
791: (select max(paf2.effective_start_date)
792: from per_all_assignments_f paf2
793: where paf2.person_id = asg.person_id
794: and paf2.primary_flag = 'Y'
795: and paf2.assignment_type = 'E'
796: and paf2.effective_start_date <= l_month_end_date)

Line 830: per_all_assignments_f asg,

826: ,asg.assignment_id
827:
828: FROM
829: per_all_people_f peo,
830: per_all_assignments_f asg,
831: per_jobs_vl job
832: WHERE
833: peo.person_id = asg.person_id
834: AND l_month_end_date between peo.effective_start_date and peo.effective_end_date

Line 848: from per_all_assignments_f paf2

844: AND peo.business_group_id = P_BUSINESS_GROUP_ID
845: AND job.business_group_id = P_BUSINESS_GROUP_ID
846: AND asg.effective_start_date =
847: (select max(paf2.effective_start_date)
848: from per_all_assignments_f paf2
849: where paf2.person_id = asg.person_id
850: and paf2.primary_flag = 'Y'
851: and paf2.assignment_type = 'E'
852: and paf2.effective_start_date <= l_month_end_date)

Line 885: per_all_assignments_f asg,

881: ,asg.assignment_id
882:
883: FROM
884: per_all_people_f peo,
885: per_all_assignments_f asg,
886: per_jobs_vl job
887: WHERE
888: peo.person_id = asg.person_id
889: AND l_month_end_date between peo.effective_start_date and peo.effective_end_date

Line 903: from per_all_assignments_f paf2

899: AND peo.business_group_id = P_BUSINESS_GROUP_ID
900: AND job.business_group_id = P_BUSINESS_GROUP_ID
901: AND asg.effective_start_date =
902: (select max(paf2.effective_start_date)
903: from per_all_assignments_f paf2
904: where paf2.person_id = asg.person_id
905: and paf2.primary_flag = 'Y'
906: and paf2.assignment_type = 'E'
907: and paf2.effective_start_date <= l_month_end_date)

Line 1281: from per_all_assignments_f asg,

1277: --Made fix for 8724355 - Removed the join condition with per_jobs_vl
1278: select
1279: count(distinct asg.person_id)
1280: into l_50_emps
1281: from per_all_assignments_f asg,
1282: per_periods_of_service pps /*8667924*/
1283: where
1284: asg.business_group_id = P_BUSINESS_GROUP_ID
1285: and asg.assignment_type = 'E'

Line 1306: from per_all_assignments_f ass1

1302: months_between(P_DATE_END1,pps.actual_termination_date) between 0 and 12 /*8667924*/
1303: )
1304: and asg.effective_start_date =
1305: (select max(ass1.effective_start_date)
1306: from per_all_assignments_f ass1
1307: where P_DATE_END1 between ass1.effective_start_date and ass1.effective_end_date
1308: and asg.person_id = ass1.person_id
1309: and ass1.assignment_type = 'E'
1310: and ass1.primary_flag = 'Y'