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_PERIODS_OF_SERVICE

Line 169: ,per_periods_of_service pps --8667924

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
172: and asg.person_id = pps.person_id
173: and asg.business_group_id = pps.business_group_id

Line 320: , per_periods_of_service pps

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'
324: and pps.person_id=asg.person_id

Line 651: per_periods_of_service pps

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
654: AND pps.business_group_id = P_BUSINESS_GROUP_ID
655: AND peo.business_group_id = P_BUSINESS_GROUP_ID

Line 711: per_periods_of_service pps

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
714: AND pps.business_group_id = P_BUSINESS_GROUP_ID
715: AND peo.business_group_id = P_BUSINESS_GROUP_ID

Line 893: per_periods_of_service pps

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
896: AND peo.business_group_id = P_BUSINESS_GROUP_ID
897: AND asg.business_group_id = P_BUSINESS_GROUP_ID

Line 947: per_periods_of_service pps

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
950: AND peo.business_group_id = P_BUSINESS_GROUP_ID
951: AND asg.business_group_id = P_BUSINESS_GROUP_ID