APPS.CSP_EXCESS_PARTS_PVT dependencies on JTF_TERRITORY_PUB

Line 2475: l_sr_rec JTF_TERRITORY_PUB.JTF_Serv_Req_rec_type;

2471: and tall.start_date_active <= sysdate
2472: and nvl(tall.end_date_active, sysdate+1) > sysdate
2473: order by tmt.absolute_rank desc;
2474:
2475: l_sr_rec JTF_TERRITORY_PUB.JTF_Serv_Req_rec_type;
2476: l_source_terr_id number;
2477:
2478: BEGIN
2479:

Line 2774: l_sr_rec JTF_TERRITORY_PUB.JTF_Serv_Req_rec_type;

2770: and cpp.organization_id (+) = crrr.dest_org_id
2771: and cpp.secondary_inventory (+) = crrr.dest_subinv
2772: and crrr.dest_subinv is not null;
2773:
2774: l_sr_rec JTF_TERRITORY_PUB.JTF_Serv_Req_rec_type;
2775: x_return_rule_id number := null;
2776:
2777: begin
2778: x_return_status := FND_API.G_RET_STS_SUCCESS;