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_CONS_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_cons_pkg as
2: /* $Header: pervetsc100a.pkb 120.16 2011/11/17 15:32:00 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 525: per_all_people_f peo,

521: decode(peo.per_information25,'OTEV','M','OTEDV','M','AFSMDISOP','M','AFSMNSDISOP','M','AFSMOP','M','NSOP','M','AFSMNSOP','M','NSDISOP','M')||
522: decode(peo.per_information25,'AFSM','N','AFSMNSDIS','N','AFSMDIS','N','AFSMDISOP','N','AFSMNSDISOP','N','AFSMOP','N','AFSMNSOP','N','AFSMNS','N') veteran_category
523:
524: from
525: per_all_people_f peo,
526: per_all_assignments_f asg,
527: per_jobs_vl job
528: ,per_gen_hierarchy_nodes pgn
529: where

Line 537: from per_all_people_f peo2

533: and asg.assignment_type = 'E'
534: and asg.primary_flag = 'Y'
535: and l_month_end_date between asg.effective_start_date and asg.effective_end_date
536: and peo.effective_start_date = (select max(peo2.effective_start_date)
537: from per_all_people_f peo2
538: where peo2.person_id = peo.person_id
539: and peo2.current_employee_flag = 'Y'
540: and peo2.effective_start_date <= l_month_end_date )
541: and asg.effective_start_date = (select max(paf2.effective_start_date)

Line 585: per_all_people_f peo,

581: ,asg.assignment_id
582: ,decode(peo.per_information25,'NS','O','AFSMNSDIS','O','NSDIS','O','AFSMNSDISOP','O', 'NSOP','O','AFSMNSOP','O','AFSMNS','O','NSDISOP','O') veteran_category
583:
584: from
585: per_all_people_f peo,
586: per_all_assignments_f asg,
587: per_jobs_vl job
588: ,per_gen_hierarchy_nodes pgn
589: where

Line 597: from per_all_people_f peo2

593: and asg.assignment_type = 'E'
594: and asg.primary_flag = 'Y'
595: and l_month_end_date between asg.effective_start_date and asg.effective_end_date
596: and peo.effective_start_date = (select max(peo2.effective_start_date)
597: from per_all_people_f peo2
598: where peo2.person_id = peo.person_id
599: and peo2.current_employee_flag = 'Y'
600: and peo2.effective_start_date <= l_month_end_date )
601: and asg.effective_start_date = (select max(paf2.effective_start_date)

Line 647: FROM per_all_people_f peo,

643: decode(peo.per_information25,'VETDIS','Q','AFSMNSDIS','Q','OTEDV','Q','AFSMDIS','Q','NSDIS','Q','AFSMDISOP','Q','AFSMNSDISOP','Q','NSDISOP','Q')||
644: decode(peo.per_information25,'OTEV','R','OTEDV','R','AFSMDISOP','R','AFSMNSDISOP','R','AFSMOP','R','NSOP','R','AFSMNSOP','R','NSDISOP','R')||
645: decode(peo.per_information25,'AFSM','S','AFSMNSDIS','S','AFSMDIS','S','AFSMDISOP','S','AFSMNSDISOP','S','AFSMOP','S','AFSMNSOP','S','AFSMNS','S') veteran_category
646:
647: FROM per_all_people_f peo,
648: per_all_assignments_f asg,
649: per_jobs_vl job,
650: per_gen_hierarchy_nodes pgn,
651: per_periods_of_service pps

Line 707: FROM per_all_people_f peo,

703: ,job.job_information1 job_category
704: ,asg.assignment_id
705: ,decode(peo.per_information25,'NS','T','AFSMNSDIS','T','NSDIS','T','AFSMNSDISOP','T', 'NSOP','T','AFSMNSOP','T','AFSMNS','T','NSDISOP','T') veteran_category
706:
707: FROM per_all_people_f peo,
708: per_all_assignments_f asg,
709: per_jobs_vl job,
710: per_gen_hierarchy_nodes pgn,
711: per_periods_of_service pps

Line 771: per_all_people_f peo,

767: null loc_no_recsep_vets,
768: count(decode(peo.per_information25,'NOTVET',1,NULL,1,'VET',1,null)) loc_no_not_vets,
769: count(1) loc_tot_emps -- #10113747
770: from
771: per_all_people_f peo,
772: per_all_assignments_f asg,
773: per_jobs_vl job
774: ,per_gen_hierarchy_nodes pgn
775: where

Line 783: from per_all_people_f peo2

779: and asg.assignment_type = 'E'
780: and asg.primary_flag = 'Y'
781: and l_month_end_date between asg.effective_start_date and asg.effective_end_date
782: and peo.effective_start_date = (select max(peo2.effective_start_date)
783: from per_all_people_f peo2
784: where peo2.person_id = peo.person_id
785: and peo2.current_employee_flag = 'Y'
786: and peo2.effective_start_date <= l_month_end_date)
787: and asg.effective_start_date = (select max(paf2.effective_start_date)

Line 826: per_all_people_f peo,

822: 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,
823: null loc_no_not_vets,
824: null loc_tot_emps -- #10113747
825: from
826: per_all_people_f peo,
827: per_all_assignments_f asg,
828: per_jobs_vl job
829: ,per_gen_hierarchy_nodes pgn
830: where

Line 838: from per_all_people_f peo2

834: and asg.assignment_type = 'E'
835: and asg.primary_flag = 'Y'
836: and l_month_end_date between asg.effective_start_date and asg.effective_end_date
837: and peo.effective_start_date = (select max(peo2.effective_start_date)
838: from per_all_people_f peo2
839: where peo2.person_id = peo.person_id
840: and peo2.current_employee_flag = 'Y'
841: and peo2.effective_start_date <= l_month_end_date)
842: and asg.effective_start_date = (select max(paf2.effective_start_date)

Line 889: FROM per_all_people_f peo,

885: 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,
886: NULL loc_nh_recsep_vets,
887: count(decode(peo.per_information25,'NOTVET',1,NULL,1,'VET',1,null)) loc_nh_not_vets,
888: count(1) loc_nh_tot_emps -- #10113747
889: FROM per_all_people_f peo,
890: per_all_assignments_f asg,
891: per_jobs_vl job,
892: per_gen_hierarchy_nodes pgn,
893: per_periods_of_service pps

Line 943: FROM per_all_people_f peo,

939: NULL loc_nh_armed_vets,
940: 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,
941: NULL loc_nh_not_vets,
942: NULL loc_nh_tot_emps -- #10113747
943: FROM per_all_people_f peo,
944: per_all_assignments_f asg,
945: per_jobs_vl job,
946: per_gen_hierarchy_nodes pgn,
947: per_periods_of_service pps

Line 1004: per_all_people_f peo,

1000: ,job.job_information1 job_category
1001: ,asg.assignment_id
1002:
1003: from
1004: per_all_people_f peo,
1005: per_all_assignments_f asg,
1006: per_jobs_vl job
1007: ,per_gen_hierarchy_nodes pgn
1008: where

Line 1016: from per_all_people_f peo2

1012: and asg.assignment_type = 'E'
1013: and asg.primary_flag = 'Y'
1014: and l_month_end_date between asg.effective_start_date and asg.effective_end_date
1015: and peo.effective_start_date = (select max(peo2.effective_start_date)
1016: from per_all_people_f peo2
1017: where peo2.person_id = peo.person_id
1018: and peo2.current_employee_flag = 'Y'
1019: and peo2.effective_start_date <= l_month_end_date )
1020: and asg.effective_start_date = (select max(paf2.effective_start_date)

Line 1063: per_all_people_f peo,

1059: ,job.job_information1 job_category
1060: ,asg.assignment_id
1061:
1062: from
1063: per_all_people_f peo,
1064: per_all_assignments_f asg,
1065: per_jobs_vl job
1066: ,per_gen_hierarchy_nodes pgn
1067: where

Line 1075: from per_all_people_f peo2

1071: and asg.assignment_type = 'E'
1072: and asg.primary_flag = 'Y'
1073: and l_month_end_date between asg.effective_start_date and asg.effective_end_date
1074: and peo.effective_start_date = (select max(peo2.effective_start_date)
1075: from per_all_people_f peo2
1076: where peo2.person_id = peo.person_id
1077: and peo2.current_employee_flag = 'Y'
1078: and peo2.effective_start_date <= l_month_end_date )
1079: and asg.effective_start_date = (select max(paf2.effective_start_date)