DBA Data[Home] [Help]

APPS.OKL_ASSET_SUBSIDY_PVT dependencies on RA_SALESREP_TERRITORIES

Line 1295: from RA_SALESREP_TERRITORIES rst,

1291: -- Bug#3508166
1292: cursor l_terr_csr (p_subsidy_id in number,
1293: p_asset_cle_id in number) is
1294: select 'Y'
1295: from RA_SALESREP_TERRITORIES rst,
1296: OKC_CONTACTS cro,
1297: OKC_K_PARTY_ROLES_B cplb,
1298: OKC_K_LINES_B cleb,
1299: okl_subsidy_criteria suc

Line 2392: from RA_SALESREP_TERRITORIES rst,

2388: */
2389: cursor l_terr_csr (p_subsidy_id in number,
2390: p_sales_rep_id in number) is
2391: select 'Y'
2392: from RA_SALESREP_TERRITORIES rst,
2393: okl_subsidy_criteria suc
2394: Where rst.salesrep_id = p_sales_rep_id
2395: And SUC.SUBSIDY_ID = p_subsidy_id
2396: And SUC.SALES_TERRITORY_ID = rst.territory_id;