[Home] [Help]
359: , ozf_reason_codes_all_b rc
360: , ar_lookups rlk_cm
361: , ar_lookups rlk_adj
362: , ozf_lookups lk_pm
363: , fnd_currencies_vl curr
364: WHERE c.claim_id = p_claim_id
365: AND c.cust_account_id = a.cust_account_id
366: AND a.party_id = hp.party_id
367: AND c.currency_code = curr.currency_code
623: , ozf_reason_codes_all_b rc
624: , ar_lookups rlk_cm
625: , ar_lookups rlk_adj
626: , ozf_lookups lk_pm
627: , fnd_currencies_vl curr
628: WHERE c.claim_id = p_claim_id
629: AND c.cust_account_id = a.cust_account_id
630: AND a.party_id = hp.party_id
631: AND c.currency_code = curr.currency_code
918: , ozf_reason_codes_all_b rc
919: , ar_lookups rlk_cm
920: , ar_lookups rlk_adj
921: , ozf_lookups lk_pm
922: , fnd_currencies_vl curr
923: WHERE c.claim_id = p_claim_id
924: AND c.cust_account_id = a.cust_account_id
925: AND a.party_id = hp.party_id
926: AND c.currency_code = curr.currency_code
1171: , ozf_reason_codes_all_b rc
1172: , ar_lookups rlk_cm
1173: , ar_lookups rlk_adj
1174: , ozf_lookups lk_pm
1175: , fnd_currencies_vl curr
1176: WHERE c.claim_id = p_claim_id
1177: AND c.cust_account_id = a.cust_account_id
1178: ANd a.party_id = hp.party_id
1179: AND c.currency_code = curr.currency_code
1426: , ozf_reason_codes_all_b rc
1427: , ar_lookups rlk_cm
1428: , ar_lookups rlk_adj
1429: , ozf_lookups lk_pm
1430: , fnd_currencies_vl curr
1431: WHERE c.claim_id = p_claim_id
1432: AND c.cust_account_id = a.cust_account_id
1433: AND a.party_id = hp.party_id
1434: AND c.currency_code = curr.currency_code
1705: , ozf_reason_codes_all_b rc
1706: , ar_lookups rlk_cm
1707: , ar_lookups rlk_adj
1708: , ozf_lookups lk_pm
1709: , fnd_currencies_vl curr
1710: WHERE c.claim_id = p_claim_id
1711: AND c.cust_account_id = a.cust_account_id
1712: AND a.party_id = hp.party_id
1713: AND c.currency_code = curr.currency_code