DBA Data[Home] [Help]

APPS.PAY_KR_PROCESS_NAV_PKG dependencies on PAY_RUN_TYPES_F

Line 81: l_run_type_name pay_run_types_f_tl.run_type_name%TYPE ;

77: ) is
78: --
79: l_payment_type_id pay_payment_types.payment_type_id%TYPE ;
80: l_business_group_id per_business_groups.business_group_id%TYPE ;
81: l_run_type_name pay_run_types_f_tl.run_type_name%TYPE ;
82: l_bonus_start_date_hd varchar2(200) ; -- the bonus period start date (hidden)
83: l_additional_tax_rate_hd varchar2(200) ; -- additional tax rate for bonus pay (hidden)
84: l_overriding_tax_rate_hd varchar2(200) ; -- overriding tax rate for bonus pay (hidden)
85: l_payout_date_hd varchar2(200) ; -- the payout date (hidden)

Line 170: from pay_run_types_f_tl

166: where element_set_id = p_ele_set_id ;
167: --
168: cursor csr_run_type_name_tl is
169: select run_type_name
170: from pay_run_types_f_tl
171: where run_type_id = p_run_type_id
172: and language = userenv('LANG') ;
173: --
174: cursor csr_run_type_name is

Line 176: from pay_run_types_f

172: and language = userenv('LANG') ;
173: --
174: cursor csr_run_type_name is
175: select run_type_name
176: from pay_run_types_f
177: where run_type_id = p_run_type_id;
178: --
179: cursor csr_payment_method (p_pay_method in number) is
180: select org_payment_method_name

Line 224: pay_run_types_f prt,

220: pay_payroll_actions rppa,
221: pay_assignment_actions paa,
222: pay_assignment_actions rpaa,
223: pay_action_interlocks pai,
224: pay_run_types_f prt,
225: per_time_periods ptp
226: where ppa.payroll_action_id = p_run_type_period
227: and paa.payroll_action_id = ppa.payroll_action_id
228: and ppa.action_type in ('P','U')