APPS.HZ_MERGE_ENTITY_ATTRI_PVT dependencies on FND_COLUMNS

Line 121: -- The following code is generated from fnd_columns, commented

117: elsif l_attribute_type = 'N' then
118: l_attribute_value := to_number(l_attribute_value);
119: end if;
120:
121: -- The following code is generated from fnd_columns, commented
122: -- out NOCOPY the columns are not supported in hz_party_v2pub.organization_rec
123: IF L_ATTRIBUTE_NAME = 'BEST_TIME_CONTACT_END' THEN
124: L_ORGANIZATION_REC.BEST_TIME_CONTACT_END := l_attribute_date_value;--L_ATTRIBUTE_VALUE; -- Bug No:3729832
125: ELSIF L_ATTRIBUTE_NAME = 'ORGANIZATION_NAME_PHONETIC' THEN

Line 532: -- The following code is generated from fnd_columns, commented

528: elsif l_attribute_type = 'N' then
529: l_attribute_value := to_number(l_attribute_value);
530: end if;
531:
532: -- The following code is generated from fnd_columns, commented
533: -- out NOCOPY the columns are not supported in hz_party_v2pub.person_rec
534:
535: IF (NVL(p_orig_sys_ref,'X') LIKE 'PER:%') THEN -- bug no: 4193165
536:

Line 1416: from fnd_tables tbl, fnd_columns col

1412: ) is
1413: cursor get_entity_attri_csr(l_table_name varchar2)
1414: is
1415: select col.column_name, col.column_type
1416: from fnd_tables tbl, fnd_columns col
1417: where tbl.table_id = col.table_id
1418: and tbl.table_name = l_table_name
1419: -- adding the following clause for performance 4956759
1420: and tbl.application_id = 222

Line 1558: from fnd_tables tbl, fnd_columns col

1554: x_msg_data OUT NOCOPY VARCHAR2
1555: ) is
1556: cursor get_entity_attri_csr(l_table_name varchar2) is
1557: select col.column_name, col.column_type
1558: from fnd_tables tbl, fnd_columns col
1559: where tbl.table_id = col.table_id
1560: and tbl.table_name = l_table_name
1561: -- adding the following clause for performance 4956759
1562: and tbl.application_id = 222