APPS.PSB_ENTITY_SET_PVT dependencies on PSB_PAY_ELEMENT_OPTIONS

Line 697: psb_pay_element_options.pay_element_option_id%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;
700: l_target_pay_element_option_id
701: psb_pay_element_options.pay_element_option_id%TYPE;

Line 701: psb_pay_element_options.pay_element_option_id%TYPE;

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:
704:
705: CURSOR l_entity_set_csr IS

Line 743: FROM psb_pay_element_options

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
743: FROM psb_pay_element_options
744: WHERE pay_element_id = l_target_pay_element_id
745: and name = (select name
746: from psb_pay_element_options
747: where pay_element_option_id =

Line 746: from psb_pay_element_options

742: SELECT pay_element_option_id
743: FROM psb_pay_element_options
744: WHERE pay_element_id = l_target_pay_element_id
745: and name = (select name
746: from psb_pay_element_options
747: where pay_element_option_id =
748: l_source_pay_element_option_id);
749: --
750: CURSOR l_find_element_option_rate_csr IS