[Home] [Help]
49: --| HZ_CUST_ACCT_SITES_ALL | X | | | | | |
50: --+---------------------------------+---+---+---+---+---+----------------------+
51: --| OKS_INSTANCE_K_DTLS_TEMP | X | X | | | | |
52: --+---------------------------------+---+---+---+---+---+----------------------+
53: --| OKS_K_SALES_CREDITS_V | X | | | | | |
54: --+---------------------------------+---+---+---+---+---+----------------------+
55: --| OKC_K_ACCESSES_V | X | | | | | |
56: --+---------------------------------+---+---+---+---+---+----------------------+
57: --| OKC_CLASSES_B | X | | | | | |
71: --| OKS_K_HEADERS_B | X | X | | | | |
72: --+---------------------------------+---+---+---+---+---+----------------------+
73: --| OKC_K_ACCESSES | | X | | | | |
74: --+---------------------------------+---+---+---+---+---+----------------------+
75: --| OKS_K_SALES_CREDITS | | X | | | | |
76: --+---------------------------------+---+---+---+---+---+----------------------+
77: --| CS_CTR_ASSOCIATIONS | X | | | | | |
78: --+---------------------------------+---+---+---+---+---+----------------------+
79: --| OKS_COVERAGES_PUB | | | | | |X |
1879: sc.ctc_id,
1880: sc.sales_credit_type_id1,
1881: sc.PERCENT,
1882: sc.sales_group_id
1883: FROM oks_k_sales_credits_v sc,
1884: oks_instance_k_dtls_temp temp
1885: WHERE sc.chr_id = temp.contract_id
1886: AND sc.cle_id IS NULL
1887: AND temp.new_contract_id IS NOT NULL;
3156:
3157: IF hdr_id.COUNT > 0
3158: THEN
3159: FORALL i IN 1 .. hdr_id.COUNT
3160: INSERT INTO oks_k_sales_credits
3161: (ID,
3162: PERCENT,
3163: sales_group_id,
3164: chr_id,
3302: sc.ctc_id,
3303: sc.sales_credit_type_id1,
3304: sc.PERCENT,
3305: sc.sales_group_id
3306: FROM oks_k_sales_credits_v sc,
3307: oks_instance_k_dtls_temp temp
3308: WHERE sc.cle_id = temp.topline_id
3309: AND temp.new_serviceline_id IS NOT NULL;
3310:
3695:
3696: CLOSE get_line_salescredits_csr;
3697:
3698: FORALL i IN 1 .. srvline_id.COUNT
3699: INSERT INTO oks_k_sales_credits
3700: (ID,
3701: PERCENT,
3702: sales_group_id,
3703: chr_id,