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 1499: INSERT INTO hz_per_profiles_ext_tl ext (

1495: fnd_stats.gather_table_stats('AR', 'HZ_PER_PROFILES_EXT_B');
1496:
1497: -- insert into _tl table
1498: --
1499: INSERT INTO hz_per_profiles_ext_tl ext (
1500: extension_id,
1501: person_profile_id,
1502: attr_group_id,
1503: source_lang,

Line 1563: hz_per_profiles_ext_tl tl,

1559: tl.tl_ext_attr18,
1560: tl.tl_ext_attr19,
1561: tl.tl_ext_attr20
1562: FROM hz_per_profiles_ext_b b,
1563: hz_per_profiles_ext_tl tl,
1564: hz_per_profiles_ext_sg sg
1565: WHERE
1566: sg.work_unit_number = p_work_unit_number
1567: AND b.person_profile_id = sg.new_profile_id

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

1570: Write_Log(SQL%ROWCOUNT||' records inserted into per tl table.');
1571:
1572: -- gather table statistics
1573: --
1574: fnd_stats.gather_table_stats('AR', 'HZ_PER_PROFILES_EXT_TL');
1575:
1576: END copy_per_extension;
1577:
1578: