APPS.PAY_US_INDIANA dependencies on PER_ADDRESSES

Line 435: FROM per_addresses pa

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

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

451: l_last_day := to_date('31-DEC-'||l_last_year,'DD/MM/YYYY');
452:
453: open csr_get_add ;
454:
455: hr_utility.trace('Updating the Per_Addresses for the esisting records...');
456:
457: loop
458:
459: fetch csr_get_add into l_add_rec;

Line 466: update PER_ADDRESSES

462:
463: /* End date the address record as of /12/31/2000 */
464:
465:
466: update PER_ADDRESSES
467: set date_to = l_last_day
468: where address_id = l_add_rec.address_id;
469:
470: hr_utility.trace('Updated Addresses : ' || to_char(l_add_rec.address_id));

Line 472: insert into PER_ADDRESSES

468: where address_id = l_add_rec.address_id;
469:
470: hr_utility.trace('Updated Addresses : ' || to_char(l_add_rec.address_id));
471:
472: insert into PER_ADDRESSES
473: (ADDRESS_ID,
474: BUSINESS_GROUP_ID,
475: PERSON_ID,
476: DATE_FROM,

Line 535: (per_addresses_s.NEXTVAL,

531: ADD_INFORMATION15,
532: ADD_INFORMATION16
533: )
534: values
535: (per_addresses_s.NEXTVAL,
536: l_add_rec.BUSINESS_GROUP_ID,
537: l_add_rec.PERSON_ID,
538: to_date('01-JAN-'||p_curr_year,'DD/MM/YYYY'),
539: --to_date('01-JAN-2001', 'DD-MON-YYYY'),