APPS.BEN_DM_UPLOAD_DK dependencies on PER_PAY_BASES

Line 2601: -- DK Resolve For Table PER_PAY_BASES

2597: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;
2598: end;
2599:
2600: --
2601: -- DK Resolve For Table PER_PAY_BASES
2602: --
2603: procedure get_dk_frm_pyb is
2604: --
2605: -- cursor to Fetch the DK for PER_PAY_BASES.PAY_BASIS_ID

Line 2605: -- cursor to Fetch the DK for PER_PAY_BASES.PAY_BASIS_ID

2601: -- DK Resolve For Table PER_PAY_BASES
2602: --
2603: procedure get_dk_frm_pyb is
2604: --
2605: -- cursor to Fetch the DK for PER_PAY_BASES.PAY_BASIS_ID
2606: --
2607: cursor csr_get_dk_pyb (c_business_group_id number, c_source_key varchar2) is
2608: select pay_basis_id
2609: from per_pay_bases

Line 2609: from per_pay_bases

2605: -- cursor to Fetch the DK for PER_PAY_BASES.PAY_BASIS_ID
2606: --
2607: cursor csr_get_dk_pyb (c_business_group_id number, c_source_key varchar2) is
2608: select pay_basis_id
2609: from per_pay_bases
2610: where name = c_source_key
2611: ;
2612:
2613: cursor csr_get_all_pyb is

Line 2616: where table_name = 'PER_PAY_BASES'

2612:
2613: cursor csr_get_all_pyb is
2614: select *
2615: from ben_dm_resolve_mappings
2616: where table_name = 'PER_PAY_BASES'
2617: and target_id is null;
2618:
2619: -- Declare local variables
2620: l_proc varchar2(72) := g_package || 'get_dk_frm_pyb';

Line 2629: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table PER_PAY_BASES

2625:
2626: begin
2627:
2628: --
2629: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table PER_PAY_BASES
2630: --
2631: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;
2632: for x in csr_get_all_pyb loop
2633: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);

Line 3237: -- DK Resolve for Table PER_PAY_BASES

3233:
3234: -- DK Resolve for Table PER_JOBS
3235: get_dk_frm_job;
3236:
3237: -- DK Resolve for Table PER_PAY_BASES
3238: get_dk_frm_pyb;
3239:
3240: -- DK Resolve for Table PER_PERSON_TYPES
3241: get_dk_frm_prt;