APPS.HZ_EXTENSIBILITY_PVT dependencies on HZ_PER_PROFILES_EXT_SG

Line 998: INSERT INTO hz_per_profiles_ext_sg (

994:
995: ELSIF p_entity_name = C_PER THEN
996: -- insert into person staging table
997: --
998: INSERT INTO hz_per_profiles_ext_sg (
999: old_profile_id,
1000: new_profile_id,
1001: work_unit_number,
1002: status

Line 1072: UPDATE hz_per_profiles_ext_sg

1068:
1069: ELSIF p_entity_name = C_PER THEN
1070: -- update per staging table
1071: --
1072: UPDATE hz_per_profiles_ext_sg
1073: SET status = p_status
1074: WHERE work_unit_number = p_work_unit_number;
1075:
1076: END IF;

Line 1482: hz_per_profiles_ext_sg sg

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;
1486:

Line 1564: hz_per_profiles_ext_sg sg

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
1568: AND tl.extension_id = b.old_extension_id;

Line 1610: FROM hz_per_profiles_ext_sg

1606: AND ROWNUM =1;
1607:
1608: CURSOR c_per_work_unit IS
1609: SELECT work_unit_number
1610: FROM hz_per_profiles_ext_sg
1611: WHERE status = 'N'
1612: AND ROWNUM =1;
1613:
1614: CURSOR c_lock_org_records (

Line 1627: FROM hz_per_profiles_ext_sg

1623: CURSOR c_lock_per_records (
1624: p_work_unit_number NUMBER
1625: ) IS
1626: SELECT *
1627: FROM hz_per_profiles_ext_sg
1628: WHERE status = 'N'
1629: AND work_unit_number = p_work_unit_number
1630: FOR UPDATE NOWAIT;
1631:

Line 1839: l_sql := l_sql||'HZ_PER_PROFILES_EXT_SG';

1835: l_sql := 'truncate table '||l_owner||'.';
1836: IF p_entity_name = C_ORG THEN
1837: l_sql := l_sql||'HZ_ORG_PROFILES_EXT_SG';
1838: ELSE
1839: l_sql := l_sql||'HZ_PER_PROFILES_EXT_SG';
1840: END IF;
1841: execute immediate l_sql;
1842:
1843: -- validate parameters