DBA Data[Home] [Help]

APPS.OKL_AM_AMORTIZE_PVT dependencies on OKC_K_LINES_B

Line 3550: okc_k_lines_b cleb_fa,

3546: FROM fa_books fb,
3547: fa_additions_b fab,
3548: fa_book_controls fbc,
3549: okc_k_items cim_fa,
3550: okc_k_lines_b cleb_fa,
3551: okc_line_styles_b lseb_fa,
3552: okc_k_lines_tl clet_fin,
3553: okc_k_lines_b cleb_fin,
3554: okc_line_styles_b lseb_fin

Line 3553: okc_k_lines_b cleb_fin,

3549: okc_k_items cim_fa,
3550: okc_k_lines_b cleb_fa,
3551: okc_line_styles_b lseb_fa,
3552: okc_k_lines_tl clet_fin,
3553: okc_k_lines_b cleb_fin,
3554: okc_line_styles_b lseb_fin
3555: WHERE fb.asset_id = fab.asset_id
3556: AND fb.transaction_header_id_out IS NULL
3557: AND fb.book_type_code = fbc.book_type_code

Line 3599: okc_k_lines_b cleb_fa,

3595: FROM fa_books fb,
3596: fa_additions_b fab,
3597: fa_book_controls fbc,
3598: okc_k_items cim_fa,
3599: okc_k_lines_b cleb_fa,
3600: okc_line_styles_b lseb_fa,
3601: okc_k_lines_tl clet_fin,
3602: okc_k_lines_b cleb_fin,
3603: okc_line_styles_b lseb_fin

Line 3602: okc_k_lines_b cleb_fin,

3598: okc_k_items cim_fa,
3599: okc_k_lines_b cleb_fa,
3600: okc_line_styles_b lseb_fa,
3601: okc_k_lines_tl clet_fin,
3602: okc_k_lines_b cleb_fin,
3603: okc_line_styles_b lseb_fin
3604: WHERE fb.asset_id = fab.asset_id
3605: AND fb.transaction_header_id_out is null
3606: AND fb.book_type_code = fbc.book_type_code

Line 3649: okc_k_lines_b cleb_fa,

3645: FROM fa_books fb,
3646: fa_additions_b fab,
3647: fa_book_controls fbc,
3648: okc_k_items cim_fa,
3649: okc_k_lines_b cleb_fa,
3650: okc_line_styles_b lseb_fa,
3651: okc_k_lines_tl clet_fin,
3652: okc_k_lines_b cleb_fin,
3653: okc_line_styles_b lseb_fin

Line 3652: okc_k_lines_b cleb_fin,

3648: okc_k_items cim_fa,
3649: okc_k_lines_b cleb_fa,
3650: okc_line_styles_b lseb_fa,
3651: okc_k_lines_tl clet_fin,
3652: okc_k_lines_b cleb_fin,
3653: okc_line_styles_b lseb_fin
3654: WHERE fb.asset_id = fab.asset_id
3655: AND fb.transaction_header_id_out is null
3656: AND fb.book_type_code = fbc.book_type_code

Line 3699: okc_k_lines_b cleb_fa,

3695: FROM fa_books fb,
3696: fa_additions_b fab,
3697: fa_book_controls fbc,
3698: okc_k_items cim_fa,
3699: okc_k_lines_b cleb_fa,
3700: okc_line_styles_b lseb_fa,
3701: okc_k_lines_tl clet_fin,
3702: okc_k_lines_b cleb_fin,
3703: okc_line_styles_b lseb_fin

Line 3702: okc_k_lines_b cleb_fin,

3698: okc_k_items cim_fa,
3699: okc_k_lines_b cleb_fa,
3700: okc_line_styles_b lseb_fa,
3701: okc_k_lines_tl clet_fin,
3702: okc_k_lines_b cleb_fin,
3703: okc_line_styles_b lseb_fin
3704: WHERE fb.asset_id = fab.asset_id
3705: AND fb.transaction_header_id_out is null
3706: AND fb.book_type_code = fbc.book_type_code

Line 3730: FROM okl_k_headers a, okc_k_lines_b b

3726: -- SECHAWLA 06-MAY-04 3578894 : Added this cursor
3727: -- get the deal type for the asset
3728: CURSOR l_oklhdr_csr(cp_kle_id IN NUMBER) IS
3729: SELECT a.id, a.deal_type, a.legal_entity_id
3730: FROM okl_k_headers a, okc_k_lines_b b
3731: WHERE a.id = b.dnz_chr_id
3732: AND b.id = cp_kle_id;
3733:
3734: -- SECHAWLA 06-MAY-04 3578894 : Added this cursor to validate the kle id

Line 4605: FROM okc_k_lines_b a , okc_line_styles_b b

4601: -- SECHAWLA 19-NOV-2004 4022466 :added
4602: -- get the active financial asset lines for the contract
4603: CURSOR l_okcklines_csr(cp_khr_id IN NUMBER, cp_sts_code IN VARCHAR2) IS
4604: SELECT a.id
4605: FROM okc_k_lines_b a , okc_line_styles_b b
4606: WHERE a.chr_id = cp_khr_id
4607: AND a.lse_id = b.id
4608: AND b.lty_code = 'FREE_FORM1'
4609: AND a.sts_code = cp_sts_code;