[Home] [Help]
217: and parent_id = p_party_id
218: and effective_start_date <= sysdate
219: and effective_end_date >= sysdate
220: and hierarchy_type =
221: FND_PROFILE.VALUE('AR_CMGT_HIERARCHY_TYPE')
222: and g_source_name <> 'LNS'
223: UNION
224: select p_party_id from dual
225: UNION
439: and parent_id = :3
440: and effective_start_date <= sysdate
441: and effective_end_date >= sysdate
442: and hierarchy_type =
443: FND_PROFILE.VALUE(''AR_CMGT_HIERARCHY_TYPE'')
444: and :4 <> ''LNS''
445: union select :5 from dual
446: union
447: select hz_party_id
521: and parent_id = :3
522: and effective_start_date <= sysdate
523: and effective_end_date >= sysdate
524: and hierarchy_type =
525: FND_PROFILE.VALUE(''AR_CMGT_HIERARCHY_TYPE'')
526: union select :4 from dual
527: ))
528: and currency = :5
529: and largest_inv_cust_trx_id is not null
710: AND parent_id = p_party_id
711: AND effective_start_date <= sysdate
712: AND effective_end_date >= sysdate
713: AND hierarchy_type =
714: FND_PROFILE.VALUE('AR_CMGT_HIERARCHY_TYPE')
715: AND g_source_name <> 'LNS'
716: UNION
717: SELECT p_party_id FROM DUAL
718: UNION
833: and child_object_type = 'ORGANIZATION'
834: and parent_id = p_party_id
835: and effective_start_date <= sysdate
836: and effective_end_date >= sysdate
837: and hierarchy_type = FND_PROFILE.VALUE('AR_CMGT_HIERARCHY_TYPE')
838: and g_source_name <> 'LNS'
839: union select p_party_id from dual
840: UNION
841: select hz_party_id
866: and child_object_type = 'ORGANIZATION'
867: and parent_id = p_party_id
868: and effective_start_date <= sysdate
869: and effective_end_date >= sysdate
870: and hierarchy_type = FND_PROFILE.VALUE('AR_CMGT_HIERARCHY_TYPE')
871: and g_source_name <> 'LNS'
872: union select p_party_id from dual
873: UNION
874: select hz_party_id
1085: and parent_id = p_party_id
1086: and effective_start_date <= sysdate
1087: and effective_end_date >= sysdate
1088: and hierarchy_type =
1089: FND_PROFILE.VALUE('AR_CMGT_HIERARCHY_TYPE')
1090: and g_source_name <> 'LNS'
1091: union select p_party_id from dual
1092: UNION
1093: select hz_party_id
4796: and child_object_type = 'ORGANIZATION'
4797: and parent_id = p_party_id
4798: and effective_start_date <= sysdate
4799: and effective_end_date >= sysdate
4800: and hierarchy_type = FND_PROFILE.VALUE('AR_CMGT_HIERARCHY_TYPE')
4801: and g_source_name <> 'LNS'
4802: union select p_party_id from dual
4803: UNION
4804: select hz_party_id
5198: and child_object_type = 'ORGANIZATION'
5199: and parent_id = p_party_id
5200: and effective_start_date <= sysdate
5201: and effective_end_date >= sysdate
5202: and hierarchy_type = FND_PROFILE.VALUE('AR_CMGT_HIERARCHY_TYPE')
5203: and g_source_name <> 'LNS'
5204: union select p_party_id from dual
5205: UNION
5206: select hz_party_id
5452: and child_object_type = 'ORGANIZATION'
5453: and parent_id = p_party_id
5454: and effective_start_date <= sysdate
5455: and effective_end_date >= sysdate
5456: and hierarchy_type = FND_PROFILE.VALUE('AR_CMGT_HIERARCHY_TYPE')
5457: and g_source_name <> 'LNS'
5458: union select p_party_id from dual
5459: UNION
5460: select hz_party_id
5556: and child_object_type = 'ORGANIZATION'
5557: and parent_id = p_party_id
5558: and effective_start_date <= sysdate
5559: and effective_end_date >= sysdate
5560: and hierarchy_type = FND_PROFILE.VALUE('AR_CMGT_HIERARCHY_TYPE')
5561: and g_source_name <> 'LNS'
5562: union select p_party_id from dual
5563: UNION
5564: select hz_party_id