APPS.FV_CCR_GRP dependencies on FV_CCR_VENDORS

Line 43: FROM fv_ccr_vendors

39: x_out_status := FND_API.G_FALSE;
40: IF(p_object_type = 'S') THEN
41: SELECT ccr_id
42: INTO x_ccr_id
43: FROM fv_ccr_vendors
44: WHERE nvl(vendor_id,-99) = p_object_id
45: AND plus_four IS NULL;
46: ELSIF(p_object_type = 'B') THEN
47: SELECT ccr_id

Line 49: FROM fv_ccr_vendors

45: AND plus_four IS NULL;
46: ELSIF(p_object_type = 'B') THEN
47: SELECT ccr_id
48: INTO x_ccr_id
49: FROM fv_ccr_vendors
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

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: