APPS.OZF_CLAIM_APPROVAL_PVT dependencies on OZF_CLAIMS

Line 18: from ozf_claims_all

14: l_org_id number;
15:
16: cursor get_claim_org_csr(p_id in number) is
17: select org_id
18: from ozf_claims_all
19: where claim_id = p_id;
20:
21: begin
22:

Line 354: FROM ozf_claims_all c

350: , rlk_cm.meaning
351: , rlk_adj.meaning
352: , lk_pm.meaning
353: , 'resource_name'
354: FROM ozf_claims_all c
355: , hz_cust_accounts a
356: , hz_parties hp
357: , ozf_claim_types_all_vl ct
358: , hz_cust_site_uses_all hc

Line 618: FROM ozf_claims_all c

614: , rlk_cm.meaning
615: , rlk_adj.meaning
616: , lk_pm.meaning
617: , 'resource_name'
618: FROM ozf_claims_all c
619: , hz_cust_accounts a
620: , hz_parties hp
621: , ozf_claim_types_all_vl ct
622: , hz_cust_site_uses_all hc

Line 913: FROM ozf_claims_all c

909: , rlk_cm.meaning
910: , rlk_adj.meaning
911: , lk_pm.meaning
912: , 'resource_name'
913: FROM ozf_claims_all c
914: , hz_cust_accounts a
915: , hz_parties hp
916: , ozf_claim_types_all_vl ct
917: , hz_cust_site_uses_all hc

Line 1166: FROM ozf_claims_all c

1162: , rlk_cm.meaning
1163: , rlk_adj.meaning
1164: , lk_pm.meaning
1165: , 'resource_name'
1166: FROM ozf_claims_all c
1167: , hz_cust_accounts a
1168: , hz_parties hp
1169: , ozf_claim_types_all_vl ct
1170: , hz_cust_site_uses_all hc

Line 1421: FROM ozf_claims_all c

1417: , rlk_cm.meaning
1418: , rlk_adj.meaning
1419: , lk_pm.meaning
1420: , 'resource_name'
1421: FROM ozf_claims_all c
1422: , hz_cust_accounts a
1423: , hz_parties hp
1424: , ozf_claim_types_all_vl ct
1425: , hz_cust_site_uses_all hc

Line 1682: FROM ozf_claims_all

1678: , claim_date
1679: , due_date
1680: , owner_id
1681: , currency_code
1682: FROM ozf_claims_all
1683: WHERE claim_id = p_act_id;
1684:
1685: CURSOR c_claim_rec(p_claim_id IN NUMBER) IS
1686: SELECT c.claim_number

Line 1700: FROM ozf_claims_all c

1696: , rlk_adj.meaning
1697: , lk_pm.meaning
1698: , 'resource_name'
1699: , c.comments
1700: FROM ozf_claims_all c
1701: , hz_cust_accounts a
1702: , hz_parties hp
1703: , ozf_claim_types_all_vl ct
1704: , hz_cust_site_uses_all hc

Line 1766: UPDATE ozf_claims_all

1762: CLOSE c_claim_obj;
1763:
1764: IF (funcmode = 'RUN') THEN
1765: BEGIN
1766: UPDATE ozf_claims_all
1767: SET appr_wf_item_key = itemkey
1768: WHERE claim_id = l_activity_id;
1769:
1770: IF ( l_approval_type = 'CLAIM' ) THEN

Line 2085: FROM ozf_claims

2081: SELECT object_version_number
2082: --, user_status_id
2083: , owner_id
2084: , comments
2085: FROM ozf_claims
2086: WHERE claim_id = l_claim_id;
2087:
2088: BEGIN
2089: x_return_status := FND_API.g_ret_sts_success;

Line 2101: UPDATE ozf_claims_all

2097:
2098: l_object_version_number := l_object_version_number + 1;
2099:
2100: BEGIN
2101: UPDATE ozf_claims_all
2102: SET OBJECT_VERSION_NUMBER = l_object_version_number
2103: WHERE claim_id = p_claim_id;
2104: EXCEPTION
2105: WHEN OTHERS THEN

Line 2207: FROM ozf_claims_all

2203: l_approval_require VARCHAR2(1);
2204:
2205: CURSOR csr_claim_obj_ver(cv_claim_id IN NUMBER) IS
2206: SELECT object_version_number
2207: FROM ozf_claims_all
2208: WHERE claim_id = cv_claim_id;
2209:
2210: CURSOR csr_get_claim_amount (cv_claim_id IN NUMBER) IS
2211: SELECT amount_settled

Line 2213: FROM ozf_claims_all

2209:
2210: CURSOR csr_get_claim_amount (cv_claim_id IN NUMBER) IS
2211: SELECT amount_settled
2212: , payment_method
2213: FROM ozf_claims_all
2214: WHERE claim_id = cv_claim_id;
2215:
2216:
2217: BEGIN