APPS.PSB_ENTITY_SET_PVT dependencies on PSB_PAY_ELEMENT_RATES

Line 698: l_source_element_value psb_pay_element_rates.element_value%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;
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;

Line 702: l_target_pay_element_rate_id psb_pay_element_rates.pay_element_rate_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:
704:
705: CURSOR l_entity_set_csr IS
706: SELECT *

Line 735: FROM psb_pay_element_rates

731: and data_extract_id = p_target_data_extract_id ;
732: --
733: CURSOR l_find_element_rate_csr IS
734: SELECT pay_element_rate_id
735: FROM psb_pay_element_rates
736: WHERE pay_element_id = l_target_pay_element_id
737: and element_value = (select element_value
738: from psb_pay_element_rates
739: where pay_element_id=l_source_pay_element_id);

Line 738: from psb_pay_element_rates

734: SELECT pay_element_rate_id
735: FROM psb_pay_element_rates
736: WHERE pay_element_id = l_target_pay_element_id
737: and element_value = (select element_value
738: from psb_pay_element_rates
739: where pay_element_id=l_source_pay_element_id);
740: --
741: CURSOR l_find_element_option_csr IS
742: SELECT pay_element_option_id

Line 752: FROM psb_pay_element_rates

748: l_source_pay_element_option_id);
749: --
750: CURSOR l_find_element_option_rate_csr IS
751: SELECT pay_element_rate_id
752: FROM psb_pay_element_rates
753: WHERE pay_element_id = l_target_pay_element_id
754: and pay_element_option_id = l_target_pay_element_option_id
755: and element_value = (select element_value
756: from psb_pay_element_rates

Line 756: from psb_pay_element_rates

752: FROM psb_pay_element_rates
753: WHERE pay_element_id = l_target_pay_element_id
754: and pay_element_option_id = l_target_pay_element_option_id
755: and element_value = (select element_value
756: from psb_pay_element_rates
757: where pay_element_id =l_source_pay_element_id
758: and pay_element_option_id = l_source_pay_element_option_id);
759: --
760: CURSOR l_source_data_extract_csr IS