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_PEOPLE_F

Line 4: function check_recent_or_not(l_person_id IN per_all_people_f.person_id%TYPE,

1: PACKAGE BODY per_us_vets_100a_single_pkg as
2: /* $Header: pervetss100a.pkb 120.16 2011/11/17 15:34:03 emunisek ship $ */
3:
4: function check_recent_or_not(l_person_id IN per_all_people_f.person_id%TYPE,
5: l_report_end_date IN date)
6: return number
7: is
8: l_count number;

Line 381: per_all_people_f peo,

377: null loc_no_recsep_vets,
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

Line 407: from per_all_people_f peo2

403: and paf2.assignment_type = 'E'
404: and paf2.effective_start_date <= l_month_end_date)
405: AND peo.effective_start_date =
406: (select max(peo2.effective_start_date)
407: from per_all_people_f peo2
408: where peo2.person_id = peo.person_id
409: and peo2.current_employee_flag = 'Y'
410: and peo2.effective_start_date <= l_month_end_date)
411: AND EXISTS (

Line 433: per_all_people_f peo,

429: count(decode(peo.per_information25,'NS',1,'AFSMNSDIS',1,'NSDIS',1,'AFSMNSDISOP',1,'NSOP',1,'AFSMNSOP',1,'AFSMNS',1,'NSDISOP',1,null)) loc_no_recsep_vets,
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

Line 459: from per_all_people_f peo2

455: and paf2.assignment_type = 'E'
456: and paf2.effective_start_date <= l_month_end_date)
457: AND peo.effective_start_date =
458: (select max(peo2.effective_start_date)
459: from per_all_people_f peo2
460: where peo2.person_id = peo.person_id
461: and peo2.current_employee_flag = 'Y'
462: and peo2.effective_start_date <= l_month_end_date)
463: AND EXISTS (

Line 493: FROM per_all_people_f peo,

489: count(decode(peo.per_information25,'AFSM',1,'AFSMNSDIS',1,'AFSMDIS',1,'AFSMDISOP',1,'AFSMNSDISOP',1,'AFSMOP',1,'AFSMNSOP',1,'AFSMNS',1,null)) loc_nh_armed_vets,
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

Line 543: FROM per_all_people_f peo,

539: NULL loc_nh_armed_vets,
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

Line 602: FROM per_all_people_f peo,

598: ,decode(peo.per_information25,'NOTVET',' ','VET',' ')||
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:

Line 656: FROM per_all_people_f peo,

652: ,peo.per_information25 veteran
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:

Line 717: per_all_people_f peo,

713: decode(peo.per_information25,'OTEV','M','OTEDV','M','AFSMDISOP','M','AFSMNSDISOP','M','AFSMOP','M','NSOP','M','AFSMNSOP','M','NSDISOP','M')||
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

Line 743: from per_all_people_f peo2

739: and paf2.assignment_type = 'E'
740: and paf2.effective_start_date <= l_month_end_date)
741: AND peo.effective_start_date =
742: (select max(peo2.effective_start_date)
743: from per_all_people_f peo2
744: where peo2.person_id = peo.person_id
745: and peo2.current_employee_flag = 'Y'
746: and peo2.effective_start_date <= l_month_end_date)
747: AND EXISTS (

Line 773: per_all_people_f peo,

769: ,asg.assignment_id
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

Line 799: from per_all_people_f peo2

795: and paf2.assignment_type = 'E'
796: and paf2.effective_start_date <= l_month_end_date)
797: AND peo.effective_start_date =
798: (select max(peo2.effective_start_date)
799: from per_all_people_f peo2
800: where peo2.person_id = peo.person_id
801: and peo2.current_employee_flag = 'Y'
802: and peo2.effective_start_date <= l_month_end_date)
803: AND EXISTS (

Line 829: per_all_people_f peo,

825: ,peo.per_information25 veteran
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

Line 855: from per_all_people_f peo2

851: and paf2.assignment_type = 'E'
852: and paf2.effective_start_date <= l_month_end_date)
853: AND peo.effective_start_date =
854: (select max(peo2.effective_start_date)
855: from per_all_people_f peo2
856: where peo2.person_id = peo.person_id
857: and peo2.current_employee_flag = 'Y'
858: and peo2.effective_start_date <= l_month_end_date)
859: AND EXISTS (

Line 884: per_all_people_f peo,

880: ,peo.per_information25 veteran
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

Line 910: from per_all_people_f peo2

906: and paf2.assignment_type = 'E'
907: and paf2.effective_start_date <= l_month_end_date)
908: AND peo.effective_start_date =
909: (select max(peo2.effective_start_date)
910: from per_all_people_f peo2
911: where peo2.person_id = peo.person_id
912: and peo2.current_employee_flag = 'Y'
913: and peo2.effective_start_date <= l_month_end_date)
914: AND EXISTS (