APPS.HR_H2PI_ERROR dependencies on HR_H2PI_ASSIGNMENTS_V

Line 275: hr_h2pi_assignments_v asg

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
277: --AND ee.business_group_id = l_from_business_group_id
278: AND ee.client_id = l_from_client_id
279: AND ee.element_link_id = map.from_id

Line 308: hr_h2pi_assignments_v asg,

304: BEGIN
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

Line 337: hr_h2pi_assignments_v asg,

333: INTO l_assignment_number,
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

Line 467: hr_h2pi_assignments_v asg,

463: BEGIN
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

Line 490: hr_h2pi_assignments_v asg,

486: BEGIN
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

Line 514: hr_h2pi_assignments_v asg,

510: BEGIN
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

Line 538: hr_h2pi_assignments_v asg,

534: BEGIN
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