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_GEN_HIERARCHY

Line 47: per_gen_hierarchy pgh,

43: cursor c_hier_details is
44: select
45: pgh.name, pgv.version_number, pgn.entity_id, pgn.hierarchy_node_id
46: from
47: per_gen_hierarchy pgh,
48: per_gen_hierarchy_versions pgv,
49: per_gen_hierarchy_nodes pgn
50: where
51: pgh.hierarchy_id = p_hierarchy_id

Line 48: per_gen_hierarchy_versions pgv,

44: select
45: pgh.name, pgv.version_number, pgn.entity_id, pgn.hierarchy_node_id
46: from
47: per_gen_hierarchy pgh,
48: per_gen_hierarchy_versions pgv,
49: per_gen_hierarchy_nodes pgn
50: where
51: pgh.hierarchy_id = p_hierarchy_id
52: and pgh.hierarchy_id = pgv.hierarchy_id

Line 49: per_gen_hierarchy_nodes pgn

45: pgh.name, pgv.version_number, pgn.entity_id, pgn.hierarchy_node_id
46: from
47: per_gen_hierarchy pgh,
48: per_gen_hierarchy_versions pgv,
49: per_gen_hierarchy_nodes pgn
50: where
51: pgh.hierarchy_id = p_hierarchy_id
52: and pgh.hierarchy_id = pgv.hierarchy_id
53: and pgv.hierarchy_version_id = p_hierarchy_version_id

Line 61: per_gen_hierarchy_nodes pghn

57: cursor c_count_est is
58: select
59: count(pghn.hierarchy_node_id)
60: from
61: per_gen_hierarchy_nodes pghn
62: where
63: pghn.hierarchy_version_id = p_hierarchy_version_id
64: and pghn.node_type = 'EST';
65:

Line 114: ,per_gen_hierarchy_nodes pghn

110: distinct(eloc.region_2) "State"
111: from
112: hr_location_extra_info hlei1
113: ,hr_location_extra_info hlei2
114: ,per_gen_hierarchy_nodes pghn
115: ,hr_locations_all eloc
116: where
117: pghn.parent_hierarchy_node_id = l_parent_node_id
118: and pghn.node_type = 'EST'

Line 147: per_gen_hierarchy_nodes pghn1

143: select
144: pghn1.entity_id
145: ,pghn1.hierarchy_node_id
146: from
147: per_gen_hierarchy_nodes pghn1
148: ,hr_location_extra_info hlei1
149: ,hr_location_extra_info hlei2
150: ,hr_locations_all eloc
151: where

Line 168: ,per_gen_hierarchy_nodes pgn

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

Line 210: l_hierarchy_name per_gen_hierarchy.name%type;

206: l_business_group_name varchar2(240); --Increased variable size for Bug#9038285
207: lc_state varchar2(3);
208:
209: l_est_no number;
210: l_hierarchy_name per_gen_hierarchy.name%type;
211: l_hierarchy_version_num per_gen_hierarchy_versions.VERSION_NUMBER%type;
212: l_parent_org_id varchar2(20);
213: l_parent_node_id varchar2(20);
214:

Line 211: l_hierarchy_version_num per_gen_hierarchy_versions.VERSION_NUMBER%type;

207: lc_state varchar2(3);
208:
209: l_est_no number;
210: l_hierarchy_name per_gen_hierarchy.name%type;
211: l_hierarchy_version_num per_gen_hierarchy_versions.VERSION_NUMBER%type;
212: l_parent_org_id varchar2(20);
213: l_parent_node_id varchar2(20);
214:
215: l_reporting_name hr_organization_information.org_information1%type;

Line 278: per_gen_hierarchy_nodes

274:
275: cursor c_locs(est_id number ) is
276: select entity_id
277: from
278: per_gen_hierarchy_nodes
279: where
280: (hierarchy_node_id = est_id
281: or parent_hierarchy_node_id = est_id)
282: and hierarchy_version_id = p_hierarchy_version_id;

Line 291: ,per_gen_hierarchy_nodes pghn

287: pghn.hierarchy_node_id
288: from
289: hr_location_extra_info hlei1
290: ,hr_location_extra_info hlei2
291: ,per_gen_hierarchy_nodes pghn
292: ,hr_locations_all eloc
293: where
294: pghn.hierarchy_version_id = p_hierarchy_version_id
295: and pghn.parent_hierarchy_node_id = p_parent_node_id

Line 377: ,per_gen_hierarchy_nodes pgn

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
381: --AND l_month_start_date between asg.effective_start_date and asg.effective_end_date

Line 528: ,per_gen_hierarchy_nodes pgn

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
532: and peo.current_employee_flag = 'Y'

Line 588: ,per_gen_hierarchy_nodes pgn

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
592: and peo.current_employee_flag = 'Y'

Line 650: per_gen_hierarchy_nodes pgn,

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

Line 710: per_gen_hierarchy_nodes pgn,

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

Line 774: ,per_gen_hierarchy_nodes pgn

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
778: and peo.current_employee_flag = 'Y'

Line 829: ,per_gen_hierarchy_nodes pgn

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
833: and peo.current_employee_flag = 'Y'

Line 892: per_gen_hierarchy_nodes pgn,

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

Line 946: per_gen_hierarchy_nodes pgn,

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

Line 1007: ,per_gen_hierarchy_nodes pgn

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
1011: and peo.current_employee_flag = 'Y'

Line 1066: ,per_gen_hierarchy_nodes pgn

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
1070: and peo.current_employee_flag = 'Y'