DBA Data[Home] [Help]

APPS.BEN_DM_DOWNLOAD_DK dependencies on PAY_ALL_PAYROLLS_F

Line 2290: -- DK Resolve from Table PAY_ALL_PAYROLLS_F

2286: --
2287: end if;
2288: end;
2289: --
2290: -- DK Resolve from Table PAY_ALL_PAYROLLS_F
2291: --
2292: procedure get_dk_frm_prl (p_business_group_name in VARCHAR2
2293: ,p_source_id in NUMBER
2294: ,p_resolve_mapping_id out nocopy NUMBER) is

Line 2296: -- cursor to Fetch the DK for PAY_ALL_PAYROLLS_F.PAYROLL_ID

2292: procedure get_dk_frm_prl (p_business_group_name in VARCHAR2
2293: ,p_source_id in NUMBER
2294: ,p_resolve_mapping_id out nocopy NUMBER) is
2295: --
2296: -- cursor to Fetch the DK for PAY_ALL_PAYROLLS_F.PAYROLL_ID
2297: --
2298: cursor csr_get_dk_prl is
2299: select payroll_name
2300: from pay_all_payrolls_f

Line 2300: from pay_all_payrolls_f

2296: -- cursor to Fetch the DK for PAY_ALL_PAYROLLS_F.PAYROLL_ID
2297: --
2298: cursor csr_get_dk_prl is
2299: select payroll_name
2300: from pay_all_payrolls_f
2301: where payroll_id = p_source_id;
2302:
2303: -- Declare local variables
2304: l_proc varchar2(72) := g_package || 'get_dk_frm_prl';

Line 2307: l_table_name varchar2(30) := 'PAY_ALL_PAYROLLS_F';

2303: -- Declare local variables
2304: l_proc varchar2(72) := g_package || 'get_dk_frm_prl';
2305: l_row_fetched boolean := FALSE;
2306: l_table_rec csr_get_dk_prl%rowtype;
2307: l_table_name varchar2(30) := 'PAY_ALL_PAYROLLS_F';
2308: l_column_name varchar2(30) := 'PAYROLL_ID';
2309: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
2310:
2311: begin