DBA Data[Home] [Help]

APPS.PAY_US_W4_WF dependencies on HR_LOOKUPS

Line 200: from hr_lookups

196: stif.effective_end_date);
197:
198: CURSOR c_fed_filing_status_code IS
199: select meaning
200: from hr_lookups
201: where lookup_type = 'US_FIT_FILING_STATUS'
202: and lookup_code = lv_status_code;
203:
204:

Line 209: lv_status hr_lookups.meaning%TYPE;

205:
206: r_trans_rec c_transaction%ROWTYPE;
207: lv_state_list VARCHAR2(10000);
208: lv_state_name VARCHAR2(50);
209: lv_status hr_lookups.meaning%TYPE;
210: lv_username VARCHAR2(80);
211: lv_disp_name VARCHAR2(80);
212: l_proc VARCHAR2(80) := gv_package || '.init_tax_notifications';
213: