APPS.HZ_EXTENSIBILITY_PVT dependencies on HZ_ORG_PROFILES_EXT_B

Line 704: INSERT INTO hz_org_profiles_ext_b (

700: -- When the record is copied the original extension_id is stored
701: -- in the old_extension_id column of the record, so that it can be
702: -- used by the CPUI componenet.
703:
704: INSERT INTO hz_org_profiles_ext_b (
705: extension_id,
706: organization_profile_id,
707: attr_group_id,
708: created_by,

Line 824: FROM hz_org_profiles_ext_b

820: d_ext_attr8,
821: d_ext_attr9,
822: d_ext_attr10,
823: extension_id
824: FROM hz_org_profiles_ext_b
825: WHERE organization_profile_id = p_old_profile_id;
826:
827: IF (SQL%ROWCOUNT > 0) THEN
828: INSERT INTO hz_org_profiles_ext_tl (

Line 891: FROM hz_org_profiles_ext_b b,

887: tl.tl_ext_attr17,
888: tl.tl_ext_attr18,
889: tl.tl_ext_attr19,
890: tl.tl_ext_attr20
891: FROM hz_org_profiles_ext_b b,
892: hz_org_profiles_ext_tl tl
893: WHERE b.organization_profile_id = p_new_profile_id
894: AND tl.extension_id = b.old_extension_id;
895: END IF;

Line 979: FROM hz_org_profiles_ext_b ext

975: hz_organization_profiles p2
976: WHERE p1.effective_end_date is null
977: AND NOT EXISTS (
978: SELECT null
979: FROM hz_org_profiles_ext_b ext
980: WHERE p1.organization_profile_id = ext.organization_profile_id)
981: AND p2.party_id = p1.party_id
982: AND p2.organization_profile_id <> p1.organization_profile_id
983: AND EXISTS (

Line 985: FROM hz_org_profiles_ext_b ext

981: AND p2.party_id = p1.party_id
982: AND p2.organization_profile_id <> p1.organization_profile_id
983: AND EXISTS (
984: SELECT null
985: FROM hz_org_profiles_ext_b ext
986: WHERE p2.organization_profile_id = ext.organization_profile_id)
987: GROUP BY p1.organization_profile_id);
988:
989: ELSIF p_entity_name = C_PER THEN

Line 1104: INSERT INTO hz_org_profiles_ext_b ext (

1100: BEGIN
1101:
1102: -- insert into _b table
1103: --
1104: INSERT INTO hz_org_profiles_ext_b ext (
1105: extension_id,
1106: organization_profile_id,
1107: attr_group_id,
1108: created_by,

Line 1224: FROM hz_org_profiles_ext_b b,

1220: d_ext_attr8,
1221: d_ext_attr9,
1222: d_ext_attr10,
1223: extension_id
1224: FROM hz_org_profiles_ext_b b,
1225: hz_org_profiles_ext_sg sg
1226: WHERE
1227: sg.work_unit_number = p_work_unit_number
1228: AND b.organization_profile_id = sg.old_profile_id;

Line 1238: fnd_stats.gather_table_stats('AR', 'HZ_ORG_PROFILES_EXT_B');

1234: END IF;
1235:
1236: -- gather table statistics
1237: --
1238: fnd_stats.gather_table_stats('AR', 'HZ_ORG_PROFILES_EXT_B');
1239:
1240: -- insert into _tl table
1241: --
1242: INSERT INTO hz_org_profiles_ext_tl ext (

Line 1305: FROM hz_org_profiles_ext_b b,

1301: tl.tl_ext_attr17,
1302: tl.tl_ext_attr18,
1303: tl.tl_ext_attr19,
1304: tl.tl_ext_attr20
1305: FROM hz_org_profiles_ext_b b,
1306: hz_org_profiles_ext_tl tl,
1307: hz_org_profiles_ext_sg sg
1308: WHERE
1309: sg.work_unit_number = p_work_unit_number

Line 1766: FROM hz_org_profiles_ext_b

1762: ) IS
1763:
1764: CURSOR c_org_extension_exists IS
1765: SELECT 'Y'
1766: FROM hz_org_profiles_ext_b
1767: WHERE rownum = 1;
1768:
1769: CURSOR c_per_extension_exists IS
1770: SELECT 'Y'