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.PAY_GB_P11D_CAR_EXTRACT dependencies on PAY_CONSOLIDATION_SETS

Line 207: l_consolidation_set pay_consolidation_sets.consolidation_set_name%TYPE;

203: -- consolidation set parameter
204: ---------------------------------------------------------------------------
205: FUNCTION get_param_consolidation_set_id(p_bus_group_id IN NUMBER) RETURN NUMBER IS
206: --
207: l_consolidation_set pay_consolidation_sets.consolidation_set_name%TYPE;
208: l_consolidation_set_id pay_consolidation_sets.consolidation_set_id%TYPE;
209: --
210: CURSOR get_consolidation_set_id IS
211: SELECT consolidation_set_id

Line 208: l_consolidation_set_id pay_consolidation_sets.consolidation_set_id%TYPE;

204: ---------------------------------------------------------------------------
205: FUNCTION get_param_consolidation_set_id(p_bus_group_id IN NUMBER) RETURN NUMBER IS
206: --
207: l_consolidation_set pay_consolidation_sets.consolidation_set_name%TYPE;
208: l_consolidation_set_id pay_consolidation_sets.consolidation_set_id%TYPE;
209: --
210: CURSOR get_consolidation_set_id IS
211: SELECT consolidation_set_id
212: FROM pay_consolidation_sets

Line 212: FROM pay_consolidation_sets

208: l_consolidation_set_id pay_consolidation_sets.consolidation_set_id%TYPE;
209: --
210: CURSOR get_consolidation_set_id IS
211: SELECT consolidation_set_id
212: FROM pay_consolidation_sets
213: WHERE consolidation_Set_name = l_consolidation_set
214: AND nvl(business_group_id, p_bus_group_id) = p_bus_group_id;
215: --
216: BEGIN