APPS.HR_H2PI_ERROR dependencies on PER_ALL_ASSIGNMENTS_F

Line 123: l_assignment_number per_all_assignments_f.assignment_number%type;

119: PROCEDURE generate_error_report IS
120:
121: l_person_name per_all_people_f.full_name%type;
122: l_location_name hr_locations_all.location_code%type;
123: l_assignment_number per_all_assignments_f.assignment_number%type;
124: l_pay_method_name pay_org_payment_methods_f.org_payment_method_name%type;
125: l_org_name hr_all_organization_units.name%type;
126: l_context hr_organization_information.org_information_context%type;
127: l_org_classification hr_organization_information.org_information1%type;

Line 285: AND map2.table_name = 'PER_ALL_ASSIGNMENTS_F'

281: AND map.to_business_group_id = csr_rec.to_business_group_id
282: AND map.to_id = el.element_link_id
283: AND el.element_type_id = et.element_type_id
284: AND ee.assignment_id = map2.from_id
285: AND map2.table_name = 'PER_ALL_ASSIGNMENTS_F'
286: AND map2.to_business_group_id = csr_rec.to_business_group_id
287: AND map2.to_id = asg.assignment_id
288: AND ee.effective_start_date between el.effective_start_date
289: and el.effective_end_date

Line 314: AND map.table_name = 'PER_ALL_ASSIGNMENTS_F'

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
314: AND map.table_name = 'PER_ALL_ASSIGNMENTS_F'
315: AND map.to_business_group_id = csr_rec.to_business_group_id
316: AND map.to_id = asg.assignment_id
317: AND asg.business_group_id = csr_rec.to_business_group_id
318: AND sal.change_date between asg.effective_start_date

Line 346: AND map.table_name = 'PER_ALL_ASSIGNMENTS_F'

342: AND ppm.business_group_id = opm.business_group_id
343: AND ppm.org_payment_method_id = opm.org_payment_method_id
344: AND asg.business_group_id = csr_rec.to_business_group_id
345: AND ppm.assignment_id = map.from_id
346: AND map.table_name = 'PER_ALL_ASSIGNMENTS_F'
347: AND map.to_id = asg.assignment_id
348: AND ppm.effective_start_date between opm.effective_start_date
349: and opm.effective_end_date
350: AND ppm.effective_start_date between asg.effective_start_date

Line 474: AND map.table_name = 'PER_ALL_ASSIGNMENTS_F'

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
473: AND ftr.assignment_id = map.from_id
474: AND map.table_name = 'PER_ALL_ASSIGNMENTS_F'
475: AND map.to_id = asg.assignment_id
476: AND rownum < 2;
477:
478: l_text := 'Assignment No: ' || l_assignment_number || ' - ' || l_text ;

Line 496: AND map.table_name = 'PER_ALL_ASSIGNMENTS_F'

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
496: AND map.table_name = 'PER_ALL_ASSIGNMENTS_F'
497: AND map.to_id = asg.assignment_id
498: AND asg.business_group_id = csr_rec.to_business_group_id
499: AND rownum < 2;
500:

Line 520: AND map.table_name = 'PER_ALL_ASSIGNMENTS_F'

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
520: AND map.table_name = 'PER_ALL_ASSIGNMENTS_F'
521: AND map.to_id = asg.assignment_id
522: AND asg.business_group_id = csr_rec.to_business_group_id
523: AND rownum < 2;
524:

Line 544: AND map.table_name = 'PER_ALL_ASSIGNMENTS_F'

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
544: AND map.table_name = 'PER_ALL_ASSIGNMENTS_F'
545: AND map.to_id = asg.assignment_id
546: AND asg.business_group_id = csr_rec.to_business_group_id
547: AND rownum < 2;
548: