APPS.BEN_DM_DOWNLOAD_DK dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 2574: -- DK Resolve from Table PER_ASSIGNMENT_STATUS_TYPES

2570: --
2571: end if;
2572: end;
2573: --
2574: -- DK Resolve from Table PER_ASSIGNMENT_STATUS_TYPES
2575: --
2576: procedure get_dk_frm_ast (p_business_group_name in VARCHAR2
2577: ,p_source_id in NUMBER
2578: ,p_resolve_mapping_id out nocopy NUMBER) is

Line 2580: -- cursor to Fetch the DK for PER_ASSIGNMENT_STATUS_TYPES.ASSIGNMENT_STATUS_TYPE_ID

2576: procedure get_dk_frm_ast (p_business_group_name in VARCHAR2
2577: ,p_source_id in NUMBER
2578: ,p_resolve_mapping_id out nocopy NUMBER) is
2579: --
2580: -- cursor to Fetch the DK for PER_ASSIGNMENT_STATUS_TYPES.ASSIGNMENT_STATUS_TYPE_ID
2581: --
2582: cursor csr_get_dk_ast is
2583: select user_status||'-'||nvl(legislation_code,'-x')||'-'||decode(business_group_id, null,'N','Y') status
2584: from per_assignment_status_types

Line 2584: from per_assignment_status_types

2580: -- cursor to Fetch the DK for PER_ASSIGNMENT_STATUS_TYPES.ASSIGNMENT_STATUS_TYPE_ID
2581: --
2582: cursor csr_get_dk_ast is
2583: select user_status||'-'||nvl(legislation_code,'-x')||'-'||decode(business_group_id, null,'N','Y') status
2584: from per_assignment_status_types
2585: where assignment_status_type_id = p_source_id;
2586:
2587: -- Declare local variables
2588: l_proc varchar2(72) := g_package || 'get_dk_frm_ast';

Line 2591: l_table_name varchar2(30) := 'PER_ASSIGNMENT_STATUS_TYPES';

2587: -- Declare local variables
2588: l_proc varchar2(72) := g_package || 'get_dk_frm_ast';
2589: l_row_fetched boolean := FALSE;
2590: l_table_rec csr_get_dk_ast%rowtype;
2591: l_table_name varchar2(30) := 'PER_ASSIGNMENT_STATUS_TYPES';
2592: l_column_name varchar2(30) := 'ASSIGNMENT_STATUS_TYPE_ID';
2593: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
2594:
2595: begin