APPS.HR_ASSIGNMENT_ISETUP_SWI dependencies on HR_SOFT_CODING_KEYFLEX

Line 1726: l_scl_keyflex_id hr_soft_coding_keyflex.soft_coding_keyflex_id%type;

1722: ,p_bg_id in number
1723: ,p_scl_flex_struc_code in varchar2
1724: ,p_scl_concat_segments in varchar2) RETURN NUMBER AS
1725: --
1726: l_scl_keyflex_id hr_soft_coding_keyflex.soft_coding_keyflex_id%type;
1727: l_id_flex_num fnd_id_flex_structures.id_flex_num%type;
1728: l_tax_unit_id hr_all_organization_units.organization_id%type;
1729: --
1730: --

Line 1748: FROM hr_soft_coding_keyflex

1744: --
1745: begin
1746: SELECT soft_coding_keyflex_id
1747: INTO l_scl_keyflex_id
1748: FROM hr_soft_coding_keyflex
1749: WHERE segment1 = to_char(l_tax_unit_id)
1750: and concatenated_segments = p_scl_concat_segments;
1751:
1752: exception

Line 1754: SELECT hr_soft_coding_keyflex_s.nextval

1750: and concatenated_segments = p_scl_concat_segments;
1751:
1752: exception
1753: when no_data_found then
1754: SELECT hr_soft_coding_keyflex_s.nextval
1755: INTO l_scl_keyflex_id
1756: FROM dual;
1757: --
1758: INSERT INTO hr_soft_coding_keyflex

Line 1758: INSERT INTO hr_soft_coding_keyflex

1754: SELECT hr_soft_coding_keyflex_s.nextval
1755: INTO l_scl_keyflex_id
1756: FROM dual;
1757: --
1758: INSERT INTO hr_soft_coding_keyflex
1759: (soft_coding_keyflex_id,
1760: concatenated_segments,
1761: id_flex_num,
1762: summary_flag,