DBA Data[Home] [Help]

APPS.HZ_MAP_PARTY_PUB dependencies on HZ_CODE_ASSIGNMENTS

Line 1024: FND_ACCESS_CONTROL_UTIL.ADD_POLICY(l_ar_schema, 'HZ_CODE_ASSIGNMENTS', 'content_source_type_sec', l_apps_schema, 'hz_common_pub.content_source_type_security');

1020: FND_ACCESS_CONTROL_UTIL.ADD_POLICY(l_ar_schema, 'HZ_CONTACT_POINTS', 'content_source_type_sec', l_apps_schema, 'hz_common_pub.content_source_type_security');
1021: FND_ACCESS_CONTROL_UTIL.ADD_POLICY(l_ar_schema, 'HZ_CREDIT_RATINGS', 'content_source_type_sec', l_apps_schema, 'hz_common_pub.content_source_type_security');
1022: FND_ACCESS_CONTROL_UTIL.ADD_POLICY(l_ar_schema, 'HZ_FINANCIAL_REPORTS', 'content_source_type_sec', l_apps_schema, 'hz_common_pub.content_source_type_security');
1023: FND_ACCESS_CONTROL_UTIL.ADD_POLICY(l_ar_schema, 'HZ_FINANCIAL_NUMBERS', 'content_source_type_sec', l_apps_schema, 'hz_common_pub.content_source_type_security');
1024: FND_ACCESS_CONTROL_UTIL.ADD_POLICY(l_ar_schema, 'HZ_CODE_ASSIGNMENTS', 'content_source_type_sec', l_apps_schema, 'hz_common_pub.content_source_type_security');
1025: FND_ACCESS_CONTROL_UTIL.ADD_POLICY(l_ar_schema, 'HZ_ORGANIZATION_INDICATORS', 'content_source_type_sec', l_apps_schema, 'hz_common_pub.content_source_type_security');
1026: FND_ACCESS_CONTROL_UTIL.ADD_POLICY(l_ar_schema, 'HZ_PARTY_SITES', 'content_source_type_sec', l_apps_schema, 'hz_common_pub.content_source_type_security');
1027: */
1028: arp_util.debug('do_add_policy_function (-) ');

Line 3470: from hz_code_assignments

3466: l_object_version_number NUMBER;
3467:
3468: CURSOR old_code_assignment IS
3469: select code_assignment_id, object_version_number
3470: from hz_code_assignments
3471: where
3472: owner_table_name = p_code_assignment_rec.owner_table_name AND
3473: owner_table_id = p_code_assignment_rec.owner_table_id AND
3474: class_category = p_code_assignment_rec.class_category AND

Line 3557: from hz_code_assignments

3553: -- code assignment to Non-Primary as the party has another primary SIC code.
3554: BEGIN
3555: select code_assignment_id, object_version_number
3556: into l_code_assignment_id, l_object_version_number
3557: from hz_code_assignments
3558: where
3559: owner_table_name = p_code_assignment_rec.owner_table_name AND
3560: owner_table_id = p_code_assignment_rec.owner_table_id AND
3561: class_category = p_code_assignment_rec.class_category AND

Line 3894: from hz_code_assignments

3890:
3891: BEGIN
3892: select code_assignment_id, object_version_number , primary_flag
3893: into l_code_assignment_id, l_object_version_number, l_primary_flag
3894: from hz_code_assignments
3895: where
3896: owner_table_name = l_code_assignment_rec.owner_table_name AND
3897: owner_table_id = l_code_assignment_rec.owner_table_id AND
3898: class_category = l_code_assignment_rec.class_category AND