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.BEN_DM_UPLOAD_DK dependencies on PER_ABS_ATTENDANCE_REASONS

Line 2791: -- DK Resolve For Table PER_ABS_ATTENDANCE_REASONS

2787: end loop;
2788: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;
2789: end;
2790: --
2791: -- DK Resolve For Table PER_ABS_ATTENDANCE_REASONS
2792: --
2793: procedure get_dk_frm_aar is
2794: --
2795: -- cursor to Fetch the DK for PER_ABS_ATTENDANCE_REASONS.ABS_ATTENDANCE_REASON_ID

Line 2795: -- cursor to Fetch the DK for PER_ABS_ATTENDANCE_REASONS.ABS_ATTENDANCE_REASON_ID

2791: -- DK Resolve For Table PER_ABS_ATTENDANCE_REASONS
2792: --
2793: procedure get_dk_frm_aar is
2794: --
2795: -- cursor to Fetch the DK for PER_ABS_ATTENDANCE_REASONS.ABS_ATTENDANCE_REASON_ID
2796: --
2797: cursor csr_get_dk_aar (c_source_key varchar2,
2798: c_business_group_id number,
2799: c_target_id1 number) is

Line 2801: from per_abs_attendance_reasons

2797: cursor csr_get_dk_aar (c_source_key varchar2,
2798: c_business_group_id number,
2799: c_target_id1 number) is
2800: select abs_attendance_reason_id
2801: from per_abs_attendance_reasons
2802: where name = c_source_key
2803: and absence_attendance_type_id = c_target_id1
2804: and business_group_id = c_business_group_id;
2805:

Line 2809: where table_name = 'PER_ABS_ATTENDANCE_REASONS'

2805:
2806: cursor csr_get_all_aar is
2807: select *
2808: from ben_dm_resolve_mappings
2809: where table_name = 'PER_ABS_ATTENDANCE_REASONS'
2810: and target_id is null;
2811:
2812: -- Declare local variables
2813: l_proc varchar2(72) := g_package || 'get_dk_frm_aar';

Line 2823: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table PER_ABS_ATTENDANCE_REASONS

2819: --
2820: begin
2821:
2822: --
2823: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table PER_ABS_ATTENDANCE_REASONS
2824: --
2825: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;
2826: for x in csr_get_all_aar loop
2827: l_business_group_id := ben_dm_data_util.get_bg_id(x.business_group_name);

Line 3267: -- DK Resolve for Table PER_ABS_ATTENDANCE_REASONS

3263:
3264: -- DK Resolve for Table PER_ABSENCE_ATTENDANCE_TYPES
3265: get_dk_frm_aat;
3266:
3267: -- DK Resolve for Table PER_ABS_ATTENDANCE_REASONS
3268: get_dk_frm_aar;
3269:
3270: --
3271: