APPS.PAY_PAYROLLS_F_PKG dependencies on HR_SOFT_CODING_KEYFLEX_S

Line 95: from hr_soft_coding_keyflex s

91: -- Need to check for a partial value.
92: begin
93: select s.soft_coding_keyflex_id
94: into v_soft_coding_keyflex_id
95: from hr_soft_coding_keyflex s
96: where s.id_flex_num = p_scl_structure
97: and s.enabled_flag = 'Y'
98: and (s.segment1 = p_segment1
99: or (s.segment1 is null

Line 199: select hr_soft_coding_keyflex_s.nextval

195: if (v_soft_coding_keyflex_id = -1) then
196: --
197: -- select the next sequence value for the soft coding keyflex.
198: begin
199: select hr_soft_coding_keyflex_s.nextval
200: into v_soft_coding_keyflex_id
201: from sys.dual;
202: exception
203: when NO_DATA_FOUND then