APPS.PER_US_VETS_100A_CONS_PKG dependencies on PER_JOBS_VL

Line 527: per_jobs_vl job

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
530: peo.person_id = asg.person_id
531: and l_month_end_date between peo.effective_start_date and peo.effective_end_date

Line 587: per_jobs_vl job

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
590: peo.person_id = asg.person_id
591: and l_month_end_date between peo.effective_start_date and peo.effective_end_date

Line 649: per_jobs_vl job,

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
652: WHERE pps.person_id = peo.person_id
653: AND peo.person_id = asg.person_id

Line 709: per_jobs_vl job,

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
712: WHERE pps.person_id = peo.person_id
713: AND peo.person_id = asg.person_id

Line 773: per_jobs_vl job

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
776: peo.person_id = asg.person_id
777: and l_month_end_date between peo.effective_start_date and peo.effective_end_date

Line 828: per_jobs_vl job

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
831: peo.person_id = asg.person_id
832: and l_month_end_date between peo.effective_start_date and peo.effective_end_date

Line 891: per_jobs_vl job,

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
894: WHERE peo.person_id = asg.person_id
895: AND peo.person_id = pps.person_id

Line 945: per_jobs_vl job,

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
948: WHERE peo.person_id = asg.person_id
949: AND peo.person_id = pps.person_id

Line 1006: per_jobs_vl job

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
1009: peo.person_id = asg.person_id
1010: and l_month_end_date between peo.effective_start_date and peo.effective_end_date

Line 1065: per_jobs_vl job

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
1068: peo.person_id = asg.person_id
1069: and l_month_end_date between peo.effective_start_date and peo.effective_end_date