APPS.AMS_GEN_APPROVAL_PVT dependencies on OZF_CLAIMS_ALL

Line 627: FROM ozf_claims_all

623:
624:
625: CURSOR c_claim_class IS
626: SELECT claim_class
627: FROM ozf_claims_all
628: WHERE claim_id = p_activity_id;
629: /*
630: order by (power(2,decode(business_unit_id,'',0,5)) +
631: power(2,decode(organization_id,'',0,4)) +

Line 3073: FROM ozf_claims_all c, ozf_claim_lines_all l

3069: , '' -- desc
3070: , c.owner_id -- owner
3071: , c.currency_code -- currency
3072: , '' -- priority desc
3073: FROM ozf_claims_all c, ozf_claim_lines_all l
3074: WHERE c.claim_id = l.claim_id(+) -- Bug 2848568
3075: AND c.claim_id = p_activity_id
3076: GROUP BY c.claim_number, c.custom_setup_id, c.org_id, c.claim_type_id,
3077: c.reason_code_id, c.claim_date, c.due_date, c.owner_id, c.currency_code;