[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
626: , ozf_reason_codes_all_b rc
627: , ar_lookups rlk_cm
628: , ar_lookups rlk_adj
629: , ozf_lookups lk_pm
630: , fnd_currencies_vl curr
631: WHERE c.claim_id = p_claim_id
632: AND c.cust_account_id = a.cust_account_id
633: AND a.party_id = hp.party_id
634: AND c.currency_code = curr.currency_code
929: , ozf_reason_codes_all_b rc
930: , ar_lookups rlk_cm
931: , ar_lookups rlk_adj
932: , ozf_lookups lk_pm
933: , fnd_currencies_vl curr
934: WHERE c.claim_id = p_claim_id
935: AND c.cust_account_id = a.cust_account_id
936: AND a.party_id = hp.party_id
937: AND c.currency_code = curr.currency_code
1182: , ozf_reason_codes_all_b rc
1183: , ar_lookups rlk_cm
1184: , ar_lookups rlk_adj
1185: , ozf_lookups lk_pm
1186: , fnd_currencies_vl curr
1187: WHERE c.claim_id = p_claim_id
1188: AND c.cust_account_id = a.cust_account_id
1189: ANd a.party_id = hp.party_id
1190: AND c.currency_code = curr.currency_code
1437: , ozf_reason_codes_all_b rc
1438: , ar_lookups rlk_cm
1439: , ar_lookups rlk_adj
1440: , ozf_lookups lk_pm
1441: , fnd_currencies_vl curr
1442: WHERE c.claim_id = p_claim_id
1443: AND c.cust_account_id = a.cust_account_id
1444: AND a.party_id = hp.party_id
1445: AND c.currency_code = curr.currency_code
1716: , ozf_reason_codes_all_b rc
1717: , ar_lookups rlk_cm
1718: , ar_lookups rlk_adj
1719: , ozf_lookups lk_pm
1720: , fnd_currencies_vl curr
1721: WHERE c.claim_id = p_claim_id
1722: AND c.cust_account_id = a.cust_account_id
1723: AND a.party_id = hp.party_id
1724: AND c.currency_code = curr.currency_code