APPS.PAY_SE_WORK_TIME_CERTIFICATE dependencies on HR_SOFT_CODING_KEYFLEX

Line 291: l_soft_coding_keyflex_id hr_soft_coding_keyflex.soft_coding_keyflex_id%TYPE;

287: l_town_or_city VARCHAR2 (100);
288: l_region_1 VARCHAR2 (100);
289: l_region_2 VARCHAR2 (100);
290: l_territory_short_name VARCHAR2 (100);
291: l_soft_coding_keyflex_id hr_soft_coding_keyflex.soft_coding_keyflex_id%TYPE;
292: l_one_year_date DATE;
293: l_temp_start_date DATE;
294: l_temp_end_date DATE;
295: l_temp_date DATE;

Line 543: csr_v_soft_coding_keyflex_id hr_soft_coding_keyflex.soft_coding_keyflex_id%TYPE

539: AND information_type = 'SE_WTC_TIME_WORKED_INFO'
540: AND aei_information1 = csr_v_year;
541:
542: CURSOR csr_soft_coded_keyflex_info (
543: csr_v_soft_coding_keyflex_id hr_soft_coding_keyflex.soft_coding_keyflex_id%TYPE
544: )
545: IS
546: SELECT *
547: FROM hr_soft_coding_keyflex

Line 547: FROM hr_soft_coding_keyflex

543: csr_v_soft_coding_keyflex_id hr_soft_coding_keyflex.soft_coding_keyflex_id%TYPE
544: )
545: IS
546: SELECT *
547: FROM hr_soft_coding_keyflex
548: WHERE soft_coding_keyflex_id = csr_v_soft_coding_keyflex_id;
549:
550: lr_soft_coded_keyflex_info csr_soft_coded_keyflex_info%ROWTYPE;
551: --****************************************************************************************