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.HR_H2PI_ERROR dependencies on HR_H2PI_ID_MAPPING

Line 271: hr_h2pi_id_mapping map,

267: et.element_name
268: INTO l_assignment_number,
269: l_element_name
270: FROM hr_h2pi_element_entries ee,
271: hr_h2pi_id_mapping map,
272: hr_h2pi_id_mapping map2,
273: pay_element_links_f el,
274: pay_element_types_f et,
275: hr_h2pi_assignments_v asg

Line 272: hr_h2pi_id_mapping map2,

268: INTO l_assignment_number,
269: l_element_name
270: FROM hr_h2pi_element_entries ee,
271: hr_h2pi_id_mapping map,
272: hr_h2pi_id_mapping map2,
273: pay_element_links_f el,
274: pay_element_types_f et,
275: hr_h2pi_assignments_v asg
276: WHERE ee.element_entry_id = csr_rec.from_id

Line 309: hr_h2pi_id_mapping map

305: SELECT assignment_number
306: INTO l_assignment_number
307: FROM hr_h2pi_salaries sal,
308: hr_h2pi_assignments_v asg,
309: hr_h2pi_id_mapping map
310: WHERE sal.pay_proposal_id = csr_rec.from_id
311: --AND sal.business_group_id = l_from_business_group_id
312: AND sal.client_id = l_from_client_id
313: AND sal.assignment_id = map.from_id

Line 338: hr_h2pi_id_mapping map

334: l_pay_method_name
335: FROM hr_h2pi_payment_methods ppm,
336: hr_h2pi_org_payment_methods opm,
337: hr_h2pi_assignments_v asg,
338: hr_h2pi_id_mapping map
339: WHERE personal_payment_method_id = csr_rec.from_id
340: --AND ppm.business_group_id = l_from_business_group_id
341: AND ppm.client_id = l_from_client_id
342: AND ppm.business_group_id = opm.business_group_id

Line 371: hr_h2pi_id_mapping map

367: INTO l_org_name,
368: l_org_classification
369: FROM hr_h2pi_organization_class ogc,
370: hr_h2pi_hr_organizations_v ogs,
371: hr_h2pi_id_mapping map
372: WHERE ogc.org_information_id = csr_rec.from_id
373: --AND ogc.business_group_id = l_from_business_group_id
374: AND ogc.client_id = l_from_client_id
375: AND ogc.organization_id = map.from_id

Line 398: hr_h2pi_id_mapping map

394: INTO l_org_name,
395: l_context
396: FROM hr_h2pi_organization_info ogi,
397: hr_h2pi_hr_organizations_v ogs,
398: hr_h2pi_id_mapping map
399: WHERE org_information_id = csr_rec.from_id
400: --AND ogi.business_group_id = l_from_business_group_id
401: AND ogi.client_id = l_from_client_id
402: AND ogi.organization_id = map.from_id

Line 445: hr_h2pi_id_mapping map

441: SELECT em.last_name || ', ' || em.first_name
442: INTO l_person_name
443: FROM hr_h2pi_addresses ad,
444: hr_h2pi_employees_v em,
445: hr_h2pi_id_mapping map
446: WHERE ad.address_id = csr_rec.from_id
447: --AND ad.business_group_id = l_from_business_group_id
448: AND ad.client_id = l_from_client_id
449: AND em.business_group_id = csr_rec.to_business_group_id

Line 468: hr_h2pi_id_mapping map

464: SELECT asg.assignment_number
465: INTO l_assignment_number
466: FROM hr_h2pi_federal_tax_rules ftr,
467: hr_h2pi_assignments_v asg,
468: hr_h2pi_id_mapping map
469: WHERE ftr.emp_fed_tax_rule_id = csr_rec.from_id
470: --AND ftr.business_group_id = l_from_business_group_id
471: AND ftr.client_id = l_from_client_id
472: AND asg.business_group_id = csr_rec.to_business_group_id

Line 491: hr_h2pi_id_mapping map

487: SELECT asg.assignment_number
488: INTO l_assignment_number
489: FROM hr_h2pi_state_tax_rules str,
490: hr_h2pi_assignments_v asg,
491: hr_h2pi_id_mapping map
492: WHERE str.emp_state_tax_rule_id = csr_rec.from_id
493: --AND str.business_group_id = l_from_business_group_id
494: AND str.client_id = l_from_client_id
495: AND str.assignment_id = map.from_id

Line 515: hr_h2pi_id_mapping map

511: SELECT asg.assignment_number
512: INTO l_assignment_number
513: FROM hr_h2pi_county_tax_rules ctr,
514: hr_h2pi_assignments_v asg,
515: hr_h2pi_id_mapping map
516: WHERE ctr.emp_county_tax_rule_id = csr_rec.from_id
517: --AND ctr.business_group_id = l_from_business_group_id
518: AND ctr.client_id = l_from_client_id
519: AND ctr.assignment_id = csr_rec.from_id

Line 539: hr_h2pi_id_mapping map

535: SELECT asg.assignment_number
536: INTO l_assignment_number
537: FROM hr_h2pi_city_tax_rules ctr,
538: hr_h2pi_assignments_v asg,
539: hr_h2pi_id_mapping map
540: WHERE ctr.emp_city_tax_rule_id = csr_rec.from_id
541: --AND ctr.business_group_id = l_from_business_group_id
542: AND ctr.client_id = l_from_client_id
543: AND ctr.assignment_id = map.from_id