APPS.HZ_IMP_DQM_STAGE dependencies on HZ_TRANS_ATTRIBUTES_VL

Line 1755: from hz_trans_functions_b b, hz_trans_attributes_vl c

1751: ) IS
1752: BEGIN
1753: OPEN x_custom_cur FOR
1754: select ATTRIBUTE_NAME, USER_DEFINED_ATTRIBUTE_NAME, PROCEDURE_NAME, STAGED_ATTRIBUTE_COLUMN, b.attribute_id
1755: from hz_trans_functions_b b, hz_trans_attributes_vl c
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

Line 1803: from hz_trans_functions_b b, hz_trans_attributes_vl c

1799:
1800: -- VJN ADDED CODE FOR TRACKING CONDITION ATTRIBUTES AT THIS ENTITY LEVEL
1801: FOR TX IN ( ----------> CONDITIONAL REPLACEMENT CODE ENDS
1802: select STAGED_ATTRIBUTE_COLUMN, b.attribute_id
1803: from hz_trans_functions_b b, hz_trans_attributes_vl c
1804: where b.attribute_id = c.attribute_id
1805: --Fix for bug 4669257. Removing the hardcoded reference below.
1806: --and userenv('LANG') = 'US'
1807: and b.function_id in

Line 1848: from hz_trans_functions_b b, hz_trans_attributes_vl c

1844: l_trans_list(i) := ' HZ_TRANS_PKG.set_party_type(H_P_P_TYPE(I));';
1845: i := i + 1;
1846: END IF;
1847: FOR TX IN ( select ATTRIBUTE_NAME, USER_DEFINED_ATTRIBUTE_NAME, PROCEDURE_NAME, STAGED_ATTRIBUTE_COLUMN, b.attribute_id
1848: from hz_trans_functions_b b, hz_trans_attributes_vl c
1849: where b.attribute_id = c.attribute_id
1850: --Fix for bug 4669257. Removing the hardcoded reference below.
1851: --and userenv('LANG') = 'US'
1852: and b.function_id in

Line 2665: l(' from hz_trans_attributes_vl ');

2661: l(' x_contact_cur IN OUT NOCOPY StageImpContactCurTyp ');
2662: l(' ) IS ');
2663: l(' is_using_allow_cust_attr VARCHAR2(1); ');
2664: l(' CURSOR c1 is select ''Y'' ');
2665: l(' from hz_trans_attributes_vl ');
2666: l(' where entity_name = ''CONTACTS'' ');
2667: -- l(' and userenv(''LANG'') = ''US'' ');
2668: l(' and attribute_name = ''CONTACT_NAME'' ');
2669: l(' and attribute_id in ( ');

Line 2805: l(' from hz_trans_attributes_vl ');

2801: l(' x_contact_cur IN OUT NOCOPY StageImpContactCurTyp ');
2802: l(' ) IS ');
2803: l(' is_using_allow_cust_attr VARCHAR2(1); ');
2804: l(' CURSOR c1 is select ''Y'' ');
2805: l(' from hz_trans_attributes_vl ');
2806: l(' where entity_name = ''CONTACTS'' ');
2807: -- l(' and userenv(''LANG'') = ''US'' ');
2808: l(' and attribute_name = ''CONTACT_NAME'' ');
2809: l(' and attribute_id in ( ');

Line 3503: from hz_trans_attributes_vl

3499: l( ' H_' || TX.STAGED_ATTRIBUTE_COLUMN || ' CharList2000;');
3500: END LOOP;
3501:
3502: FOR TX2 IN ( select attribute_id
3503: from hz_trans_attributes_vl
3504: --Fix for bug 4669257. Removing the hardcoded reference below.
3505: -- where userenv('LANG') = 'US'
3506: where attribute_id in (select attribute_id
3507: from hz_match_rule_primary

Line 3671: from hz_trans_attributes_vl

3667: x_bool := using_allow_cust(p_rule_id, 'CONTACTS','CONTACT_NAME');--using_contact_name(p_rule_id);
3668: END IF;
3669: IF (x_bool <> 'Y') THEN
3670: select distinct 'Y' into x_bool
3671: from hz_trans_attributes_vl
3672: --Fix for bug 4669257. Removing the hardcoded reference below.
3673: --where userenv('LANG') = 'US'
3674: where entity_name = p_entity_name
3675: and custom_attribute_procedure is null