DBA Data[Home] [Help]

APPS.PAY_PURGE_PKG dependencies on PAY_ELEMENT_LINKS_F

Line 1157: l_el_id pay_element_links_f.element_link_id%type;

1153:
1154: l_iv_count number;
1155: l_et_id pay_element_types_f.element_type_id%type;
1156: l_iv_id pay_input_values_f.input_value_id%type;
1157: l_el_id pay_element_links_f.element_link_id%type;
1158: l_et_name pay_element_types_f.element_name%type;
1159: l_iv_name pay_input_values_f.name%type;
1160: l_bg_name per_business_groups.name%type;
1161: l_et_count number := 0;

Line 1245: l_el_id pay_element_links_f.element_link_id%type;

1241: p_et_count in number
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

Line 1329: from pay_element_links_f pel,

1325: pet.business_group_id
1326: into l_et_name,
1327: l_et_id,
1328: l_bg_id
1329: from pay_element_links_f pel,
1330: pay_element_types_f pet
1331: where pel.element_link_id = p_el_id
1332: and pel.effective_start_date = c_sot
1333: and pel.effective_end_date = c_eot