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_TAP dependencies on HR_ORGANIZATION_INFORMATION

Line 145: ,hr_organization_information hoi1

141: ,per_gen_hierarchy_nodes pghn
142: ,per_gen_hierarchy_nodes pgn
143: ,hr_locations_all eloc
144: ,hr_organization_units hou
145: ,hr_organization_information hoi1
146: ,hr_organization_information hoi2
147: ,hr_organization_information hoi3
148: ,hr_locations_all cloc
149: where pgn.hierarchy_version_id = pghn.hierarchy_version_id

Line 146: ,hr_organization_information hoi2

142: ,per_gen_hierarchy_nodes pgn
143: ,hr_locations_all eloc
144: ,hr_organization_units hou
145: ,hr_organization_information hoi1
146: ,hr_organization_information hoi2
147: ,hr_organization_information hoi3
148: ,hr_locations_all cloc
149: where pgn.hierarchy_version_id = pghn.hierarchy_version_id
150: and pgn.node_type = 'PAR'

Line 147: ,hr_organization_information hoi3

143: ,hr_locations_all eloc
144: ,hr_organization_units hou
145: ,hr_organization_information hoi1
146: ,hr_organization_information hoi2
147: ,hr_organization_information hoi3
148: ,hr_locations_all cloc
149: where pgn.hierarchy_version_id = pghn.hierarchy_version_id
150: and pgn.node_type = 'PAR'
151: and pgn.entity_id = hou.organization_id

Line 192: hr_organization_information hoi1,

188: nvl(count(decode(peo.per_information5,'OTEV',1,'OTEDV',1,'DVOEV',1,'VOEVV',1,'NSOP',1,'NSDISOP',1,'VIETNSOP',1,'VIETDISNSOP',1,null)),0)
189: FROM per_periods_of_service pds,
190: per_people_f peo,
191: per_assignments_f ass,
192: hr_organization_information hoi1,
193: hr_organization_information hoi2,
194: per_jobs job
195: WHERE (pds.date_start <= to_date(pay_magtape_generic.get_parameter_value('TRANSFER_DATE_END'),'YYYY/MM/DD HH24:MI:SS')
196: and nvl(pds.actual_termination_date,to_date('31-12-4712','DD-MM-YYYY')) >=

Line 193: hr_organization_information hoi2,

189: FROM per_periods_of_service pds,
190: per_people_f peo,
191: per_assignments_f ass,
192: hr_organization_information hoi1,
193: hr_organization_information hoi2,
194: per_jobs job
195: WHERE (pds.date_start <= to_date(pay_magtape_generic.get_parameter_value('TRANSFER_DATE_END'),'YYYY/MM/DD HH24:MI:SS')
196: and nvl(pds.actual_termination_date,to_date('31-12-4712','DD-MM-YYYY')) >=
197: to_date(pay_magtape_generic.get_parameter_value('TRANSFER_DATE_END'),'YYYY/MM/DD HH24:MI:SS')

Line 271: hr_organization_information hoi1,

267: 'TRANSFER_NO_NH_SEP_VETS=P',
268: nvl(count(decode(peo.per_information5,'NS',1,'NSDIS',1,'NSOP',1,'NSDISOP',1,'VIETNS',1,'VIETDISNS',1,'VIETNSOP',1,'VIETDISNSOP',1,null)),0)
269: FROM per_people_f peo,
270: per_assignments_f ass,
271: hr_organization_information hoi1,
272: hr_organization_information hoi2,
273: per_periods_of_service pds,
274: per_jobs job
275: WHERE peo.person_id = ass.person_id

Line 272: hr_organization_information hoi2,

268: nvl(count(decode(peo.per_information5,'NS',1,'NSDIS',1,'NSOP',1,'NSDISOP',1,'VIETNS',1,'VIETDISNS',1,'VIETNSOP',1,'VIETDISNSOP',1,null)),0)
269: FROM per_people_f peo,
270: per_assignments_f ass,
271: hr_organization_information hoi1,
272: hr_organization_information hoi2,
273: per_periods_of_service pds,
274: per_jobs job
275: WHERE peo.person_id = ass.person_id
276: and pds.date_start between to_date(pay_magtape_generic.get_parameter_value('TRANSFER_DATE_START'),'YYYY/MM/DD HH24:MI:SS')

Line 342: hr_organization_information hoi1,

338: cursor S_VETS_ASG_COUNT is
339: SELECT 'TRANSFER_COUNT_ASSIGNMENTS=P',
340: count(ass.assignment_id)
341: FROM per_assignments_f ass,
342: hr_organization_information hoi1,
343: -- hr_organization_information hoi2,
344: per_jobs job
345: WHERE job.job_information_category = 'US'
346: AND job.date_from <=

Line 343: -- hr_organization_information hoi2,

339: SELECT 'TRANSFER_COUNT_ASSIGNMENTS=P',
340: count(ass.assignment_id)
341: FROM per_assignments_f ass,
342: hr_organization_information hoi1,
343: -- hr_organization_information hoi2,
344: per_jobs job
345: WHERE job.job_information_category = 'US'
346: AND job.date_from <=
347: to_date(pay_magtape_generic.get_parameter_value('TRANSFER_DATE_END'),'YYYY/MM/DD HH24:MI:SS')

Line 387: hr_organization_information hoi1,

383: SELECT 'TRANSFER_MIN_COUNT_ASSIGNMENTS=P',
384: count (distinct pds.person_id)
385: FROM per_periods_of_service pds,
386: per_assignments_f ass,
387: hr_organization_information hoi1,
388: hr_organization_information hoi2,
389: per_jobs job
390: WHERE pds.date_start <=
391: to_date(pay_magtape_generic.get_parameter_value('TRANSFER_DATE_START'),'YYYY/MM/DD HH24:MI:SS')

Line 388: hr_organization_information hoi2,

384: count (distinct pds.person_id)
385: FROM per_periods_of_service pds,
386: per_assignments_f ass,
387: hr_organization_information hoi1,
388: hr_organization_information hoi2,
389: per_jobs job
390: WHERE pds.date_start <=
391: to_date(pay_magtape_generic.get_parameter_value('TRANSFER_DATE_START'),'YYYY/MM/DD HH24:MI:SS')
392: AND (nvl(pds.actual_termination_date,