APPS.PAY_US_INDIANA dependencies on PER_ADDRESSES

Line 437: FROM per_addresses pa

433:
434:
435: cursor csr_get_add is
436: SELECT *
437: FROM per_addresses pa
438: WHERE
439: pa.add_information17 = 'IN'
440: and pa.date_from < to_date('01-JAN-'||p_curr_year,'DD/MM/YYYY')
441: and pa.date_to is null

Line 448: FROM per_addresses pa,

444:
445:
446: cursor csr_get_ovr_add is
447: SELECT pa.*
448: FROM per_addresses pa,
449: per_periods_of_service pos
450:
451: WHERE
452: pa.region_2 = 'IN'

Line 476: hr_utility.trace('Updating the Per_Addresses for the esisting records...');

472: l_last_day := to_date('31-DEC-'||l_last_year,'DD/MM/YYYY');
473:
474: open csr_get_add ;
475:
476: hr_utility.trace('Updating the Per_Addresses for the esisting records...');
477:
478: loop
479:
480: fetch csr_get_add into l_add_rec;

Line 487: update PER_ADDRESSES

483:
484: /* End date the address record as of /12/31/2000 */
485:
486:
487: update PER_ADDRESSES
488: set date_to = l_last_day
489: where address_id = l_add_rec.address_id;
490:
491: hr_utility.trace('Updated Addresses : ' || to_char(l_add_rec.address_id));

Line 493: insert into PER_ADDRESSES

489: where address_id = l_add_rec.address_id;
490:
491: hr_utility.trace('Updated Addresses : ' || to_char(l_add_rec.address_id));
492:
493: insert into PER_ADDRESSES
494: (ADDRESS_ID,
495: BUSINESS_GROUP_ID,
496: PERSON_ID,
497: DATE_FROM,

Line 556: (per_addresses_s.NEXTVAL,

552: ADD_INFORMATION15,
553: ADD_INFORMATION16
554: )
555: values
556: (per_addresses_s.NEXTVAL,
557: l_add_rec.BUSINESS_GROUP_ID,
558: l_add_rec.PERSON_ID,
559: to_date('01-JAN-'||p_curr_year,'DD/MM/YYYY'),
560: --to_date('01-JAN-2001', 'DD-MON-YYYY'),