APPS.PAY_KR_PROCESS_NAV_PKG dependencies on PAY_PAYMENT_TYPES

Line 79: l_payment_type_id pay_payment_types.payment_type_id%TYPE ;

75: -- Parameters that are not displayed
76: p_act_param_group_id in number -- action parameter group id
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)

Line 144: from pay_payment_types

140: and sysdate between effective_start_date and effective_end_date ;
141: --
142: cursor csr_payment_type is
143: select payment_type_id
144: from pay_payment_types
145: where payment_type_name = 'KR Direct Deposit' ;
146: --
147: cursor csr_payroll_name is
148: select payroll_name