APPS.HZ_EXTENSIBILITY_PVT dependencies on HZ_PER_PROFILES_EXT_B

Line 442: INSERT INTO HZ_PER_PROFILES_EXT_B (

438: -- When the record is copied the original extension_id is stored
439: -- in the old_extension_id column of the record, so that it can be
440: -- used by the CPUI componenet.
441:
442: INSERT INTO HZ_PER_PROFILES_EXT_B (
443: extension_id,
444: person_profile_id,
445: attr_group_id,
446: created_by,

Line 562: FROM HZ_PER_PROFILES_EXT_B

558: d_ext_attr8,
559: d_ext_attr9,
560: d_ext_attr10,
561: extension_id
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 (

Line 629: FROM HZ_PER_PROFILES_EXT_B b,

625: tl.tl_ext_attr17,
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;

Line 1018: FROM hz_per_profiles_ext_b ext

1014: AND p1.actual_content_source IN ('SST','USER_ENTERED')
1015: AND p2.actual_content_source IN ('SST','USER_ENTERED')
1016: AND NOT EXISTS (
1017: SELECT null
1018: FROM hz_per_profiles_ext_b ext
1019: WHERE p1.person_profile_id = ext.person_profile_id)
1020: AND p2.party_id = p1.party_id
1021: AND p2.person_profile_id <> p1.person_profile_id
1022: AND EXISTS (

Line 1024: FROM hz_per_profiles_ext_b ext

1020: AND p2.party_id = p1.party_id
1021: AND p2.person_profile_id <> p1.person_profile_id
1022: AND EXISTS (
1023: SELECT null
1024: FROM hz_per_profiles_ext_b ext
1025: WHERE p2.person_profile_id = ext.person_profile_id)
1026: GROUP BY p1.person_profile_id);
1027:
1028: END IF;

Line 1361: INSERT INTO hz_per_profiles_ext_b ext (

1357: BEGIN
1358:
1359: -- insert into _b table
1360: --
1361: INSERT INTO hz_per_profiles_ext_b ext (
1362: extension_id,
1363: person_profile_id,
1364: attr_group_id,
1365: created_by,

Line 1481: FROM hz_per_profiles_ext_b b,

1477: d_ext_attr8,
1478: d_ext_attr9,
1479: d_ext_attr10,
1480: extension_id
1481: FROM hz_per_profiles_ext_b b,
1482: hz_per_profiles_ext_sg sg
1483: WHERE
1484: sg.work_unit_number = p_work_unit_number
1485: AND b.person_profile_id = sg.old_profile_id;

Line 1495: fnd_stats.gather_table_stats('AR', 'HZ_PER_PROFILES_EXT_B');

1491: END IF;
1492:
1493: -- gather table statistics
1494: --
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 (

Line 1562: FROM hz_per_profiles_ext_b b,

1558: tl.tl_ext_attr17,
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

Line 1779: FROM hz_per_profiles_ext_b

1775: WHERE rownum = 1;
1776:
1777: CURSOR c_per_extension_exists IS
1778: SELECT 'Y'
1779: FROM hz_per_profiles_ext_b
1780: WHERE rownum = 1;
1781:
1782: l_owner VARCHAR2(100);
1783: l_do_copy VARCHAR2(1);