DBA Data[Home] [Help]

APPS.PAY_KR_SEP_FORM_PKG dependencies on PAY_ELEMENT_TYPE_USAGES_F

Line 2126: from pay_element_type_usages_f npetu

2122: from pay_element_type_rules petr
2123: where petr.element_set_id = p_element_set_id
2124: and petr.include_or_exclude = 'E')
2125: and not exists(select null
2126: from pay_element_type_usages_f npetu
2127: where npetu.element_type_id = petr.element_type_id
2128: and p_session_date between npetu.effective_start_date and npetu.effective_end_date
2129: and npetu.inclusion_flag = 'N'
2130: and npetu.run_type_id = p_run_type_id

Line 2210: from pay_element_type_usages_f npetu

2206: from pay_element_type_rules petr
2207: where petr.element_set_id = p_element_set_id
2208: and petr.include_or_exclude = 'E')
2209: and not exists(select null
2210: from pay_element_type_usages_f npetu
2211: where npetu.element_type_id = petr.element_type_id
2212: and p_session_date between npetu.effective_start_date and npetu.effective_end_date
2213: and npetu.inclusion_flag = 'N'
2214: and npetu.run_type_id = p_run_type_id