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_DOWNLOAD_DK dependencies on PER_PERSON_TYPES

Line 2834: -- DK Resolve from Table PER_PERSON_TYPES

2830: --
2831: end if;
2832: end;
2833: --
2834: -- DK Resolve from Table PER_PERSON_TYPES
2835: --
2836: procedure get_dk_frm_prt (p_business_group_name in VARCHAR2
2837: ,p_source_id in NUMBER
2838: ,p_resolve_mapping_id out nocopy NUMBER) is

Line 2840: -- cursor to Fetch the DK for PER_PERSON_TYPES.PERSON_TYPE_ID

2836: procedure get_dk_frm_prt (p_business_group_name in VARCHAR2
2837: ,p_source_id in NUMBER
2838: ,p_resolve_mapping_id out nocopy NUMBER) is
2839: --
2840: -- cursor to Fetch the DK for PER_PERSON_TYPES.PERSON_TYPE_ID
2841: --
2842: cursor csr_get_dk_prt is
2843: select user_person_type
2844: from per_person_types

Line 2844: from per_person_types

2840: -- cursor to Fetch the DK for PER_PERSON_TYPES.PERSON_TYPE_ID
2841: --
2842: cursor csr_get_dk_prt is
2843: select user_person_type
2844: from per_person_types
2845: where person_type_id = p_source_id;
2846:
2847: -- Declare local variables
2848: l_proc varchar2(72) := g_package || 'get_dk_frm_prt';

Line 2851: l_table_name varchar2(30) := 'PER_PERSON_TYPES';

2847: -- Declare local variables
2848: l_proc varchar2(72) := g_package || 'get_dk_frm_prt';
2849: l_row_fetched boolean := FALSE;
2850: l_table_rec csr_get_dk_prt%rowtype;
2851: l_table_name varchar2(30) := 'PER_PERSON_TYPES';
2852: l_column_name varchar2(30) := 'PERSON_TYPE_ID';
2853: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
2854:
2855: begin