DBA Data[Home] [Help]

APPS.PAY_NL_RETRO_SETUP_REPORT dependencies on PAY_ELEMENT_CLASSIFICATIONS_TL

Line 47: pay_element_classifications_tl pec1 ,

43: pec.classification_id,
44: pec1.classification_name
45: FROM
46: pay_element_classifications pec ,
47: pay_element_classifications_tl pec1 ,
48: pay_element_types_f pat
49: WHERE
50: pec.legislation_code = 'NL'
51: AND pec.parent_classification_id IS NULL

Line 84: pay_element_classifications_tl pec

80: pay_time_definitions ptd1,
81: pay_time_definitions ptd2,
82: pay_element_types_f pat1,
83: pay_retro_components prc,
84: pay_element_classifications_tl pec
85:
86: WHERE
87: pat.business_group_id = c_bg_id
88: AND c_eff_date between pat.effective_start_date AND pat.effective_end_date