APPS.BEN_BENDFAUD_XMLP_PKG dependencies on HR_LOCATIONS

Line 30: l_location hr_locations.description%type ;

26: l_variable_rate_profile ben_vrbl_rt_prfl_f.name%type ;
27: l_legal_entity hr_all_organization_units.name%type ;
28: l_payroll pay_payrolls_f.payroll_name%type ;
29: l_status fnd_lookups.meaning%type ;
30: l_location hr_locations.description%type ;
31: l_audit_log hr_lookups.meaning%type ;
32: l_benft_group ben_benfts_grp.name%type ;
33: l_all varchar2(80);
34: begin

Line 83: from hr_locations a,

79: fnd_message.set_name('BEN','BEN_91792_ALL_PROMPT');
80: l_all := substrb(fnd_message.get,1,80);
81: begin
82: select location_code into CP_LOCATION
83: from hr_locations a,
84: ben_benefit_actions b
85: where a.location_id = b.location_id
86: and b.request_id = P_CONCURRENT_REQUEST_ID;
87: