APPS.OKL_OPEN_INTERFACE_PVT dependencies on FA_ADDITIONS_B

Line 1846: FROM FA_ADDITIONS_B FA,

1842: SELECT 'Y'
1843: FROM OKL_LINES_INTERFACE OLI
1844: WHERE oli.contract_number_old = p_contract_number
1845: AND EXISTS ( SELECT fa.asset_id
1846: FROM FA_ADDITIONS_B FA,
1847: OKL_ASSET_RETURNS_B OAR,
1848: OKC_K_ITEMS CIM_FA,
1849: OKC_K_LINES_B CLEB_FA,
1850: OKC_K_LINES_B CLEB_TL,

Line 1893: FROM FA_ADDITIONS_B FA,

1889: SELECT 'Y'
1890: FROM OKL_LINES_INTERFACE OLI
1891: WHERE oli.contract_number_old = p_contract_number
1892: AND NOT EXISTS (SELECT fa.asset_id
1893: FROM FA_ADDITIONS_B FA,
1894: OKL_ASSET_RETURNS_B OAR,
1895: OKC_K_ITEMS CIM_FA,
1896: OKC_K_LINES_B CLEB_FA,
1897: OKC_K_LINES_B CLEB_TL,

Line 28620: FROM FA_ADDITIONS_B

28616: AND id = p_chr_id;
28617:
28618: CURSOR c_asset (p_asset_number OKL_LA_RELEASE_ASSETS_UV.ASSET_NUMBER%TYPE) IS
28619: SELECT asset_id
28620: FROM FA_ADDITIONS_B
28621: WHERE asset_number = p_asset_number;
28622:
28623: l_master_lease_aggr_id NUMBER;
28624: l_credit_line_id NUMBER;