APPS.PAY_NO_PACCR_PKG dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 431: from pay_element_classifications pec1

427: AND pet.element_type_id = piv.element_type_id
428: -- Modified for bug fix 5242486
429: AND pet.classification_id IN
430: (select pec2.classification_id
431: from pay_element_classifications pec1
432: , pay_element_classifications pec2
433: -- Added for bug fix 5242486
434: , pay_sub_classification_rules_f pscrf
435: where pec2.classification_id = pec1.parent_classification_id (+)

Line 432: , pay_element_classifications pec2

428: -- Modified for bug fix 5242486
429: AND pet.classification_id IN
430: (select pec2.classification_id
431: from pay_element_classifications pec1
432: , pay_element_classifications pec2
433: -- Added for bug fix 5242486
434: , pay_sub_classification_rules_f pscrf
435: where pec2.classification_id = pec1.parent_classification_id (+)
436: and nvl(pec1.classification_name,'0') like decode(p_restr_econtr

Line 448: from pay_element_classifications pec1

444: and ppa.date_earned between pscrf.effective_start_date and pscrf.effective_end_date
445: -- Added for bug fix 6069852
446: UNION ALL
447: select pec2.classification_id
448: from pay_element_classifications pec1
449: , pay_element_classifications pec2
450: where pec2.classification_id = pec1.parent_classification_id (+)
451: and nvl(pec1.classification_name,'0') like decode(p_restr_econtr
452: , 'N','%')

Line 449: , pay_element_classifications pec2

445: -- Added for bug fix 6069852
446: UNION ALL
447: select pec2.classification_id
448: from pay_element_classifications pec1
449: , pay_element_classifications pec2
450: where pec2.classification_id = pec1.parent_classification_id (+)
451: and nvl(pec1.classification_name,'0') like decode(p_restr_econtr
452: , 'N','%')
453: and pec2.classification_id = pet.classification_id