APPS.PAY_VOID_REVERSAL_PKG dependencies on HR_LOOKUPS

Line 75: l_sort_sequence hr_lookups.meaning%TYPE;

71: );
72: --
73: check_details_rec check_details_rectype;
74: l_request_id number;
75: l_sort_sequence hr_lookups.meaning%TYPE;
76: l_check_style hr_lookups.meaning%TYPE;
77: l_curr_payroll_action_id pay_payroll_Actions.payroll_Action_id%type;
78: --
79: l_wait_outcome BOOLEAN;

Line 76: l_check_style hr_lookups.meaning%TYPE;

72: --
73: check_details_rec check_details_rectype;
74: l_request_id number;
75: l_sort_sequence hr_lookups.meaning%TYPE;
76: l_check_style hr_lookups.meaning%TYPE;
77: l_curr_payroll_action_id pay_payroll_Actions.payroll_Action_id%type;
78: --
79: l_wait_outcome BOOLEAN;
80: l_phase VARCHAR2(80);

Line 186: from hr_lookups

182: hr_utility.set_location(l_proc, 30);
183:
184: -- get the sort sequence
185: select lookup_code into l_sort_sequence
186: from hr_lookups
187: where lookup_type = 'CHEQUE_PROCEDURE'
188: and lookup_code = 'DEFAULT';
189: -- get the check style
190: select lookup_code into l_check_style

Line 191: from hr_lookups

187: where lookup_type = 'CHEQUE_PROCEDURE'
188: and lookup_code = 'DEFAULT';
189: -- get the check style
190: select lookup_code into l_check_style
191: from hr_lookups
192: where lookup_type='CHEQUE_REPORT'
193: and lookup_code='PAYUSCHK';
194: --
195: END IF;