APPS.FV_CCR_GRP dependencies on FV_CCR_ORGS

Line 54: FROM fv_ccr_orgs fcorg

50: WHERE nvl(bank_branch_id,-99) = p_object_id;
51: ELSIF(p_object_type = 'T') THEN
52: SELECT ccr_id
53: INTO x_ccr_id
54: FROM fv_ccr_orgs fcorg
55: WHERE (nvl(fcorg.pay_site_id,-99)=p_object_id
56: OR nvl(fcorg.main_address_site_id,-99)=p_object_id);
57: ELSIF(p_object_type = 'A') THEN
58: SELECT ccr_id

Line 60: FROM fv_ccr_orgs fcorg

56: OR nvl(fcorg.main_address_site_id,-99)=p_object_id);
57: ELSIF(p_object_type = 'A') THEN
58: SELECT ccr_id
59: INTO x_ccr_id
60: FROM fv_ccr_orgs fcorg
61: WHERE nvl(bank_account_id,-99) = p_object_id;
62: END IF;
63: x_out_status := FND_API.G_TRUE;
64:

Line 165: FROM fv_ccr_vendors fcv, fv_ccr_orgs fco

161:
162: x_return_status := FND_API.G_RET_STS_SUCCESS;
163: SELECT fcv.ccr_status
164: INTO x_ccr_status
165: FROM fv_ccr_vendors fcv, fv_ccr_orgs fco
166: WHERE fcv.CCR_ID = fco.CCR_ID
167: AND (nvl(fco.pay_site_id,-99)=p_vendor_site_id
168: OR nvl(fco.main_address_site_id,-99)=p_vendor_site_id);
169:

Line 368: FROM fv_ccr_orgs

364: x_out_status := FND_API.G_FALSE;
365:
366: SELECT bank_account_id
367: INTO l_bank_account_id
368: FROM fv_ccr_orgs
369: WHERE pay_site_id = p_vendor_site_id;
370:
371: if(l_bank_account_id IS NULL) THEN
372: x_out_status := FND_API.G_FALSE;

Line 502: FROM fv_ccr_orgs fco

498: IF (l_ccr_status = 'A') THEN
499: BEGIN
500: SELECT bank_account_id
501: INTO l_bank_account_id
502: FROM fv_ccr_orgs fco
503: WHERE fco.pay_site_id = p_vendor_site_id;
504:
505: IF (l_bank_account_id IS NOT NULL) THEN
506: RETURN l_bank_account_id;