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 1010: FROM hz_per_profiles_ext_b ext

1006: hz_person_profiles p2
1007: WHERE p1.effective_end_date is null
1008: AND NOT EXISTS (
1009: SELECT null
1010: FROM hz_per_profiles_ext_b ext
1011: WHERE p1.person_profile_id = ext.person_profile_id)
1012: AND p2.party_id = p1.party_id
1013: AND p2.person_profile_id <> p1.person_profile_id
1014: AND EXISTS (

Line 1016: FROM hz_per_profiles_ext_b ext

1012: AND p2.party_id = p1.party_id
1013: AND p2.person_profile_id <> p1.person_profile_id
1014: AND EXISTS (
1015: SELECT null
1016: FROM hz_per_profiles_ext_b ext
1017: WHERE p2.person_profile_id = ext.person_profile_id)
1018: GROUP BY p1.person_profile_id);
1019:
1020: END IF;

Line 1353: INSERT INTO hz_per_profiles_ext_b ext (

1349: BEGIN
1350:
1351: -- insert into _b table
1352: --
1353: INSERT INTO hz_per_profiles_ext_b ext (
1354: extension_id,
1355: person_profile_id,
1356: attr_group_id,
1357: created_by,

Line 1473: FROM hz_per_profiles_ext_b b,

1469: d_ext_attr8,
1470: d_ext_attr9,
1471: d_ext_attr10,
1472: extension_id
1473: FROM hz_per_profiles_ext_b b,
1474: hz_per_profiles_ext_sg sg
1475: WHERE
1476: sg.work_unit_number = p_work_unit_number
1477: AND b.person_profile_id = sg.old_profile_id;

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

1483: END IF;
1484:
1485: -- gather table statistics
1486: --
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 (

Line 1554: FROM hz_per_profiles_ext_b b,

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

Line 1771: FROM hz_per_profiles_ext_b

1767: WHERE rownum = 1;
1768:
1769: CURSOR c_per_extension_exists IS
1770: SELECT 'Y'
1771: FROM hz_per_profiles_ext_b
1772: WHERE rownum = 1;
1773:
1774: l_owner VARCHAR2(100);
1775: l_do_copy VARCHAR2(1);