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 541: csr_v_soft_coding_keyflex_id hr_soft_coding_keyflex.soft_coding_keyflex_id%TYPE

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

Line 545: FROM hr_soft_coding_keyflex

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