APPS.BEN_DM_DOWNLOAD_DK dependencies on PAY_PEOPLE_GROUPS

Line 3172: -- DK Resolve from Table PAY_PEOPLE_GROUPS

3168: end if;
3169: end;
3170:
3171: --
3172: -- DK Resolve from Table PAY_PEOPLE_GROUPS
3173: --
3174: procedure get_dk_frm_peg (p_business_group_name in VARCHAR2
3175: ,p_source_id in NUMBER
3176: ,p_resolve_mapping_id out nocopy NUMBER) is

Line 3178: -- cursor to Fetch the DK for PAY_PEOPLE_GROUPS

3174: procedure get_dk_frm_peg (p_business_group_name in VARCHAR2
3175: ,p_source_id in NUMBER
3176: ,p_resolve_mapping_id out nocopy NUMBER) is
3177: --
3178: -- cursor to Fetch the DK for PAY_PEOPLE_GROUPS
3179: --
3180: cursor csr_get_dk_peg is
3181: select *
3182: from pay_people_groups

Line 3182: from pay_people_groups

3178: -- cursor to Fetch the DK for PAY_PEOPLE_GROUPS
3179: --
3180: cursor csr_get_dk_peg is
3181: select *
3182: from pay_people_groups
3183: where people_group_id = p_source_id;
3184:
3185: -- Declare local variables
3186: l_proc varchar2(72) := g_package || 'get_dk_frm_peg';

Line 3189: l_table_name varchar2(30) := 'PAY_PEOPLE_GROUPS';

3185: -- Declare local variables
3186: l_proc varchar2(72) := g_package || 'get_dk_frm_peg';
3187: l_row_fetched boolean := FALSE;
3188: l_table_rec csr_get_dk_peg%rowtype;
3189: l_table_name varchar2(30) := 'PAY_PEOPLE_GROUPS';
3190: l_column_name varchar2(30) := 'PEOPLE_GROUP_ID';
3191: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
3192: l_migration_id number;
3193: l_result_id number;