DBA Data[Home] [Help]

APPS.PSB_ENTITY_SET_PVT dependencies on PSB_PAY_ELEMENTS

Line 693: l_source_option_flag psb_pay_elements.option_flag%TYPE;

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;

Line 694: l_source_salary_flag psb_pay_elements.salary_flag%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;

Line 695: l_source_pay_element_id psb_pay_elements.pay_element_id%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;

Line 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:

Line 727: FROM psb_pay_elements

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 ;

Line 729: from psb_pay_elements

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

Line 1248: PSB_PAY_ELEMENTS_PVT.Copy_Pay_Elements

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,

Line 1497: PSB_PAY_ELEMENTS_PVT.Copy_Pay_Elements

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,