APPS.PAY_ETP_BUS_ND dependencies on PAY_ELEMENT_TYPES_F

Line 30: , pay_element_types_f etp

26: --
27: cursor csr_sec_grp is
28: select pbg.security_group_id
29: from per_business_groups pbg
30: , pay_element_types_f etp
31: where etp.element_type_id = p_element_type_id
32: and pbg.business_group_id = etp.business_group_id;
33: --
34: -- Declare local variables

Line 94: , pay_element_types_f etp

90: --
91: cursor csr_leg_code is
92: select pbg.legislation_code
93: from per_business_groups pbg
94: , pay_element_types_f etp
95: where etp.element_type_id = p_element_type_id
96: and pbg.business_group_id (+) = etp.business_group_id;
97: --
98: -- Declare local variables

Line 2173: (p_base_table_name => 'PAY_ELEMENT_TYPES_F'

2169: hr_utility.set_location('Entering:'||l_proc, 5);
2170: --
2171: If nvl(p_retro_summ_ele_id,hr_api.g_number) <> hr_api.g_number Then
2172: If not (dt_api.rows_exist
2173: (p_base_table_name => 'PAY_ELEMENT_TYPES_F'
2174: ,p_base_key_column => 'ELEMENT_TYPE_ID'
2175: ,p_base_key_value => p_retro_summ_ele_id
2176: ,p_from_date => p_validation_start_date
2177: ,p_to_date => p_validation_end_date

Line 2182: fnd_message.set_token('TABLE','PAY_ELEMENT_TYPES_F');

2178: )) Then
2179: --
2180: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
2181: fnd_message.set_token('COLUMN','RETRO_SUMM_ELE_ID');
2182: fnd_message.set_token('TABLE','PAY_ELEMENT_TYPES_F');
2183: fnd_message.raise_error;
2184: --
2185: End If;
2186: End If;