[Home] [Help]
485: (select eei_information1 from pay_element_type_extra_info petei
486: where petei.information_type='NO_ELEMENT_CODES'
487: and element_type_id = p_ele_type_id
488: and eei_information2 is null
489: and rownum=1)) ele_code from dual;
490:
491:
492: rec_hdr_info csr_get_hdr_info%ROWTYPE;
493: rec_ele_code csr_ele_code%ROWTYPE;
634: /*Check for Change of Assignment ID to Create New Assignment Action ID
635: and for Archiving the data */
636: Hr_utility.trace('#- get the next seq val');
637: BEGIN
638: SELECT pay_assignment_actions_s.NEXTVAL INTO l_actid FROM dual;
639: EXCEPTION
640: WHEN OTHERS THEN
641: NULL ;
642: END ;
733: ,p_action_information10 => csr_rec.ele_cost_seg -- Element Costing Flexfield Segments
734: ,p_action_information11 => csr_rec.cost_flex_id -- Costing Flexfield ID
735: ,p_action_information12 => csr_rec.debit_credit -- Debit or Credit Flag
736: ,p_action_information13 => l_ele_code -- Element Code
737: ,p_action_information14 => fnd_number.number_to_canonical(csr_rec.costed_value) -- Individual Costing Value
738: ,p_action_information15 => csr_rec.cost_or_bal -- Cost or Balance Flag
739: ,p_action_information16 => csr_rec.effective_date -- Costing Effective Date
740: ,p_action_information17 => csr_rec.emp_name -- Employee Name
741: );
852: (select eei_information1 from pay_element_type_extra_info petei
853: where petei.information_type='NO_ELEMENT_CODES'
854: and element_type_id = p_ele_type_id
855: and eei_information2 is null
856: and rownum=1)) ele_code from dual;
857:
858: -- Variable Declarations
859:
860: l_ele_type_id NUMBER;