APPS.BEN_DM_UPLOAD_DK dependencies on PER_GRADES

Line 2475: -- DK Resolve For Table PER_GRADES

2471: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;
2472: end;
2473:
2474: --
2475: -- DK Resolve For Table PER_GRADES
2476: --
2477: procedure get_dk_frm_gra is
2478: --
2479: -- cursor to Fetch the DK for PER_GRADES.GRADE_ID

Line 2479: -- cursor to Fetch the DK for PER_GRADES.GRADE_ID

2475: -- DK Resolve For Table PER_GRADES
2476: --
2477: procedure get_dk_frm_gra is
2478: --
2479: -- cursor to Fetch the DK for PER_GRADES.GRADE_ID
2480: --
2481: cursor csr_get_dk_gra (c_business_group_id number, c_source_key varchar2) is
2482: select grade_id
2483: from per_grades

Line 2483: from per_grades

2479: -- cursor to Fetch the DK for PER_GRADES.GRADE_ID
2480: --
2481: cursor csr_get_dk_gra (c_business_group_id number, c_source_key varchar2) is
2482: select grade_id
2483: from per_grades
2484: where name = c_source_key
2485: ;
2486:
2487: cursor csr_get_all_gra is

Line 2490: where table_name = 'PER_GRADES'

2486:
2487: cursor csr_get_all_gra is
2488: select *
2489: from ben_dm_resolve_mappings
2490: where table_name = 'PER_GRADES'
2491: and target_id is null;
2492:
2493: -- Declare local variables
2494: l_proc varchar2(72) := g_package || 'get_dk_frm_gra';

Line 2503: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table PER_GRADES

2499:
2500: begin
2501:
2502: --
2503: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table PER_GRADES
2504: --
2505: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;
2506: for x in csr_get_all_gra loop
2507: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);

Line 3231: -- DK Resolve for Table PER_GRADES

3227:
3228: -- DK Resolve for Table PER_ASSIGNMENT_STATUS_TYPES
3229: get_dk_frm_ast;
3230:
3231: -- DK Resolve for Table PER_GRADES
3232: get_dk_frm_gra;
3233:
3234: -- DK Resolve for Table PER_JOBS
3235: get_dk_frm_job;