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_MILEAGE_EXTRACT dependencies on PAY_CONSOLIDATION_SETS

Line 345: l_consolidation_set pay_consolidation_sets.consolidation_set_name%TYPE;

341: -- consolidation set parameter
342: ---------------------------------------------------------------------------
343: FUNCTION get_param_consolidation_set_id(p_bus_group_id IN NUMBER) RETURN NUMBER IS
344: --
345: l_consolidation_set pay_consolidation_sets.consolidation_set_name%TYPE;
346: l_consolidation_set_id pay_consolidation_sets.consolidation_set_id%TYPE;
347: --
348: CURSOR get_consolidation_set_id IS
349: SELECT consolidation_set_id

Line 346: l_consolidation_set_id pay_consolidation_sets.consolidation_set_id%TYPE;

342: ---------------------------------------------------------------------------
343: FUNCTION get_param_consolidation_set_id(p_bus_group_id IN NUMBER) RETURN NUMBER IS
344: --
345: l_consolidation_set pay_consolidation_sets.consolidation_set_name%TYPE;
346: l_consolidation_set_id pay_consolidation_sets.consolidation_set_id%TYPE;
347: --
348: CURSOR get_consolidation_set_id IS
349: SELECT consolidation_set_id
350: FROM pay_consolidation_sets

Line 350: FROM pay_consolidation_sets

346: l_consolidation_set_id pay_consolidation_sets.consolidation_set_id%TYPE;
347: --
348: CURSOR get_consolidation_set_id IS
349: SELECT consolidation_set_id
350: FROM pay_consolidation_sets
351: WHERE consolidation_Set_name = l_consolidation_set
352: AND nvl(business_group_id, p_bus_group_id) = p_bus_group_id;
353: --
354: BEGIN