744: ) IS
745:
746: l_column_name VARCHAR2 (25) := NULL;
747: sql_statement VARCHAR2(2000);
748: l_code_comb_id PER_ALL_ASSIGNMENTS_F.default_code_comb_id%TYPE;
749: l_cursor INTEGER;
750: l_statement VARCHAR2(10000);
751: l_rows INTEGER;
752: l_count INTEGER;
749: l_cursor INTEGER;
750: l_statement VARCHAR2(10000);
751: l_rows INTEGER;
752: l_count INTEGER;
753: x_code_comb_id PER_ALL_ASSIGNMENTS_F.default_code_comb_id%TYPE;
754:
755:
756: CURSOR get_default_code_comb_id (p_employee_id IN NUMBER, p_as_of_date IN DATE) IS
757: SELECT
758: A.DEFAULT_CODE_COMB_ID,
759: P.FULL_NAME
760: FROM
761: PER_PEOPLE_F P,
762: PER_ALL_ASSIGNMENTS_F A,
763: PER_PERIODS_OF_SERVICE B
764: WHERE
765: A.PERSON_ID = P.PERSON_ID
766: AND A.person_id = p_employee_id