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

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

Line 408: FROM hr_soft_coding_keyflex

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