eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_DE_SOC_INS_CLE_API dependencies on HR_DE_SOC_INS_CONTR_LVLS_F

Line 78: l_soc_ins_contr_lvls_id hr_de_soc_ins_contr_lvls_f.soc_ins_contr_lvls_id%TYPE;

74: SELECT business_group_id
75: FROM hr_organization_units hou
76: WHERE hou.organization_id = p_organization_id;
77: --
78: l_soc_ins_contr_lvls_id hr_de_soc_ins_contr_lvls_f.soc_ins_contr_lvls_id%TYPE;
79: l_effective_start_date hr_de_soc_ins_contr_lvls_f.effective_start_date%TYPE;
80: l_effective_end_date hr_de_soc_ins_contr_lvls_f.effective_end_date%TYPE;
81: l_effective_date DATE;
82: l_proc VARCHAR2(72) := g_package||'create_soc_ins_contributions';

Line 79: l_effective_start_date hr_de_soc_ins_contr_lvls_f.effective_start_date%TYPE;

75: FROM hr_organization_units hou
76: WHERE hou.organization_id = p_organization_id;
77: --
78: l_soc_ins_contr_lvls_id hr_de_soc_ins_contr_lvls_f.soc_ins_contr_lvls_id%TYPE;
79: l_effective_start_date hr_de_soc_ins_contr_lvls_f.effective_start_date%TYPE;
80: l_effective_end_date hr_de_soc_ins_contr_lvls_f.effective_end_date%TYPE;
81: l_effective_date DATE;
82: l_proc VARCHAR2(72) := g_package||'create_soc_ins_contributions';
83: l_object_version_number hr_de_soc_ins_contr_lvls_f.object_version_number%TYPE;

Line 80: l_effective_end_date hr_de_soc_ins_contr_lvls_f.effective_end_date%TYPE;

76: WHERE hou.organization_id = p_organization_id;
77: --
78: l_soc_ins_contr_lvls_id hr_de_soc_ins_contr_lvls_f.soc_ins_contr_lvls_id%TYPE;
79: l_effective_start_date hr_de_soc_ins_contr_lvls_f.effective_start_date%TYPE;
80: l_effective_end_date hr_de_soc_ins_contr_lvls_f.effective_end_date%TYPE;
81: l_effective_date DATE;
82: l_proc VARCHAR2(72) := g_package||'create_soc_ins_contributions';
83: l_object_version_number hr_de_soc_ins_contr_lvls_f.object_version_number%TYPE;
84: l_business_group_id NUMBER;

Line 83: l_object_version_number hr_de_soc_ins_contr_lvls_f.object_version_number%TYPE;

79: l_effective_start_date hr_de_soc_ins_contr_lvls_f.effective_start_date%TYPE;
80: l_effective_end_date hr_de_soc_ins_contr_lvls_f.effective_end_date%TYPE;
81: l_effective_date DATE;
82: l_proc VARCHAR2(72) := g_package||'create_soc_ins_contributions';
83: l_object_version_number hr_de_soc_ins_contr_lvls_f.object_version_number%TYPE;
84: l_business_group_id NUMBER;
85:
86: l_temp_effective_start_date date;
87: l_temp_effective_end_date date;

Line 460: l_object_version_number hr_de_soc_ins_contr_lvls_f.object_version_number%TYPE;

456: -- Declare cursors and local variables
457:
458: --
459: l_proc VARCHAR2(72) := g_package||'update_soc_ins_contributions';
460: l_object_version_number hr_de_soc_ins_contr_lvls_f.object_version_number%TYPE;
461: l_effective_start_date hr_de_soc_ins_contr_lvls_f.effective_start_date%TYPE;
462: l_effective_end_date hr_de_soc_ins_contr_lvls_f.effective_end_date%TYPE;
463: l_effective_date DATE;
464:

Line 461: l_effective_start_date hr_de_soc_ins_contr_lvls_f.effective_start_date%TYPE;

457:
458: --
459: l_proc VARCHAR2(72) := g_package||'update_soc_ins_contributions';
460: l_object_version_number hr_de_soc_ins_contr_lvls_f.object_version_number%TYPE;
461: l_effective_start_date hr_de_soc_ins_contr_lvls_f.effective_start_date%TYPE;
462: l_effective_end_date hr_de_soc_ins_contr_lvls_f.effective_end_date%TYPE;
463: l_effective_date DATE;
464:
465: l_temp_effective_start_date date;

Line 462: l_effective_end_date hr_de_soc_ins_contr_lvls_f.effective_end_date%TYPE;

458: --
459: l_proc VARCHAR2(72) := g_package||'update_soc_ins_contributions';
460: l_object_version_number hr_de_soc_ins_contr_lvls_f.object_version_number%TYPE;
461: l_effective_start_date hr_de_soc_ins_contr_lvls_f.effective_start_date%TYPE;
462: l_effective_end_date hr_de_soc_ins_contr_lvls_f.effective_end_date%TYPE;
463: l_effective_date DATE;
464:
465: l_temp_effective_start_date date;
466: l_temp_effective_end_date date;

Line 759: l_object_version_number hr_de_soc_ins_contr_lvls_f.object_version_number%TYPE;

755: --
756: -- Declare cursors and local variables
757: --
758: l_proc VARCHAR2(72) := g_package||'delete_soc_ins_contributions';
759: l_object_version_number hr_de_soc_ins_contr_lvls_f.object_version_number%TYPE;
760: l_effective_start_date hr_de_soc_ins_contr_lvls_f.effective_start_date%TYPE;
761: l_effective_END_date hr_de_soc_ins_contr_lvls_f.effective_END_date%TYPE;
762:
763: l_temp_ovn number;

Line 760: l_effective_start_date hr_de_soc_ins_contr_lvls_f.effective_start_date%TYPE;

756: -- Declare cursors and local variables
757: --
758: l_proc VARCHAR2(72) := g_package||'delete_soc_ins_contributions';
759: l_object_version_number hr_de_soc_ins_contr_lvls_f.object_version_number%TYPE;
760: l_effective_start_date hr_de_soc_ins_contr_lvls_f.effective_start_date%TYPE;
761: l_effective_END_date hr_de_soc_ins_contr_lvls_f.effective_END_date%TYPE;
762:
763: l_temp_ovn number;
764: --

Line 761: l_effective_END_date hr_de_soc_ins_contr_lvls_f.effective_END_date%TYPE;

757: --
758: l_proc VARCHAR2(72) := g_package||'delete_soc_ins_contributions';
759: l_object_version_number hr_de_soc_ins_contr_lvls_f.object_version_number%TYPE;
760: l_effective_start_date hr_de_soc_ins_contr_lvls_f.effective_start_date%TYPE;
761: l_effective_END_date hr_de_soc_ins_contr_lvls_f.effective_END_date%TYPE;
762:
763: l_temp_ovn number;
764: --
765: BEGIN