APPS.HZ_EXTENSIBILITY_PVT dependencies on HZ_PER_PROFILES_EXT_TL

Line 566: INSERT INTO HZ_PER_PROFILES_EXT_TL (

562: FROM HZ_PER_PROFILES_EXT_B
563: WHERE person_profile_id = p_old_profile_id;
564:
565: IF (SQL%ROWCOUNT > 0) THEN
566: INSERT INTO HZ_PER_PROFILES_EXT_TL (
567: extension_id,
568: person_profile_id,
569: attr_group_id,
570: source_lang,

Line 630: HZ_PER_PROFILES_EXT_TL tl

626: tl.tl_ext_attr18,
627: tl.tl_ext_attr19,
628: tl.tl_ext_attr20
629: FROM HZ_PER_PROFILES_EXT_B b,
630: HZ_PER_PROFILES_EXT_TL tl
631: WHERE b.person_profile_id = p_new_profile_id
632: AND tl.extension_id = b.old_extension_id;
633: END IF;
634:

Line 1491: INSERT INTO hz_per_profiles_ext_tl ext (

1487: fnd_stats.gather_table_stats('AR', 'HZ_PER_PROFILES_EXT_B');
1488:
1489: -- insert into _tl table
1490: --
1491: INSERT INTO hz_per_profiles_ext_tl ext (
1492: extension_id,
1493: person_profile_id,
1494: attr_group_id,
1495: source_lang,

Line 1555: hz_per_profiles_ext_tl tl,

1551: tl.tl_ext_attr18,
1552: tl.tl_ext_attr19,
1553: tl.tl_ext_attr20
1554: FROM hz_per_profiles_ext_b b,
1555: hz_per_profiles_ext_tl tl,
1556: hz_per_profiles_ext_sg sg
1557: WHERE
1558: sg.work_unit_number = p_work_unit_number
1559: AND b.person_profile_id = sg.new_profile_id

Line 1566: fnd_stats.gather_table_stats('AR', 'HZ_PER_PROFILES_EXT_TL');

1562: Write_Log(SQL%ROWCOUNT||' records inserted into per tl table.');
1563:
1564: -- gather table statistics
1565: --
1566: fnd_stats.gather_table_stats('AR', 'HZ_PER_PROFILES_EXT_TL');
1567:
1568: END copy_per_extension;
1569:
1570: