DBA Data[Home] [Help]

APPS.HR_ELEMENT_LINKS dependencies on PAY_ELEMENT_SET_MEMBERS

Line 315: from pay_element_set_members esm,

311: into l_validation_ok
312: from sys.dual
313: where exists
314: (select 1
315: from pay_element_set_members esm,
316: pay_element_sets es
317: where esm.element_type_id = p_element_type_id
318: and es.element_set_id = esm.element_set_id
319: and es.element_set_type = 'D');

Line 340: from pay_element_set_members esm,

336: into l_validation_ok
337: from sys.dual
338: where exists
339: (select 1
340: from pay_element_set_members esm,
341: pay_element_classifications ec,
342: pay_element_classifications ec2
343: where ec.classification_id = p_classification_id
344: and esm.element_set_id = p_element_set_id

Line 368: from pay_element_set_members esm,

364: from pay_element_sets es
365: where es.element_set_id = p_element_set_id
366: and exists
367: (select 1
368: from pay_element_set_members esm,
369: pay_element_types_f et
370: where es.element_set_id = esm.element_set_id
371: and esm.element_type_id = et.element_type_id
372: and p_val_start_date between