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.

[Home] [Help]

APPS.PAY_GB_P11D_MILEAGE_EXTRACT dependencies on PAY_CONSOLIDATION_SETS

Line 382: l_consolidation_set pay_consolidation_sets.consolidation_set_name%TYPE;

378: -- consolidation set parameter
379: ---------------------------------------------------------------------------
380: FUNCTION get_param_consolidation_set_id(p_bus_group_id IN NUMBER) RETURN NUMBER IS
381: --
382: l_consolidation_set pay_consolidation_sets.consolidation_set_name%TYPE;
383: l_consolidation_set_id pay_consolidation_sets.consolidation_set_id%TYPE;
384: --
385: CURSOR get_consolidation_set_id IS
386: SELECT consolidation_set_id

Line 383: l_consolidation_set_id pay_consolidation_sets.consolidation_set_id%TYPE;

379: ---------------------------------------------------------------------------
380: FUNCTION get_param_consolidation_set_id(p_bus_group_id IN NUMBER) RETURN NUMBER IS
381: --
382: l_consolidation_set pay_consolidation_sets.consolidation_set_name%TYPE;
383: l_consolidation_set_id pay_consolidation_sets.consolidation_set_id%TYPE;
384: --
385: CURSOR get_consolidation_set_id IS
386: SELECT consolidation_set_id
387: FROM pay_consolidation_sets

Line 387: FROM pay_consolidation_sets

383: l_consolidation_set_id pay_consolidation_sets.consolidation_set_id%TYPE;
384: --
385: CURSOR get_consolidation_set_id IS
386: SELECT consolidation_set_id
387: FROM pay_consolidation_sets
388: WHERE consolidation_Set_name = l_consolidation_set
389: AND nvl(business_group_id, p_bus_group_id) = p_bus_group_id;
390: --
391: BEGIN