[Home] [Help]
479:
480: /* *****************************************************************************
481: Procedure:populate_inc_table_init
482: Description:Procedure to populate incremental table for Initial load.
483: Check okc_k_vers_numbers table for new/modified contracts
484: ************************************************************************** */
485:
486: PROCEDURE populate_inc_table_init IS
487: l_start_date DATE ;
629: 'NSR', decode(h.approval_type, 'Y', 'NSR', 'N', 'NSR', 'NSR')
630: ) subsequent_renewal_type_code /* Added this colunm as a part of ER#5760744 */
631: ,h.term_cancel_source hdr_term_cancel_source /* Added for ER 6684955 */
632: FROM okc_k_headers_all_b h
633: , okc_k_vers_numbers v
634: WHERE 1=1
635: AND
636: (
637: (
1048:
1049: /* *****************************************************************************
1050: Procedure:populate_inc_table_inc
1051: Descritpion:Procedure to populate incremental table for incremental load.
1052: Check okc_k_vers_numbers table for new/modified contracts
1053: ************************************************************************** */
1054:
1055: PROCEDURE populate_inc_table_inc IS
1056: l_start_date DATE ;
1192: inv_organization_id,
1193: subsequent_renewal_type_code,
1194: hdr_term_cancel_source
1195: )
1196: SELECT /*+ cardinality(v,1) index(V OKC_K_VERS_NUMBERS_N1) */ h.id
1197: , h.currency_code
1198: , h.date_approved
1199: , h.creation_date
1200: , h.conversion_rate_date
1224: 'NSR', decode(h.approval_type, 'Y', 'NSR', 'N', 'NSR', 'NSR')
1225: ) subsequent_renewal_type_code /* for ER#5760744 */
1226: , h.term_cancel_source hdr_term_cancel_source /* for ER 6684955 */
1227: FROM okc_k_headers_all_b h
1228: , okc_k_vers_numbers v
1229: WHERE 1=1
1230: AND v.last_update_date >= l_start_date
1231: AND v.last_update_date+0 <= l_end_date
1232: AND h.id = v.chr_id