40: -- means used to read record from both base and history tables
41: l_old_history_yn VARCHAR2(3);
42:
43: -- /striping/
44: p_rule_code OKC_RULE_DEFS_B.rule_code%TYPE;
45: p_appl_id OKC_RULE_DEFS_B.application_id%TYPE;
46: p_dff_name OKC_RULE_DEFS_B.descriptive_flexfield_name%TYPE;
47:
48: --/rules migration/
41: l_old_history_yn VARCHAR2(3);
42:
43: -- /striping/
44: p_rule_code OKC_RULE_DEFS_B.rule_code%TYPE;
45: p_appl_id OKC_RULE_DEFS_B.application_id%TYPE;
46: p_dff_name OKC_RULE_DEFS_B.descriptive_flexfield_name%TYPE;
47:
48: --/rules migration/
49: g_application_id number;
42:
43: -- /striping/
44: p_rule_code OKC_RULE_DEFS_B.rule_code%TYPE;
45: p_appl_id OKC_RULE_DEFS_B.application_id%TYPE;
46: p_dff_name OKC_RULE_DEFS_B.descriptive_flexfield_name%TYPE;
47:
48: --/rules migration/
49: g_application_id number;
50: ----------------------------------------------------------------------------