[Home] [Help]
1243: from hz_trans_attributes_b
1244: where attribute_name = p_attr_name
1245: and entity_name = p_entity_name)
1246: and function_id in (select function_id
1247: from hz_match_rule_primary e, hz_primary_trans d
1248: where match_rule_id = p_match_rule_id
1249: and e.PRIMARY_ATTRIBUTE_ID = d.PRIMARY_ATTRIBUTE_ID
1250: union
1251: select function_id
1283: FOR TX IN ( select STAGED_ATTRIBUTE_COLUMN
1284: from hz_trans_functions_b
1285: where function_id in
1286: (select function_id
1287: from hz_match_rule_primary e, hz_primary_trans d
1288: where match_rule_id = p_rule_id
1289: and e.PRIMARY_ATTRIBUTE_ID = d.PRIMARY_ATTRIBUTE_ID
1290: union
1291: select function_id
1438: from hz_trans_attributes_b
1439: where attribute_name = p_attr_name
1440: and entity_name = p_entity_name)
1441: and function_id in (select function_id
1442: from hz_match_rule_primary e, hz_primary_trans d
1443: where match_rule_id = p_rule_id
1444: and e.PRIMARY_ATTRIBUTE_ID = d.PRIMARY_ATTRIBUTE_ID
1445: union
1446: select function_id
1476: END IF;
1477: FOR TX IN ( select STAGED_ATTRIBUTE_COLUMN
1478: from hz_trans_functions_b
1479: where function_id in (select function_id
1480: from hz_match_rule_primary e, hz_primary_trans d
1481: where e.PRIMARY_ATTRIBUTE_ID = d.PRIMARY_ATTRIBUTE_ID
1482: and match_rule_id = p_rule_id
1483: union
1484: select function_id
1756: where b.attribute_id = c.attribute_id
1757: --Fix for bug 4669257. Removing the hardcoded reference below.
1758: --and userenv('LANG') = 'US'
1759: and b.function_id in (select function_id
1760: from hz_match_rule_primary d, hz_primary_trans e
1761: where match_rule_id = p_rule_id
1762: and d.primary_attribute_id = e.primary_attribute_id
1763: union
1764: select function_id
1805: --Fix for bug 4669257. Removing the hardcoded reference below.
1806: --and userenv('LANG') = 'US'
1807: and b.function_id in
1808: (select function_id
1809: from hz_match_rule_primary d, hz_primary_trans e
1810: where match_rule_id = p_rule_id
1811: and d.primary_attribute_id = e.primary_attribute_id
1812: union
1813: select function_id
1850: --Fix for bug 4669257. Removing the hardcoded reference below.
1851: --and userenv('LANG') = 'US'
1852: and b.function_id in
1853: (select function_id
1854: from hz_match_rule_primary d, hz_primary_trans e
1855: where match_rule_id = p_rule_id
1856: and d.primary_attribute_id = e.primary_attribute_id
1857: union
1858: select function_id
3528: from hz_trans_attributes_b
3529: where attribute_name = 'CONTACT_NAME'
3530: and entity_name = 'CONTACTS')
3531: and function_id in (select function_id
3532: from hz_match_rule_primary e, hz_primary_trans d
3533: where match_rule_id = p_rule_id
3534: and e.PRIMARY_ATTRIBUTE_ID = d.PRIMARY_ATTRIBUTE_ID
3535: union
3536: select function_id
3561: from hz_trans_attributes_b
3562: where attribute_name = 'RAW_PHONE_NUMBER'
3563: and entity_name = 'CONTACT_POINTS')
3564: and function_id in (select function_id
3565: from hz_match_rule_primary e, hz_primary_trans d
3566: where match_rule_id = p_rule_id
3567: and e.PRIMARY_ATTRIBUTE_ID = d.PRIMARY_ATTRIBUTE_ID
3568: union
3569: select function_id
3587: from hz_trans_attributes_b
3588: where attribute_name = 'ADDRESS'
3589: and entity_name = 'PARTY_SITES')
3590: and function_id in (select function_id
3591: from hz_match_rule_primary e, hz_primary_trans d
3592: where match_rule_id = p_rule_id
3593: and e.PRIMARY_ATTRIBUTE_ID = d.PRIMARY_ATTRIBUTE_ID
3594: union
3595: select function_id
3803: ) IS
3804:
3805: CURSOR check_inactive IS
3806: SELECT 1
3807: FROM hz_match_rule_primary p, hz_primary_trans pt, hz_trans_functions_vl f
3808: WHERE p.match_rule_id = p_rule_id
3809: AND pt.PRIMARY_ATTRIBUTE_ID = p.PRIMARY_ATTRIBUTE_ID
3810: AND f.function_id = pt.function_id
3811: --Fix for bug 4669257. Removing the hardcoded reference below.