APPS.OKL_OPEN_INTERFACE_PVT dependencies on FA_ADDITIONS_B

Line 1841: FROM FA_ADDITIONS_B FA,

1837: SELECT 'Y'
1838: FROM OKL_LINES_INTERFACE OLI
1839: WHERE oli.contract_number_old = p_contract_number
1840: AND EXISTS ( SELECT fa.asset_id
1841: FROM FA_ADDITIONS_B FA,
1842: OKL_ASSET_RETURNS_B OAR,
1843: OKC_K_ITEMS CIM_FA,
1844: OKC_K_LINES_B CLEB_FA,
1845: OKC_K_LINES_B CLEB_TL,

Line 1887: FROM FA_ADDITIONS_B FA,

1883: SELECT 'Y'
1884: FROM OKL_LINES_INTERFACE OLI
1885: WHERE oli.contract_number_old = p_contract_number
1886: AND NOT EXISTS (SELECT fa.asset_id
1887: FROM FA_ADDITIONS_B FA,
1888: OKL_ASSET_RETURNS_B OAR,
1889: OKC_K_ITEMS CIM_FA,
1890: OKC_K_LINES_B CLEB_FA,
1891: OKC_K_LINES_B CLEB_TL,

Line 28323: FROM FA_ADDITIONS_B

28319: AND id = p_chr_id;
28320:
28321: CURSOR c_asset (p_asset_number OKL_LA_RELEASE_ASSETS_UV.ASSET_NUMBER%TYPE) IS
28322: SELECT asset_id
28323: FROM FA_ADDITIONS_B
28324: WHERE asset_number = p_asset_number;
28325:
28326: l_master_lease_aggr_id NUMBER;
28327: l_credit_line_id NUMBER;