APPS.HZ_EXTENSIBILITY_PVT dependencies on HZ_PER_PROFILES_EXT_SG

Line 992: INSERT INTO hz_per_profiles_ext_sg (

988:
989: ELSIF p_entity_name = C_PER THEN
990: -- insert into person staging table
991: --
992: INSERT INTO hz_per_profiles_ext_sg (
993: old_profile_id,
994: new_profile_id,
995: work_unit_number,
996: status

Line 1064: UPDATE hz_per_profiles_ext_sg

1060:
1061: ELSIF p_entity_name = C_PER THEN
1062: -- update per staging table
1063: --
1064: UPDATE hz_per_profiles_ext_sg
1065: SET status = p_status
1066: WHERE work_unit_number = p_work_unit_number;
1067:
1068: END IF;

Line 1474: hz_per_profiles_ext_sg sg

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

Line 1556: hz_per_profiles_ext_sg sg

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

Line 1602: FROM hz_per_profiles_ext_sg

1598: AND ROWNUM =1;
1599:
1600: CURSOR c_per_work_unit IS
1601: SELECT work_unit_number
1602: FROM hz_per_profiles_ext_sg
1603: WHERE status = 'N'
1604: AND ROWNUM =1;
1605:
1606: CURSOR c_lock_org_records (

Line 1619: FROM hz_per_profiles_ext_sg

1615: CURSOR c_lock_per_records (
1616: p_work_unit_number NUMBER
1617: ) IS
1618: SELECT *
1619: FROM hz_per_profiles_ext_sg
1620: WHERE status = 'N'
1621: AND work_unit_number = p_work_unit_number
1622: FOR UPDATE NOWAIT;
1623:

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

1827: l_sql := 'truncate table '||l_owner||'.';
1828: IF p_entity_name = C_ORG THEN
1829: l_sql := l_sql||'HZ_ORG_PROFILES_EXT_SG';
1830: ELSE
1831: l_sql := l_sql||'HZ_PER_PROFILES_EXT_SG';
1832: END IF;
1833: execute immediate l_sql;
1834:
1835: -- validate parameters