DBA Data[Home] [Help]

APPS.PAY_ELEMENT_DATA_PUMP dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 216: From pay_element_classifications pay,

212: Begin
213:
214: Select pay.classification_id
215: into l_classification_id
216: From pay_element_classifications pay,
217: pay_element_classifications_tl paytl
218: Where pay.classification_id = paytl.classification_id
219: and paytl.language = userenv('LANG')
220: and pay.parent_classification_id is null

Line 217: pay_element_classifications_tl paytl

213:
214: Select pay.classification_id
215: into l_classification_id
216: From pay_element_classifications pay,
217: pay_element_classifications_tl paytl
218: Where pay.classification_id = paytl.classification_id
219: and paytl.language = userenv('LANG')
220: and pay.parent_classification_id is null
221: and nvl(pay.legislation_code,

Line 348: From pay_element_classifications ec, pay_element_types_f et

344:
345: Begin
346: Select et.element_type_id
347: INTO l_element_type_id
348: From pay_element_classifications ec, pay_element_types_f et
349: Where ec.classification_id = et.classification_id
350: and p_effective_date between et.effective_start_date and
351: et.effective_end_date
352: and nvl(et.legislation_code,