DBA Data[Home] [Help]

APPS.PAY_IN_TAX_DECLARATION dependencies on FND_PROFILE

Line 2385: WHERE (legislation_code = 'IN' OR business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID'))

2381: ,p_effective_date DATE)-- Added as a part of bug 4938573
2382: IS
2383: SELECT element_type_id
2384: FROM pay_element_types_f
2385: WHERE (legislation_code = 'IN' OR business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID'))
2386: AND element_name = p_element_name
2387: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
2388:
2389: CURSOR csr_element_link_details