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_ASSIGNMENTS_F

Line 167: per_all_assignments_f asg

163:
164: cursor c_tot_emps(l_est_node_id in varchar2,l_month_end_date in date) is
165: select count(distinct asg.person_id)
166: from
167: per_all_assignments_f asg
168: ,per_gen_hierarchy_nodes pgn
169: ,per_periods_of_service pps --8667924
170: where
171: asg.business_group_id = P_BUSINESS_GROUP_ID

Line 178: from per_all_assignments_f paf2

174: and asg.assignment_type = 'E'
175: and asg.primary_flag = 'Y'
176: and l_month_end_date between asg.effective_start_date and asg.effective_end_date
177: and asg.effective_start_date = (select max(paf2.effective_start_date)
178: from per_all_assignments_f paf2
179: where paf2.person_id = asg.person_id
180: and paf2.primary_flag = 'Y'
181: and paf2.assignment_type = 'E'
182: and paf2.effective_start_date

Line 319: from per_all_assignments_f asg

315: exit when c_locs%notfound;
316:
317: select count(distinct asg.person_id)
318: into no_loc_emps
319: from per_all_assignments_f asg
320: , per_periods_of_service pps
321: where
322: asg.assignment_type = 'E'
323: and asg.primary_flag = 'Y'

Line 328: from per_all_assignments_f paf2

324: and pps.person_id=asg.person_id
325: and pps.business_group_id = asg.business_group_id
326: and P_DATE_END1 between asg.effective_start_date and asg.effective_end_date
327: and asg.effective_start_date = (select max(paf2.effective_start_date)
328: from per_all_assignments_f paf2
329: where paf2.person_id = asg.person_id
330: and paf2.primary_flag = 'Y'
331: and paf2.assignment_type = 'E'
332: and paf2.effective_start_date

Line 376: from per_all_assignments_f asg

372: procedure min_max(p_state varchar2) is
373:
374: cursor C_MINMAX_EMPS(l_est_node_id varchar2,l_month_start_date date,l_month_end_date date) is
375: select count('asg')
376: from per_all_assignments_f asg
377: ,per_gen_hierarchy_nodes pgn
378: where asg.assignment_type = 'E'
379: and asg.primary_flag = 'Y'
380: --9011580

Line 385: from per_all_assignments_f paf2

381: --AND l_month_start_date between asg.effective_start_date and asg.effective_end_date
382: and asg.effective_end_date >= l_month_start_date
383: AND l_month_end_date between asg.effective_start_date and asg.effective_end_date
384: and asg.effective_start_date = (select max(paf2.effective_start_date)
385: from per_all_assignments_f paf2
386: where paf2.person_id = asg.person_id
387: and paf2.primary_flag = 'Y'
388: and paf2.assignment_type = 'E'
389: and paf2.effective_start_date

Line 526: per_all_assignments_f asg,

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
530: peo.person_id = asg.person_id

Line 542: from per_all_assignments_f paf2

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)
542: from per_all_assignments_f paf2
543: where paf2.person_id = asg.person_id
544: and paf2.primary_flag = 'Y'
545: and paf2.assignment_type = 'E'
546: and paf2.effective_start_date <= l_month_end_date)

Line 586: per_all_assignments_f asg,

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
590: peo.person_id = asg.person_id

Line 602: from per_all_assignments_f paf2

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)
602: from per_all_assignments_f paf2
603: where paf2.person_id = asg.person_id
604: and paf2.primary_flag = 'Y'
605: and paf2.assignment_type = 'E'
606: and paf2.effective_start_date <= l_month_end_date)

Line 648: per_all_assignments_f asg,

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

Line 663: from per_all_assignments_f paf2

659: AND asg.assignment_type = 'E'
660: AND asg.primary_flag = 'Y'
661: and asg.effective_start_date <= l_month_end_date
662: AND asg.effective_start_date = (select max(paf2.effective_start_date)
663: from per_all_assignments_f paf2
664: where paf2.person_id = asg.person_id
665: AND paf2.assignment_id = asg.assignment_id
666: AND paf2.effective_start_date = peo.effective_start_date
667: AND paf2.business_group_id = P_BUSINESS_GROUP_ID

Line 708: per_all_assignments_f asg,

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

Line 723: from per_all_assignments_f paf2

719: AND asg.assignment_type = 'E'
720: AND asg.primary_flag = 'Y'
721: and asg.effective_start_date <= l_month_end_date
722: AND asg.effective_start_date = (select max(paf2.effective_start_date)
723: from per_all_assignments_f paf2
724: where paf2.person_id = asg.person_id
725: AND paf2.assignment_id = asg.assignment_id
726: AND paf2.effective_start_date = peo.effective_start_date
727: AND paf2.business_group_id = P_BUSINESS_GROUP_ID

Line 772: per_all_assignments_f asg,

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
776: peo.person_id = asg.person_id

Line 788: from per_all_assignments_f paf2

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)
788: from per_all_assignments_f paf2
789: where paf2.person_id = asg.person_id
790: and paf2.primary_flag = 'Y'
791: and paf2.assignment_type = 'E'
792: and paf2.effective_start_date <= l_month_end_date)

Line 827: per_all_assignments_f asg,

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
831: peo.person_id = asg.person_id

Line 843: from per_all_assignments_f paf2

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)
843: from per_all_assignments_f paf2
844: where paf2.person_id = asg.person_id
845: and paf2.primary_flag = 'Y'
846: and paf2.assignment_type = 'E'
847: and paf2.effective_start_date <= l_month_end_date)

Line 890: per_all_assignments_f asg,

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

Line 905: from per_all_assignments_f paf2

901: AND asg.assignment_type = 'E'
902: AND asg.primary_flag = 'Y'
903: and asg.effective_start_date <= l_month_end_date
904: AND asg.effective_start_date = (select max(paf2.effective_start_date)
905: from per_all_assignments_f paf2
906: where paf2.person_id = asg.person_id
907: and paf2.assignment_id = asg.assignment_id
908: and paf2.effective_start_date = peo.effective_start_date
909: and paf2.primary_flag = 'Y'

Line 944: per_all_assignments_f asg,

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

Line 959: from per_all_assignments_f paf2

955: AND asg.assignment_type = 'E'
956: AND asg.primary_flag = 'Y'
957: and asg.effective_start_date <= l_month_end_date
958: AND asg.effective_start_date = (select max(paf2.effective_start_date)
959: from per_all_assignments_f paf2
960: where paf2.person_id = asg.person_id
961: and paf2.assignment_id = asg.assignment_id
962: and paf2.effective_start_date = peo.effective_start_date
963: and paf2.primary_flag = 'Y'

Line 1005: per_all_assignments_f asg,

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
1009: peo.person_id = asg.person_id

Line 1021: from per_all_assignments_f paf2

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)
1021: from per_all_assignments_f paf2
1022: where paf2.person_id = asg.person_id
1023: and paf2.primary_flag = 'Y'
1024: and paf2.assignment_type = 'E'
1025: and paf2.effective_start_date <= l_month_end_date)

Line 1064: per_all_assignments_f asg,

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
1068: peo.person_id = asg.person_id

Line 1080: from per_all_assignments_f paf2

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)
1080: from per_all_assignments_f paf2
1081: where paf2.person_id = asg.person_id
1082: and paf2.primary_flag = 'Y'
1083: and paf2.assignment_type = 'E'
1084: and paf2.effective_start_date <= l_month_end_date)