689: l_attribute_value_id psb_attribute_values.attribute_value_id%TYPE;
690: l_attribute_value psb_attribute_values.attribute_value%TYPE;
691: l_create_formula_flag VARCHAR2(1);
692: l_value_table_flag psb_attributes.value_table_flag%TYPE;
693: l_source_option_flag psb_pay_elements.option_flag%TYPE;
694: l_source_salary_flag psb_pay_elements.salary_flag%TYPE;
695: l_source_pay_element_id psb_pay_elements.pay_element_id%TYPE;
696: l_source_pay_element_option_id
697: psb_pay_element_options.pay_element_option_id%TYPE;
690: l_attribute_value psb_attribute_values.attribute_value%TYPE;
691: l_create_formula_flag VARCHAR2(1);
692: l_value_table_flag psb_attributes.value_table_flag%TYPE;
693: l_source_option_flag psb_pay_elements.option_flag%TYPE;
694: l_source_salary_flag psb_pay_elements.salary_flag%TYPE;
695: l_source_pay_element_id psb_pay_elements.pay_element_id%TYPE;
696: l_source_pay_element_option_id
697: psb_pay_element_options.pay_element_option_id%TYPE;
698: l_source_element_value psb_pay_element_rates.element_value%TYPE;
691: l_create_formula_flag VARCHAR2(1);
692: l_value_table_flag psb_attributes.value_table_flag%TYPE;
693: l_source_option_flag psb_pay_elements.option_flag%TYPE;
694: l_source_salary_flag psb_pay_elements.salary_flag%TYPE;
695: l_source_pay_element_id psb_pay_elements.pay_element_id%TYPE;
696: l_source_pay_element_option_id
697: psb_pay_element_options.pay_element_option_id%TYPE;
698: l_source_element_value psb_pay_element_rates.element_value%TYPE;
699: l_target_pay_element_id psb_pay_elements.pay_element_id%TYPE;
695: l_source_pay_element_id psb_pay_elements.pay_element_id%TYPE;
696: l_source_pay_element_option_id
697: psb_pay_element_options.pay_element_option_id%TYPE;
698: l_source_element_value psb_pay_element_rates.element_value%TYPE;
699: l_target_pay_element_id psb_pay_elements.pay_element_id%TYPE;
700: l_target_pay_element_option_id
701: psb_pay_element_options.pay_element_option_id%TYPE;
702: l_target_pay_element_rate_id psb_pay_element_rates.pay_element_rate_id%TYPE;
703:
723: CURSOR l_find_source_element_csr IS
724: SELECT pay_element_id ,
725: option_flag ,
726: salary_flag
727: FROM psb_pay_elements
728: WHERE name = (select name
729: from psb_pay_elements
730: where pay_element_id=l_source_pay_element_id)
731: and data_extract_id = p_target_data_extract_id ;
725: option_flag ,
726: salary_flag
727: FROM psb_pay_elements
728: WHERE name = (select name
729: from psb_pay_elements
730: where pay_element_id=l_source_pay_element_id)
731: and data_extract_id = p_target_data_extract_id ;
732: --
733: CURSOR l_find_element_rate_csr IS
1244:
1245: debug( 'Processing Copy Entity Element:'||
1246: l_para_formula_rec.pay_element_id);
1247:
1248: PSB_PAY_ELEMENTS_PVT.Copy_Pay_Elements
1249: ( p_api_version => 1.0,
1250: p_init_msg_list => null,
1251: p_commit => null,
1252: p_validation_level => null,
1493:
1494: debug( 'Processing Copy Entity Element:'||
1495: l_const_formula_rec.pay_element_id);
1496:
1497: PSB_PAY_ELEMENTS_PVT.Copy_Pay_Elements
1498: ( p_api_version => 1.0,
1499: p_init_msg_list => null,
1500: p_commit => null,
1501: p_validation_level => null,