APPS.PAY_PURGE_PKG dependencies on HR_LOOKUPS

Line 1246: l_ptr hr_lookups.meaning%type;

1242: ) return number is
1243: l_et_name pay_element_types_f.element_name%type;
1244: l_et_id pay_element_types_f.element_type_id%type;
1245: l_el_id pay_element_links_f.element_link_id%type;
1246: l_ptr hr_lookups.meaning%type;
1247: begin
1248:
1249: -- We use the element type sequence to obtain a unique
1250: -- value that becomes part of the name. This avoids

Line 1261: from hr_lookups hrl

1257: select pay_element_types_s.nextval,
1258: hrl.meaning
1259: into l_et_id,
1260: l_ptr
1261: from hr_lookups hrl
1262: where hrl.lookup_type = 'TERMINATION_RULE'
1263: and hrl.lookup_code = 'F';
1264:
1265: l_et_name := 'Initial_Value_Element_' ||