DBA Data[Home] [Help]

APPS.OKL_AM_AMORTIZE_PVT dependencies on OKC_LINE_STYLES_B

Line 3551: okc_line_styles_b lseb_fa,

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
3555: WHERE fb.asset_id = fab.asset_id

Line 3554: okc_line_styles_b lseb_fin

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
3558: AND nvl(fbc.date_ineffective,cp_sysdate+1) > cp_sysdate

Line 3600: okc_line_styles_b lseb_fa,

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
3604: WHERE fb.asset_id = fab.asset_id

Line 3603: okc_line_styles_b lseb_fin

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
3607: AND nvl(fbc.date_ineffective,cp_sysdate+1) > cp_sysdate

Line 3650: okc_line_styles_b lseb_fa,

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
3654: WHERE fb.asset_id = fab.asset_id

Line 3653: okc_line_styles_b lseb_fin

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
3657: AND nvl(fbc.date_ineffective,cp_sysdate+1) > cp_sysdate

Line 3700: okc_line_styles_b lseb_fa,

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
3704: WHERE fb.asset_id = fab.asset_id

Line 3703: okc_line_styles_b lseb_fin

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
3707: AND nvl(fbc.date_ineffective,cp_sysdate+1) > cp_sysdate

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;