APPS.AR_CMGT_DATA_POINTS_PKG dependencies on HZ_HIERARCHY_NODES

Line 213: from hz_hierarchy_nodes

209: select cust_account_id
210: FROM hz_cust_accounts
211: WHERE party_id in
212: ( SELECT child_id
213: from hz_hierarchy_nodes
214: where parent_object_type = 'ORGANIZATION'
215: and parent_table_name = 'HZ_PARTIES'
216: and child_object_type = 'ORGANIZATION'
217: and parent_id = p_party_id

Line 435: from hz_hierarchy_nodes

431: select cust_account_id
432: FROM hz_cust_accounts
433: WHERE party_id in
434: ( SELECT child_id
435: from hz_hierarchy_nodes
436: where parent_object_type = ''ORGANIZATION''
437: and parent_table_name = ''HZ_PARTIES''
438: and child_object_type = ''ORGANIZATION''
439: and parent_id = :3

Line 517: from hz_hierarchy_nodes

513: select cust_account_id
514: FROM hz_cust_accounts
515: WHERE party_id in
516: ( SELECT child_id
517: from hz_hierarchy_nodes
518: where parent_object_type = ''ORGANIZATION''
519: and parent_table_name = ''HZ_PARTIES''
520: and child_object_type = ''ORGANIZATION''
521: and parent_id = :3

Line 706: FROM hz_hierarchy_nodes

702: SELECT cust_account_id
703: FROM hz_cust_accounts
704: WHERE party_id in
705: ( SELECT child_id
706: FROM hz_hierarchy_nodes
707: WHERE parent_object_type = 'ORGANIZATION'
708: AND parent_table_name = 'HZ_PARTIES'
709: AND child_object_type = 'ORGANIZATION'
710: AND parent_id = p_party_id

Line 830: from hz_hierarchy_nodes

826: WHERE cust_account_id in (select cust_account_id
827: FROM hz_cust_accounts
828: WHERE party_id in
829: ( SELECT child_id
830: from hz_hierarchy_nodes
831: where parent_object_type = 'ORGANIZATION'
832: and parent_table_name = 'HZ_PARTIES'
833: and child_object_type = 'ORGANIZATION'
834: and parent_id = p_party_id

Line 863: from hz_hierarchy_nodes

859: (select cust_account_id
860: FROM hz_cust_accounts
861: WHERE party_id in
862: ( SELECT child_id
863: from hz_hierarchy_nodes
864: where parent_object_type = 'ORGANIZATION'
865: and parent_table_name = 'HZ_PARTIES'
866: and child_object_type = 'ORGANIZATION'
867: and parent_id = p_party_id

Line 1081: from hz_hierarchy_nodes

1077: select cust_account_id
1078: FROM hz_cust_accounts
1079: WHERE party_id in
1080: ( SELECT child_id
1081: from hz_hierarchy_nodes
1082: where parent_object_type = 'ORGANIZATION'
1083: and parent_table_name = 'HZ_PARTIES'
1084: and child_object_type = 'ORGANIZATION'
1085: and parent_id = p_party_id

Line 4793: from hz_hierarchy_nodes

4789: WHERE CUST_ACCOUNT_ID in (select cust_account_id
4790: FROM hz_cust_accounts
4791: WHERE party_id in
4792: ( SELECT child_id
4793: from hz_hierarchy_nodes
4794: where parent_object_type = 'ORGANIZATION'
4795: and parent_table_name = 'HZ_PARTIES'
4796: and child_object_type = 'ORGANIZATION'
4797: and parent_id = p_party_id

Line 5195: from hz_hierarchy_nodes

5191: WHERE cust_account_id in (select cust_account_id
5192: FROM hz_cust_accounts
5193: WHERE party_id in
5194: ( SELECT child_id
5195: from hz_hierarchy_nodes
5196: where parent_object_type = 'ORGANIZATION'
5197: and parent_table_name = 'HZ_PARTIES'
5198: and child_object_type = 'ORGANIZATION'
5199: and parent_id = p_party_id

Line 5449: from hz_hierarchy_nodes

5445: WHERE cust_account_id in (select cust_account_id
5446: FROM hz_cust_accounts
5447: WHERE party_id in
5448: ( SELECT child_id
5449: from hz_hierarchy_nodes
5450: where parent_object_type = 'ORGANIZATION'
5451: and parent_table_name = 'HZ_PARTIES'
5452: and child_object_type = 'ORGANIZATION'
5453: and parent_id = p_party_id

Line 5553: from hz_hierarchy_nodes

5549: WHERE cust_account_id in (select cust_account_id
5550: FROM hz_cust_accounts
5551: WHERE party_id in
5552: ( SELECT child_id
5553: from hz_hierarchy_nodes
5554: where parent_object_type = 'ORGANIZATION'
5555: and parent_table_name = 'HZ_PARTIES'
5556: and child_object_type = 'ORGANIZATION'
5557: and parent_id = p_party_id