APPS.PAY_SE_ARCHIVE_CWCA dependencies on HR_SOFT_CODING_KEYFLEX

Line 212: l_soft_coding_keyflex_id hr_soft_coding_keyflex.soft_coding_keyflex_id%TYPE;

208: l_town_or_city VARCHAR2 (100);
209: l_region_1 VARCHAR2 (100);
210: l_region_2 VARCHAR2 (100);
211: l_territory_short_name VARCHAR2 (100);
212: l_soft_coding_keyflex_id hr_soft_coding_keyflex.soft_coding_keyflex_id%TYPE;
213: l_oth_comp NUMBER;
214: bname VARCHAR2 (100);
215: l_month VARCHAR2 (2);
216: l_year VARCHAR2 (4);

Line 401: csr_v_soft_coding_keyflex_id hr_soft_coding_keyflex.soft_coding_keyflex_id%TYPE

397: lr_assignment_info csr_assignment_info%ROWTYPE;
398:
399:
400: CURSOR csr_soft_coded_keyflex_info (
401: csr_v_soft_coding_keyflex_id hr_soft_coding_keyflex.soft_coding_keyflex_id%TYPE
402: )
403: IS
404: SELECT *
405: FROM hr_soft_coding_keyflex

Line 405: FROM hr_soft_coding_keyflex

401: csr_v_soft_coding_keyflex_id hr_soft_coding_keyflex.soft_coding_keyflex_id%TYPE
402: )
403: IS
404: SELECT *
405: FROM hr_soft_coding_keyflex
406: WHERE soft_coding_keyflex_id = csr_v_soft_coding_keyflex_id;
407:
408: lr_soft_coded_keyflex_info csr_soft_coded_keyflex_info%ROWTYPE;
409: