356: , hz_parties hp
357: , ozf_claim_types_all_vl ct
358: , hz_cust_site_uses_all hc
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
357: , ozf_claim_types_all_vl ct
358: , hz_cust_site_uses_all hc
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
623: , hz_parties hp
624: , ozf_claim_types_all_vl ct
625: , hz_cust_site_uses_all hc
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
624: , ozf_claim_types_all_vl ct
625: , hz_cust_site_uses_all hc
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
926: , hz_parties hp
927: , ozf_claim_types_all_vl ct
928: , hz_cust_site_uses_all hc
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
927: , ozf_claim_types_all_vl ct
928: , hz_cust_site_uses_all hc
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
1179: , hz_parties hp
1180: , ozf_claim_types_all_vl ct
1181: , hz_cust_site_uses_all hc
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
1180: , ozf_claim_types_all_vl ct
1181: , hz_cust_site_uses_all hc
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
1434: , hz_parties hp
1435: , ozf_claim_types_all_vl ct
1436: , hz_cust_site_uses_all hc
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
1435: , ozf_claim_types_all_vl ct
1436: , hz_cust_site_uses_all hc
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
1713: , hz_parties hp
1714: , ozf_claim_types_all_vl ct
1715: , hz_cust_site_uses_all hc
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
1714: , ozf_claim_types_all_vl ct
1715: , hz_cust_site_uses_all hc
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