[Home] [Help]
276: and parent_id = p_party_id
277: and effective_start_date <= sysdate
278: and effective_end_date >= sysdate
279: and hierarchy_type =
280: FND_PROFILE.VALUE('AR_CMGT_HIERARCHY_TYPE')
281: and g_source_name <> 'LNS'
282: UNION
283: select p_party_id from dual
284: UNION
498: and parent_id = :3
499: and effective_start_date <= sysdate
500: and effective_end_date >= sysdate
501: and hierarchy_type =
502: FND_PROFILE.VALUE(''AR_CMGT_HIERARCHY_TYPE'')
503: and :4 <> ''LNS''
504: union select :5 from dual
505: union
506: select hz_party_id
580: and parent_id = :3
581: and effective_start_date <= sysdate
582: and effective_end_date >= sysdate
583: and hierarchy_type =
584: FND_PROFILE.VALUE(''AR_CMGT_HIERARCHY_TYPE'')
585: union select :4 from dual
586: ))
587: and currency = :5
588: and largest_inv_cust_trx_id is not null
769: AND parent_id = p_party_id
770: AND effective_start_date <= sysdate
771: AND effective_end_date >= sysdate
772: AND hierarchy_type =
773: FND_PROFILE.VALUE('AR_CMGT_HIERARCHY_TYPE')
774: AND g_source_name <> 'LNS'
775: UNION
776: SELECT p_party_id FROM DUAL
777: UNION
892: and child_object_type = 'ORGANIZATION'
893: and parent_id = p_party_id
894: and effective_start_date <= sysdate
895: and effective_end_date >= sysdate
896: and hierarchy_type = FND_PROFILE.VALUE('AR_CMGT_HIERARCHY_TYPE')
897: and g_source_name <> 'LNS'
898: union select p_party_id from dual
899: UNION
900: select hz_party_id
925: and child_object_type = 'ORGANIZATION'
926: and parent_id = p_party_id
927: and effective_start_date <= sysdate
928: and effective_end_date >= sysdate
929: and hierarchy_type = FND_PROFILE.VALUE('AR_CMGT_HIERARCHY_TYPE')
930: and g_source_name <> 'LNS'
931: union select p_party_id from dual
932: UNION
933: select hz_party_id
1144: and parent_id = p_party_id
1145: and effective_start_date <= sysdate
1146: and effective_end_date >= sysdate
1147: and hierarchy_type =
1148: FND_PROFILE.VALUE('AR_CMGT_HIERARCHY_TYPE')
1149: and g_source_name <> 'LNS'
1150: union select p_party_id from dual
1151: UNION
1152: select hz_party_id
4875: and child_object_type = 'ORGANIZATION'
4876: and parent_id = p_party_id
4877: and effective_start_date <= sysdate
4878: and effective_end_date >= sysdate
4879: and hierarchy_type = FND_PROFILE.VALUE('AR_CMGT_HIERARCHY_TYPE')
4880: and g_source_name <> 'LNS'
4881: union select p_party_id from dual
4882: UNION
4883: select hz_party_id
5247: and child_object_type = 'ORGANIZATION'
5248: and parent_id = p_party_id
5249: and effective_start_date <= sysdate
5250: and effective_end_date >= sysdate
5251: and hierarchy_type = FND_PROFILE.VALUE('AR_CMGT_HIERARCHY_TYPE')
5252: and g_source_name <> 'LNS'
5253: union select p_party_id from dual
5254: UNION
5255: select hz_party_id
5501: and child_object_type = 'ORGANIZATION'
5502: and parent_id = p_party_id
5503: and effective_start_date <= sysdate
5504: and effective_end_date >= sysdate
5505: and hierarchy_type = FND_PROFILE.VALUE('AR_CMGT_HIERARCHY_TYPE')
5506: and g_source_name <> 'LNS'
5507: union select p_party_id from dual
5508: UNION
5509: select hz_party_id
5605: and child_object_type = 'ORGANIZATION'
5606: and parent_id = p_party_id
5607: and effective_start_date <= sysdate
5608: and effective_end_date >= sysdate
5609: and hierarchy_type = FND_PROFILE.VALUE('AR_CMGT_HIERARCHY_TYPE')
5610: and g_source_name <> 'LNS'
5611: union select p_party_id from dual
5612: UNION
5613: select hz_party_id
6289: and child_object_type = 'ORGANIZATION'
6290: and parent_id = p_party_id
6291: and effective_start_date <= sysdate
6292: and effective_end_date >= sysdate
6293: and hierarchy_type = FND_PROFILE.VALUE('AR_CMGT_HIERARCHY_TYPE')
6294: and g_source_name <> 'LNS'
6295: union select p_party_id from dual
6296: UNION
6297: select hz_party_id