APPS.ARP_PAY_REL_CUST_PKG dependencies on HZ_CODE_ASSIGNMENTS

Line 53: FROM hz_code_assignments ca

49: PAY_ANY and PAY_TOP_DOWN. We use the presence of each to include
50: a UNION clause for that type in the dynamic sql. */
51: cursor c_rel_grp IS
52: SELECT distinct ca.class_code class
53: FROM hz_code_assignments ca
54: ,hz_relationship_types rt
55: WHERE ca.class_category = 'RELATIONSHIP_TYPE_GROUP'
56: AND ca.owner_table_name = 'HZ_RELATIONSHIP_TYPES'
57: AND ca.status = 'A'

Line 168: ' FROM hz_code_assignments ca' || CRLF ||

164: 'AND hn.child_table_name = ''HZ_PARTIES''' || CRLF ||
165: 'AND hn.child_object_type = ''ORGANIZATION''' || CRLF ||
166: 'AND EXISTS ' || CRLF ||
167: ' (SELECT /*+ NO_UNNEST PUSH_SUBQ */ 1' || CRLF ||
168: ' FROM hz_code_assignments ca' || CRLF ||
169: ' ,hz_relationship_types rt ' || CRLF ||
170: ' WHERE ca.class_category = ''RELATIONSHIP_TYPE_GROUP''' || CRLF ||
171: ' AND ca.owner_table_name = ''HZ_RELATIONSHIP_TYPES''' || CRLF ||
172: ' AND ca.class_code = ''PARTY_REL_GRP_AR_PAY_ANY'''|| CRLF ||

Line 206: ' FROM hz_code_assignments ca' || CRLF ||

202: 'AND hn.child_table_name = ''HZ_PARTIES''' || CRLF ||
203: 'AND hn.child_object_type = ''ORGANIZATION''' || CRLF ||
204: 'AND EXISTS ' || CRLF ||
205: ' (SELECT /*+ NO_UNNEST PUSH_SUBQ */ 1' || CRLF ||
206: ' FROM hz_code_assignments ca' || CRLF ||
207: ' ,hz_relationship_types rt ' || CRLF ||
208: ' WHERE ca.class_category = ''RELATIONSHIP_TYPE_GROUP''' || CRLF ||
209: ' AND ca.owner_table_name = ''HZ_RELATIONSHIP_TYPES''' || CRLF ||
210: ' AND ca.class_code = ''PARTY_REL_GRP_AR_PAY_TOP_DOWN'''|| CRLF ||

Line 292: FROM hz_code_assignments ca

288: PAY_ANY and PAY_TOP_DOWN. We use the presence of each to include
289: a UNION clause for that type in the dynamic sql. */
290: cursor c_rel_grp IS
291: SELECT distinct ca.class_code class
292: FROM hz_code_assignments ca
293: ,hz_relationship_types rt
294: WHERE ca.class_category = 'RELATIONSHIP_TYPE_GROUP'
295: AND ca.owner_table_name = 'HZ_RELATIONSHIP_TYPES'
296: AND ca.status = 'A'

Line 412: ' FROM hz_code_assignments ca' || CRLF ||

408: 'AND hn.child_table_name = ''HZ_PARTIES''' || CRLF ||
409: 'AND hn.child_object_type = ''ORGANIZATION''' || CRLF ||
410: 'AND EXISTS ' || CRLF ||
411: ' (SELECT /*+ NO_UNNEST PUSH_SUBQ */ 1' || CRLF ||
412: ' FROM hz_code_assignments ca' || CRLF ||
413: ' ,hz_relationship_types rt ' || CRLF ||
414: ' WHERE ca.class_category = ''RELATIONSHIP_TYPE_GROUP''' || CRLF ||
415: ' AND ca.owner_table_name = ''HZ_RELATIONSHIP_TYPES''' || CRLF ||
416: ' AND ca.class_code = ''PARTY_REL_GRP_AR_PAY_ANY'''|| CRLF ||

Line 449: ' FROM hz_code_assignments ca' || CRLF ||

445: 'AND hn.child_table_name = ''HZ_PARTIES''' || CRLF ||
446: 'AND hn.child_object_type = ''ORGANIZATION''' || CRLF ||
447: 'AND EXISTS ' || CRLF ||
448: ' (SELECT /*+ NO_UNNEST PUSH_SUBQ */ 1' || CRLF ||
449: ' FROM hz_code_assignments ca' || CRLF ||
450: ' ,hz_relationship_types rt ' || CRLF ||
451: ' WHERE ca.class_category = ''RELATIONSHIP_TYPE_GROUP''' || CRLF ||
452: ' AND ca.owner_table_name = ''HZ_RELATIONSHIP_TYPES''' || CRLF ||
453: ' AND ca.class_code = ''PARTY_REL_GRP_AR_PAY_TOP_DOWN'''|| CRLF ||

Line 536: FROM hz_code_assignments ca

532: l_rows_inserted NUMBER;
533:
534: cursor c_rel_grp IS
535: SELECT distinct ca.class_code class
536: FROM hz_code_assignments ca
537: ,hz_relationship_types rt
538: WHERE ca.class_category = 'RELATIONSHIP_TYPE_GROUP'
539: AND ca.owner_table_name = 'HZ_RELATIONSHIP_TYPES'
540: AND ca.status = 'A'

Line 658: ' FROM hz_code_assignments ca' || CRLF ||

654: 'AND hn.child_table_name = ''HZ_PARTIES''' || CRLF ||
655: 'AND hn.child_object_type = ''ORGANIZATION''' || CRLF ||
656: 'AND EXISTS ' || CRLF ||
657: ' (SELECT /*+ NO_UNNEST PUSH_SUBQ */ 1' || CRLF ||
658: ' FROM hz_code_assignments ca' || CRLF ||
659: ' ,hz_relationship_types rt ' || CRLF ||
660: ' WHERE ca.class_category = ''RELATIONSHIP_TYPE_GROUP''' || CRLF ||
661: ' AND ca.owner_table_name = ''HZ_RELATIONSHIP_TYPES''' || CRLF ||
662: ' AND ca.class_code = ''PARTY_REL_GRP_AR_PAY_ANY'''|| CRLF ||

Line 692: ' FROM hz_code_assignments ca' || CRLF ||

688: 'AND hn.child_table_name = ''HZ_PARTIES''' || CRLF ||
689: 'AND hn.child_object_type = ''ORGANIZATION''' || CRLF ||
690: 'AND EXISTS ' || CRLF ||
691: ' (SELECT /*+ NO_UNNEST PUSH_SUBQ */ 1' || CRLF ||
692: ' FROM hz_code_assignments ca' || CRLF ||
693: ' ,hz_relationship_types rt ' || CRLF ||
694: ' WHERE ca.class_category = ''RELATIONSHIP_TYPE_GROUP''' || CRLF ||
695: ' AND ca.owner_table_name = ''HZ_RELATIONSHIP_TYPES''' || CRLF ||
696: ' AND ca.class_code = ''PARTY_REL_GRP_AR_PAY_TOP_DOWN'''|| CRLF ||