APPS.PSB_COPY_DATA_EXTRACT_PVT dependencies on PSB_PAY_ELEMENT_OPTIONS

Line 761: l_src_pay_option_name psb_pay_element_options.name%type; -- bug 5149134

757: l_dest_pay_element_id number;
758: l_dest_pay_option_id number;
759: l_dest_attribute_value_id number;
760: l_src_pay_element_name varchar2(30);
761: l_src_pay_option_name psb_pay_element_options.name%type; -- bug 5149134
762: l_src_grade_step number;
763: --UTF8 changes for Bug No : 2615261
764: l_src_attribute_value psb_attribute_values.attribute_value%TYPE;
765: l_src_entity_id number;

Line 845: FROM psb_pay_element_options

841: -- Bug 4179764 .In the following cursor added
842: -- the grade_step in the select clause
843: CURSOR C_Pay_Option IS
844: SELECT name, nvl(grade_step, -1) grade_step
845: FROM psb_pay_element_options
846: WHERE pay_element_id = l_src_pay_element_id
847: AND pay_element_option_id = l_src_pay_option_id;
848:
849: CURSOR C_Pay_Option_Dest IS

Line 851: FROM psb_pay_element_options peo, psb_pay_elements pe

847: AND pay_element_option_id = l_src_pay_option_id;
848:
849: CURSOR C_Pay_Option_Dest IS
850: SELECT pay_element_option_id
851: FROM psb_pay_element_options peo, psb_pay_elements pe
852: WHERE peo.pay_element_id = pe.pay_element_id
853: AND peo.pay_element_id = l_dest_pay_element_id
854: AND peo.name = l_src_pay_option_name
855: AND DECODE(pe.hr_element_type_id, null, -1, DECODE(pe.salary_type,