APPS.PAY_KR_SEP_FORM_PKG dependencies on PAY_RUN_TYPES_F

Line 10: g_run_type_name pay_run_types_f_tl.run_type_name%type;

6: g_package varchar2(33) := 'pay_kr_sep_form_pkg.'; -- Global package name
7: g_debug boolean := hr_utility.debug_enabled;
8: g_old_rec pay_element_entries_f%ROWTYPE; -- Global record definition
9: g_run_type_id number;
10: g_run_type_name pay_run_types_f_tl.run_type_name%type;
11: g_entry_type varchar2(1) := 'E';
12: --
13: g_business_group_id number;
14: g_legislation_code varchar2(2);

Line 48: l_run_type_name pay_run_types_f_tl.run_type_name%type;

44: p_effective_date in date) return varchar2
45: --------------------------------------------------------------------------------
46: is
47: --
48: l_run_type_name pay_run_types_f_tl.run_type_name%type;
49: --
50: cursor csr_run_type_name
51: is
52: select prtt.run_type_name

Line 53: from pay_run_types_f_tl prtt,

49: --
50: cursor csr_run_type_name
51: is
52: select prtt.run_type_name
53: from pay_run_types_f_tl prtt,
54: pay_run_types_f prt
55: where prt.run_type_id = p_run_type_id
56: and p_effective_date
57: between prt.effective_start_date and prt.effective_end_date

Line 54: pay_run_types_f prt

50: cursor csr_run_type_name
51: is
52: select prtt.run_type_name
53: from pay_run_types_f_tl prtt,
54: pay_run_types_f prt
55: where prt.run_type_id = p_run_type_id
56: and p_effective_date
57: between prt.effective_start_date and prt.effective_end_date
58: and prtt.run_type_id = prt.run_type_id

Line 2440: pay_run_types_f prt

2436: is
2437: select decode(prt.run_type_name,'SEP','P','SEP_I','P','U')
2438: from pay_assignment_actions paa,
2439: pay_payroll_actions ppa,
2440: pay_run_types_f prt
2441: where ppa.payroll_action_id = paa.payroll_action_id
2442: and ppa.run_type_id = prt.run_type_id
2443: and prt.run_type_name = p_run_type_name
2444: and paa.assignment_id = p_assignment_id