eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZX_TCM_CONTROL_PKG dependencies on XLE_FIRSTPARTY_INFORMATION_V

Line 259: FROM xle_firstparty_information_v

255:
256: -- Cursor for LE information
257: CURSOR c_xle_activity_code IS
258: SELECT 'ALLOCATED', le_effective_from, le_effective_to
259: FROM xle_firstparty_information_v
260: WHERE party_id = l_party_id
261: AND activity_category = l_tca_class_category_code
262: AND activity_code = l_class_code
263: -- AND p_fsc_rec.tax_determine_date between le_effective_from and nvl(le_effective_to,p_fsc_rec.tax_determine_date);

Line 268: FROM xle_firstparty_information_v

264: AND p_fsc_rec.tax_determine_date between NVL(le_effective_from,p_fsc_rec.tax_determine_date) and nvl(le_effective_to,p_fsc_rec.tax_determine_date);
265:
266: CURSOR c_xle_fc_assgn_exists IS
267: SELECT 'EXISTS'
268: FROM xle_firstparty_information_v
269: WHERE party_id = l_party_id
270: AND activity_category = l_tca_class_category_code
271: -- AND p_fsc_rec.tax_determine_date between le_effective_from and nvl(le_effective_to,p_fsc_rec.tax_determine_date)
272: AND p_fsc_rec.tax_determine_date between NVL(le_effective_from,p_fsc_rec.tax_determine_date) and nvl(le_effective_to,p_fsc_rec.tax_determine_date)