DBA Data[Home] [Help]

APPS.OKS_BILLING_PUB dependencies on OKS_BSL_PR

Line 677: oks_bsl_pr bsl,

673: rline.locked_price_list_line_id,
674: rline.dnz_chr_id
675: FROM
676: oks_k_lines_b rline,
677: oks_bsl_pr bsl,
678: oks_bsd_pr bsd
679: WHERE bsl.bcl_id = p_bcl_id
680: AND bsl.id = bsd.bsl_id
681: AND rline.cle_id = bsl.cle_id

Line 1505: Delete from OKS_BSL_PR

1501: Delete from OKS_BSD_PR
1502: where bsl_id in
1503: (select bsl_id from oks_usg_qp_call_tbl where line_id=Nvl(p_line_id,LINE_ID) and dnz_chr_id=p_dnz_chr_id);
1504:
1505: Delete from OKS_BSL_PR
1506: where id in
1507: (select bsl_id from oks_usg_qp_call_tbl where line_id=Nvl(p_line_id,LINE_ID) and dnz_chr_id=p_dnz_chr_id);
1508:
1509: Delete from OKS_BCL_PR

Line 3698: oks_bsl_pr bsl,

3694: rline.locked_price_list_line_id,
3695: rline.dnz_chr_id
3696: FROM
3697: oks_k_lines_b rline,
3698: oks_bsl_pr bsl,
3699: oks_bsd_pr bsd
3700: WHERE bsl.bcl_id = p_bcl_id
3701: AND bsl.id = bsd.bsl_id
3702: AND rline.cle_id = bsl.cle_id