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_ARCHIVE_SS dependencies on HR_GB_PROCESS_P11D_ENTRIES_PKG

Line 1825: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('A_DESC', l_col1_val);

1821: WHERE action_context_id = p_assignment_action_id AND
1822: action_information_category = 'GB P11D ASSIGNMENT RESULTA'
1823: AND action_context_type = 'AAP';
1824:
1825: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('A_DESC', l_col1_val);
1826: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_COST', l_col2_val);
1827: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_AMG', l_col3_val);
1828: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_CE', l_col4_val);
1829: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('B_DESC', l_col5_val);

Line 1826: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_COST', l_col2_val);

1822: action_information_category = 'GB P11D ASSIGNMENT RESULTA'
1823: AND action_context_type = 'AAP';
1824:
1825: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('A_DESC', l_col1_val);
1826: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_COST', l_col2_val);
1827: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_AMG', l_col3_val);
1828: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_CE', l_col4_val);
1829: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('B_DESC', l_col5_val);
1830: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_CE', l_col6_val);

Line 1827: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_AMG', l_col3_val);

1823: AND action_context_type = 'AAP';
1824:
1825: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('A_DESC', l_col1_val);
1826: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_COST', l_col2_val);
1827: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_AMG', l_col3_val);
1828: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_CE', l_col4_val);
1829: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('B_DESC', l_col5_val);
1830: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_CE', l_col6_val);
1831: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_TNP', l_col7_val);

Line 1828: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_CE', l_col4_val);

1824:
1825: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('A_DESC', l_col1_val);
1826: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_COST', l_col2_val);
1827: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_AMG', l_col3_val);
1828: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_CE', l_col4_val);
1829: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('B_DESC', l_col5_val);
1830: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_CE', l_col6_val);
1831: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_TNP', l_col7_val);
1832: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_COST', l_col8_val);

Line 1829: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('B_DESC', l_col5_val);

1825: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('A_DESC', l_col1_val);
1826: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_COST', l_col2_val);
1827: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_AMG', l_col3_val);
1828: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_CE', l_col4_val);
1829: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('B_DESC', l_col5_val);
1830: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_CE', l_col6_val);
1831: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_TNP', l_col7_val);
1832: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_COST', l_col8_val);
1833: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_AMG', l_col9_val);

Line 1830: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_CE', l_col6_val);

1826: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_COST', l_col2_val);
1827: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_AMG', l_col3_val);
1828: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_CE', l_col4_val);
1829: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('B_DESC', l_col5_val);
1830: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_CE', l_col6_val);
1831: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_TNP', l_col7_val);
1832: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_COST', l_col8_val);
1833: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_AMG', l_col9_val);
1834: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_CE', l_col10_val);

Line 1831: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_TNP', l_col7_val);

1827: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_AMG', l_col3_val);
1828: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_CE', l_col4_val);
1829: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('B_DESC', l_col5_val);
1830: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_CE', l_col6_val);
1831: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_TNP', l_col7_val);
1832: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_COST', l_col8_val);
1833: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_AMG', l_col9_val);
1834: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_CE', l_col10_val);
1835: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('D_CE', l_col11_val);

Line 1832: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_COST', l_col8_val);

1828: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_CE', l_col4_val);
1829: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('B_DESC', l_col5_val);
1830: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_CE', l_col6_val);
1831: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_TNP', l_col7_val);
1832: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_COST', l_col8_val);
1833: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_AMG', l_col9_val);
1834: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_CE', l_col10_val);
1835: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('D_CE', l_col11_val);
1836: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('E_CE', l_col12_val);

Line 1833: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_AMG', l_col9_val);

1829: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('B_DESC', l_col5_val);
1830: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_CE', l_col6_val);
1831: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_TNP', l_col7_val);
1832: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_COST', l_col8_val);
1833: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_AMG', l_col9_val);
1834: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_CE', l_col10_val);
1835: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('D_CE', l_col11_val);
1836: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('E_CE', l_col12_val);
1837: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_TCCE', l_col13_val);

Line 1834: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_CE', l_col10_val);

1830: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_CE', l_col6_val);
1831: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_TNP', l_col7_val);
1832: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_COST', l_col8_val);
1833: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_AMG', l_col9_val);
1834: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_CE', l_col10_val);
1835: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('D_CE', l_col11_val);
1836: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('E_CE', l_col12_val);
1837: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_TCCE', l_col13_val);
1838: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_TFCE', l_col14_val);

Line 1835: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('D_CE', l_col11_val);

1831: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_TNP', l_col7_val);
1832: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_COST', l_col8_val);
1833: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_AMG', l_col9_val);
1834: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_CE', l_col10_val);
1835: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('D_CE', l_col11_val);
1836: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('E_CE', l_col12_val);
1837: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_TCCE', l_col13_val);
1838: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_TFCE', l_col14_val);
1839: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('G_CE', l_col15_val);

Line 1836: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('E_CE', l_col12_val);

1832: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_COST', l_col8_val);
1833: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_AMG', l_col9_val);
1834: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_CE', l_col10_val);
1835: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('D_CE', l_col11_val);
1836: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('E_CE', l_col12_val);
1837: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_TCCE', l_col13_val);
1838: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_TFCE', l_col14_val);
1839: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('G_CE', l_col15_val);
1840: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_COST', l_col16_val);

Line 1837: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_TCCE', l_col13_val);

1833: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_AMG', l_col9_val);
1834: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_CE', l_col10_val);
1835: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('D_CE', l_col11_val);
1836: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('E_CE', l_col12_val);
1837: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_TCCE', l_col13_val);
1838: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_TFCE', l_col14_val);
1839: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('G_CE', l_col15_val);
1840: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_COST', l_col16_val);
1841: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_AMG', l_col17_val);

Line 1838: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_TFCE', l_col14_val);

1834: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_CE', l_col10_val);
1835: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('D_CE', l_col11_val);
1836: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('E_CE', l_col12_val);
1837: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_TCCE', l_col13_val);
1838: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_TFCE', l_col14_val);
1839: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('G_CE', l_col15_val);
1840: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_COST', l_col16_val);
1841: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_AMG', l_col17_val);
1842: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_CE', l_col18_val);

Line 1839: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('G_CE', l_col15_val);

1835: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('D_CE', l_col11_val);
1836: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('E_CE', l_col12_val);
1837: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_TCCE', l_col13_val);
1838: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_TFCE', l_col14_val);
1839: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('G_CE', l_col15_val);
1840: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_COST', l_col16_val);
1841: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_AMG', l_col17_val);
1842: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_CE', l_col18_val);
1843: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('J_CE', l_col19_val);

Line 1840: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_COST', l_col16_val);

1836: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('E_CE', l_col12_val);
1837: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_TCCE', l_col13_val);
1838: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_TFCE', l_col14_val);
1839: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('G_CE', l_col15_val);
1840: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_COST', l_col16_val);
1841: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_AMG', l_col17_val);
1842: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_CE', l_col18_val);
1843: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('J_CE', l_col19_val);
1844: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_COST', l_col20_val);

Line 1841: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_AMG', l_col17_val);

1837: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_TCCE', l_col13_val);
1838: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_TFCE', l_col14_val);
1839: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('G_CE', l_col15_val);
1840: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_COST', l_col16_val);
1841: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_AMG', l_col17_val);
1842: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_CE', l_col18_val);
1843: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('J_CE', l_col19_val);
1844: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_COST', l_col20_val);
1845: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_AMG', l_col21_val);

Line 1842: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_CE', l_col18_val);

1838: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_TFCE', l_col14_val);
1839: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('G_CE', l_col15_val);
1840: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_COST', l_col16_val);
1841: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_AMG', l_col17_val);
1842: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_CE', l_col18_val);
1843: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('J_CE', l_col19_val);
1844: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_COST', l_col20_val);
1845: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_AMG', l_col21_val);
1846: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_CE', l_col22_val);

Line 1843: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('J_CE', l_col19_val);

1839: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('G_CE', l_col15_val);
1840: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_COST', l_col16_val);
1841: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_AMG', l_col17_val);
1842: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_CE', l_col18_val);
1843: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('J_CE', l_col19_val);
1844: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_COST', l_col20_val);
1845: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_AMG', l_col21_val);
1846: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_CE', l_col22_val);
1847: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('L_DESC', l_col23_val);

Line 1844: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_COST', l_col20_val);

1840: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_COST', l_col16_val);
1841: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_AMG', l_col17_val);
1842: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_CE', l_col18_val);
1843: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('J_CE', l_col19_val);
1844: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_COST', l_col20_val);
1845: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_AMG', l_col21_val);
1846: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_CE', l_col22_val);
1847: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('L_DESC', l_col23_val);
1848: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_COST', l_col24_val);

Line 1845: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_AMG', l_col21_val);

1841: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_AMG', l_col17_val);
1842: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_CE', l_col18_val);
1843: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('J_CE', l_col19_val);
1844: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_COST', l_col20_val);
1845: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_AMG', l_col21_val);
1846: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_CE', l_col22_val);
1847: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('L_DESC', l_col23_val);
1848: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_COST', l_col24_val);
1849: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_AMG', l_col25_val);

Line 1846: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_CE', l_col22_val);

1842: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_CE', l_col18_val);
1843: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('J_CE', l_col19_val);
1844: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_COST', l_col20_val);
1845: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_AMG', l_col21_val);
1846: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_CE', l_col22_val);
1847: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('L_DESC', l_col23_val);
1848: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_COST', l_col24_val);
1849: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_AMG', l_col25_val);
1850: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_CE', l_col26_val);

Line 1847: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('L_DESC', l_col23_val);

1843: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('J_CE', l_col19_val);
1844: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_COST', l_col20_val);
1845: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_AMG', l_col21_val);
1846: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_CE', l_col22_val);
1847: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('L_DESC', l_col23_val);
1848: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_COST', l_col24_val);
1849: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_AMG', l_col25_val);
1850: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_CE', l_col26_val);
1851: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('M_SHARES', l_col27_val);

Line 1848: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_COST', l_col24_val);

1844: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_COST', l_col20_val);
1845: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_AMG', l_col21_val);
1846: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_CE', l_col22_val);
1847: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('L_DESC', l_col23_val);
1848: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_COST', l_col24_val);
1849: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_AMG', l_col25_val);
1850: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_CE', l_col26_val);
1851: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('M_SHARES', l_col27_val);
1852: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('H_CE1', l_col28_val);

Line 1849: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_AMG', l_col25_val);

1845: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_AMG', l_col21_val);
1846: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_CE', l_col22_val);
1847: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('L_DESC', l_col23_val);
1848: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_COST', l_col24_val);
1849: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_AMG', l_col25_val);
1850: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_CE', l_col26_val);
1851: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('M_SHARES', l_col27_val);
1852: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('H_CE1', l_col28_val);
1853: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('H_COUNT', l_col29_val);

Line 1850: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_CE', l_col26_val);

1846: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_CE', l_col22_val);
1847: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('L_DESC', l_col23_val);
1848: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_COST', l_col24_val);
1849: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_AMG', l_col25_val);
1850: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_CE', l_col26_val);
1851: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('M_SHARES', l_col27_val);
1852: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('H_CE1', l_col28_val);
1853: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('H_COUNT', l_col29_val);
1854: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_COUNT', l_col30_val);

Line 1851: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('M_SHARES', l_col27_val);

1847: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('L_DESC', l_col23_val);
1848: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_COST', l_col24_val);
1849: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_AMG', l_col25_val);
1850: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_CE', l_col26_val);
1851: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('M_SHARES', l_col27_val);
1852: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('H_CE1', l_col28_val);
1853: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('H_COUNT', l_col29_val);
1854: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_COUNT', l_col30_val);
1855:

Line 1852: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('H_CE1', l_col28_val);

1848: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_COST', l_col24_val);
1849: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_AMG', l_col25_val);
1850: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_CE', l_col26_val);
1851: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('M_SHARES', l_col27_val);
1852: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('H_CE1', l_col28_val);
1853: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('H_COUNT', l_col29_val);
1854: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_COUNT', l_col30_val);
1855:
1856: SELECT action_information1, action_information2, action_information3, action_information4,

Line 1853: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('H_COUNT', l_col29_val);

1849: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_AMG', l_col25_val);
1850: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_CE', l_col26_val);
1851: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('M_SHARES', l_col27_val);
1852: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('H_CE1', l_col28_val);
1853: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('H_COUNT', l_col29_val);
1854: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_COUNT', l_col30_val);
1855:
1856: SELECT action_information1, action_information2, action_information3, action_information4,
1857: action_information5, action_information6, action_information7, action_information8,

Line 1854: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_COUNT', l_col30_val);

1850: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_CE', l_col26_val);
1851: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('M_SHARES', l_col27_val);
1852: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('H_CE1', l_col28_val);
1853: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('H_COUNT', l_col29_val);
1854: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_COUNT', l_col30_val);
1855:
1856: SELECT action_information1, action_information2, action_information3, action_information4,
1857: action_information5, action_information6, action_information7, action_information8,
1858: action_information9, action_information10, action_information11, action_information12,

Line 1877: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('N_DESC', l_col1_val);

1873: WHERE action_context_id = p_assignment_action_id AND
1874: action_information_category ='GB P11D ASSIGNMENT RESULTB'
1875: AND action_context_type = 'AAP';
1876:
1877: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('N_DESC', l_col1_val);
1878: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N_COST', l_col2_val);
1879: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N_AMG', l_col3_val);
1880: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N_CE', l_col4_val);
1881: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('NA_DESC', l_col5_val);

Line 1878: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N_COST', l_col2_val);

1874: action_information_category ='GB P11D ASSIGNMENT RESULTB'
1875: AND action_context_type = 'AAP';
1876:
1877: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('N_DESC', l_col1_val);
1878: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N_COST', l_col2_val);
1879: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N_AMG', l_col3_val);
1880: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N_CE', l_col4_val);
1881: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('NA_DESC', l_col5_val);
1882: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('NA_COST', l_col6_val);

Line 1879: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N_AMG', l_col3_val);

1875: AND action_context_type = 'AAP';
1876:
1877: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('N_DESC', l_col1_val);
1878: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N_COST', l_col2_val);
1879: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N_AMG', l_col3_val);
1880: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N_CE', l_col4_val);
1881: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('NA_DESC', l_col5_val);
1882: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('NA_COST', l_col6_val);
1883: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('NA_AMG', l_col7_val);

Line 1880: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N_CE', l_col4_val);

1876:
1877: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('N_DESC', l_col1_val);
1878: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N_COST', l_col2_val);
1879: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N_AMG', l_col3_val);
1880: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N_CE', l_col4_val);
1881: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('NA_DESC', l_col5_val);
1882: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('NA_COST', l_col6_val);
1883: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('NA_AMG', l_col7_val);
1884: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('NA_CE', l_col8_val);

Line 1881: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('NA_DESC', l_col5_val);

1877: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('N_DESC', l_col1_val);
1878: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N_COST', l_col2_val);
1879: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N_AMG', l_col3_val);
1880: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N_CE', l_col4_val);
1881: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('NA_DESC', l_col5_val);
1882: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('NA_COST', l_col6_val);
1883: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('NA_AMG', l_col7_val);
1884: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('NA_CE', l_col8_val);
1885: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N_TAXPAID', l_col9_val);

Line 1882: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('NA_COST', l_col6_val);

1878: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N_COST', l_col2_val);
1879: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N_AMG', l_col3_val);
1880: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N_CE', l_col4_val);
1881: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('NA_DESC', l_col5_val);
1882: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('NA_COST', l_col6_val);
1883: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('NA_AMG', l_col7_val);
1884: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('NA_CE', l_col8_val);
1885: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N_TAXPAID', l_col9_val);
1886: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O1_COST', l_col10_val);

Line 1883: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('NA_AMG', l_col7_val);

1879: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N_AMG', l_col3_val);
1880: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N_CE', l_col4_val);
1881: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('NA_DESC', l_col5_val);
1882: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('NA_COST', l_col6_val);
1883: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('NA_AMG', l_col7_val);
1884: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('NA_CE', l_col8_val);
1885: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N_TAXPAID', l_col9_val);
1886: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O1_COST', l_col10_val);
1887: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O1_AMG', l_col11_val);

Line 1884: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('NA_CE', l_col8_val);

1880: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N_CE', l_col4_val);
1881: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('NA_DESC', l_col5_val);
1882: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('NA_COST', l_col6_val);
1883: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('NA_AMG', l_col7_val);
1884: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('NA_CE', l_col8_val);
1885: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N_TAXPAID', l_col9_val);
1886: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O1_COST', l_col10_val);
1887: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O1_AMG', l_col11_val);
1888: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O1_CE', l_col12_val);

Line 1885: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N_TAXPAID', l_col9_val);

1881: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('NA_DESC', l_col5_val);
1882: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('NA_COST', l_col6_val);
1883: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('NA_AMG', l_col7_val);
1884: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('NA_CE', l_col8_val);
1885: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N_TAXPAID', l_col9_val);
1886: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O1_COST', l_col10_val);
1887: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O1_AMG', l_col11_val);
1888: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O1_CE', l_col12_val);
1889: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O2_COST', l_col13_val);

Line 1886: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O1_COST', l_col10_val);

1882: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('NA_COST', l_col6_val);
1883: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('NA_AMG', l_col7_val);
1884: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('NA_CE', l_col8_val);
1885: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N_TAXPAID', l_col9_val);
1886: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O1_COST', l_col10_val);
1887: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O1_AMG', l_col11_val);
1888: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O1_CE', l_col12_val);
1889: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O2_COST', l_col13_val);
1890: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O2_AMG', l_col14_val);

Line 1887: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O1_AMG', l_col11_val);

1883: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('NA_AMG', l_col7_val);
1884: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('NA_CE', l_col8_val);
1885: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N_TAXPAID', l_col9_val);
1886: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O1_COST', l_col10_val);
1887: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O1_AMG', l_col11_val);
1888: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O1_CE', l_col12_val);
1889: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O2_COST', l_col13_val);
1890: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O2_AMG', l_col14_val);
1891: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O2_CE', l_col15_val);

Line 1888: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O1_CE', l_col12_val);

1884: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('NA_CE', l_col8_val);
1885: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N_TAXPAID', l_col9_val);
1886: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O1_COST', l_col10_val);
1887: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O1_AMG', l_col11_val);
1888: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O1_CE', l_col12_val);
1889: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O2_COST', l_col13_val);
1890: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O2_AMG', l_col14_val);
1891: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O2_CE', l_col15_val);
1892: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('O_TOI', l_col16_val);

Line 1889: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O2_COST', l_col13_val);

1885: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N_TAXPAID', l_col9_val);
1886: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O1_COST', l_col10_val);
1887: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O1_AMG', l_col11_val);
1888: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O1_CE', l_col12_val);
1889: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O2_COST', l_col13_val);
1890: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O2_AMG', l_col14_val);
1891: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O2_CE', l_col15_val);
1892: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('O_TOI', l_col16_val);
1893: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O3_COST', l_col17_val);

Line 1890: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O2_AMG', l_col14_val);

1886: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O1_COST', l_col10_val);
1887: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O1_AMG', l_col11_val);
1888: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O1_CE', l_col12_val);
1889: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O2_COST', l_col13_val);
1890: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O2_AMG', l_col14_val);
1891: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O2_CE', l_col15_val);
1892: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('O_TOI', l_col16_val);
1893: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O3_COST', l_col17_val);
1894: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O3_AMG', l_col18_val);

Line 1891: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O2_CE', l_col15_val);

1887: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O1_AMG', l_col11_val);
1888: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O1_CE', l_col12_val);
1889: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O2_COST', l_col13_val);
1890: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O2_AMG', l_col14_val);
1891: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O2_CE', l_col15_val);
1892: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('O_TOI', l_col16_val);
1893: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O3_COST', l_col17_val);
1894: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O3_AMG', l_col18_val);
1895: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O3_CE', l_col19_val);

Line 1892: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('O_TOI', l_col16_val);

1888: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O1_CE', l_col12_val);
1889: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O2_COST', l_col13_val);
1890: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O2_AMG', l_col14_val);
1891: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O2_CE', l_col15_val);
1892: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('O_TOI', l_col16_val);
1893: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O3_COST', l_col17_val);
1894: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O3_AMG', l_col18_val);
1895: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O3_CE', l_col19_val);
1896: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O4_COST', l_col20_val);

Line 1893: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O3_COST', l_col17_val);

1889: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O2_COST', l_col13_val);
1890: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O2_AMG', l_col14_val);
1891: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O2_CE', l_col15_val);
1892: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('O_TOI', l_col16_val);
1893: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O3_COST', l_col17_val);
1894: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O3_AMG', l_col18_val);
1895: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O3_CE', l_col19_val);
1896: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O4_COST', l_col20_val);
1897: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O4_AMG', l_col21_val);

Line 1894: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O3_AMG', l_col18_val);

1890: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O2_AMG', l_col14_val);
1891: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O2_CE', l_col15_val);
1892: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('O_TOI', l_col16_val);
1893: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O3_COST', l_col17_val);
1894: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O3_AMG', l_col18_val);
1895: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O3_CE', l_col19_val);
1896: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O4_COST', l_col20_val);
1897: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O4_AMG', l_col21_val);
1898: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O4_CE', l_col22_val);

Line 1895: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O3_CE', l_col19_val);

1891: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O2_CE', l_col15_val);
1892: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('O_TOI', l_col16_val);
1893: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O3_COST', l_col17_val);
1894: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O3_AMG', l_col18_val);
1895: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O3_CE', l_col19_val);
1896: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O4_COST', l_col20_val);
1897: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O4_AMG', l_col21_val);
1898: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O4_CE', l_col22_val);
1899: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O5_COST', l_col23_val);

Line 1896: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O4_COST', l_col20_val);

1892: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('O_TOI', l_col16_val);
1893: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O3_COST', l_col17_val);
1894: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O3_AMG', l_col18_val);
1895: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O3_CE', l_col19_val);
1896: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O4_COST', l_col20_val);
1897: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O4_AMG', l_col21_val);
1898: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O4_CE', l_col22_val);
1899: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O5_COST', l_col23_val);
1900: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O5_AMG', l_col24_val);

Line 1897: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O4_AMG', l_col21_val);

1893: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O3_COST', l_col17_val);
1894: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O3_AMG', l_col18_val);
1895: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O3_CE', l_col19_val);
1896: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O4_COST', l_col20_val);
1897: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O4_AMG', l_col21_val);
1898: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O4_CE', l_col22_val);
1899: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O5_COST', l_col23_val);
1900: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O5_AMG', l_col24_val);
1901: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O5_CE', l_col25_val);

Line 1898: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O4_CE', l_col22_val);

1894: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O3_AMG', l_col18_val);
1895: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O3_CE', l_col19_val);
1896: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O4_COST', l_col20_val);
1897: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O4_AMG', l_col21_val);
1898: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O4_CE', l_col22_val);
1899: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O5_COST', l_col23_val);
1900: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O5_AMG', l_col24_val);
1901: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O5_CE', l_col25_val);
1902: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('O6_DESC', l_col26_val);

Line 1899: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O5_COST', l_col23_val);

1895: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O3_CE', l_col19_val);
1896: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O4_COST', l_col20_val);
1897: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O4_AMG', l_col21_val);
1898: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O4_CE', l_col22_val);
1899: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O5_COST', l_col23_val);
1900: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O5_AMG', l_col24_val);
1901: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O5_CE', l_col25_val);
1902: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('O6_DESC', l_col26_val);
1903: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O6_COST', l_col27_val);

Line 1900: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O5_AMG', l_col24_val);

1896: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O4_COST', l_col20_val);
1897: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O4_AMG', l_col21_val);
1898: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O4_CE', l_col22_val);
1899: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O5_COST', l_col23_val);
1900: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O5_AMG', l_col24_val);
1901: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O5_CE', l_col25_val);
1902: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('O6_DESC', l_col26_val);
1903: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O6_COST', l_col27_val);
1904: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O6_AMG', l_col28_val);

Line 1901: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O5_CE', l_col25_val);

1897: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O4_AMG', l_col21_val);
1898: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O4_CE', l_col22_val);
1899: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O5_COST', l_col23_val);
1900: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O5_AMG', l_col24_val);
1901: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O5_CE', l_col25_val);
1902: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('O6_DESC', l_col26_val);
1903: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O6_COST', l_col27_val);
1904: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O6_AMG', l_col28_val);
1905: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O6_CE', l_col29_val);

Line 1902: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('O6_DESC', l_col26_val);

1898: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O4_CE', l_col22_val);
1899: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O5_COST', l_col23_val);
1900: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O5_AMG', l_col24_val);
1901: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O5_CE', l_col25_val);
1902: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('O6_DESC', l_col26_val);
1903: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O6_COST', l_col27_val);
1904: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O6_AMG', l_col28_val);
1905: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O6_CE', l_col29_val);
1906:

Line 1903: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O6_COST', l_col27_val);

1899: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O5_COST', l_col23_val);
1900: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O5_AMG', l_col24_val);
1901: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O5_CE', l_col25_val);
1902: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('O6_DESC', l_col26_val);
1903: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O6_COST', l_col27_val);
1904: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O6_AMG', l_col28_val);
1905: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O6_CE', l_col29_val);
1906:
1907: --

Line 1904: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O6_AMG', l_col28_val);

1900: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O5_AMG', l_col24_val);
1901: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O5_CE', l_col25_val);
1902: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('O6_DESC', l_col26_val);
1903: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O6_COST', l_col27_val);
1904: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O6_AMG', l_col28_val);
1905: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O6_CE', l_col29_val);
1906:
1907: --
1908: SELECT action_information1, action_information2, action_information3, action_information4,

Line 1905: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O6_CE', l_col29_val);

1901: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O5_CE', l_col25_val);
1902: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('O6_DESC', l_col26_val);
1903: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O6_COST', l_col27_val);
1904: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O6_AMG', l_col28_val);
1905: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O6_CE', l_col29_val);
1906:
1907: --
1908: SELECT action_information1, action_information2, action_information3, action_information4,
1909: action_information5, action_information6, action_information7, action_information8,

Line 1929: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_BUS_MILES', l_col1_val);

1925: WHERE action_context_id = p_assignment_action_id AND
1926: action_information_category ='GB P11D ASSIGNMENT RESULTC'
1927: AND action_context_type = 'AAP';
1928:
1929: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_BUS_MILES', l_col1_val);
1930: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_BUS_MILES', l_col2_val);
1931: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_BUS_MILES', l_col3_val);
1932: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('C_RATE1','N',l_col4_val);
1933: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('C_RATE2','N',l_col5_val);

Line 1930: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_BUS_MILES', l_col2_val);

1926: action_information_category ='GB P11D ASSIGNMENT RESULTC'
1927: AND action_context_type = 'AAP';
1928:
1929: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_BUS_MILES', l_col1_val);
1930: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_BUS_MILES', l_col2_val);
1931: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_BUS_MILES', l_col3_val);
1932: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('C_RATE1','N',l_col4_val);
1933: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('C_RATE2','N',l_col5_val);
1934: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('M_RATE1','N',l_col6_val);

Line 1931: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_BUS_MILES', l_col3_val);

1927: AND action_context_type = 'AAP';
1928:
1929: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_BUS_MILES', l_col1_val);
1930: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_BUS_MILES', l_col2_val);
1931: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_BUS_MILES', l_col3_val);
1932: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('C_RATE1','N',l_col4_val);
1933: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('C_RATE2','N',l_col5_val);
1934: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('M_RATE1','N',l_col6_val);
1935: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('M_RATE2','N',l_col7_val);

Line 1932: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('C_RATE1','N',l_col4_val);

1928:
1929: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_BUS_MILES', l_col1_val);
1930: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_BUS_MILES', l_col2_val);
1931: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_BUS_MILES', l_col3_val);
1932: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('C_RATE1','N',l_col4_val);
1933: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('C_RATE2','N',l_col5_val);
1934: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('M_RATE1','N',l_col6_val);
1935: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('M_RATE2','N',l_col7_val);
1936: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('B_RATE1','N',l_col8_val);

Line 1933: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('C_RATE2','N',l_col5_val);

1929: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_BUS_MILES', l_col1_val);
1930: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_BUS_MILES', l_col2_val);
1931: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_BUS_MILES', l_col3_val);
1932: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('C_RATE1','N',l_col4_val);
1933: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('C_RATE2','N',l_col5_val);
1934: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('M_RATE1','N',l_col6_val);
1935: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('M_RATE2','N',l_col7_val);
1936: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('B_RATE1','N',l_col8_val);
1937: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('B_RATE2','N',l_col9_val);

Line 1934: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('M_RATE1','N',l_col6_val);

1930: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_BUS_MILES', l_col2_val);
1931: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_BUS_MILES', l_col3_val);
1932: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('C_RATE1','N',l_col4_val);
1933: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('C_RATE2','N',l_col5_val);
1934: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('M_RATE1','N',l_col6_val);
1935: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('M_RATE2','N',l_col7_val);
1936: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('B_RATE1','N',l_col8_val);
1937: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('B_RATE2','N',l_col9_val);
1938:

Line 1935: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('M_RATE2','N',l_col7_val);

1931: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_BUS_MILES', l_col3_val);
1932: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('C_RATE1','N',l_col4_val);
1933: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('C_RATE2','N',l_col5_val);
1934: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('M_RATE1','N',l_col6_val);
1935: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('M_RATE2','N',l_col7_val);
1936: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('B_RATE1','N',l_col8_val);
1937: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('B_RATE2','N',l_col9_val);
1938:
1939: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('DT_FREE_FUEL_WITHDRAWN','D',l_col10_val);

Line 1936: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('B_RATE1','N',l_col8_val);

1932: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('C_RATE1','N',l_col4_val);
1933: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('C_RATE2','N',l_col5_val);
1934: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('M_RATE1','N',l_col6_val);
1935: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('M_RATE2','N',l_col7_val);
1936: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('B_RATE1','N',l_col8_val);
1937: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('B_RATE2','N',l_col9_val);
1938:
1939: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('DT_FREE_FUEL_WITHDRAWN','D',l_col10_val);
1940: if l_ret_text = '1'

Line 1937: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('B_RATE2','N',l_col9_val);

1933: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('C_RATE2','N',l_col5_val);
1934: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('M_RATE1','N',l_col6_val);
1935: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('M_RATE2','N',l_col7_val);
1936: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('B_RATE1','N',l_col8_val);
1937: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('B_RATE2','N',l_col9_val);
1938:
1939: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('DT_FREE_FUEL_WITHDRAWN','D',l_col10_val);
1940: if l_ret_text = '1'
1941: then

Line 1939: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('DT_FREE_FUEL_WITHDRAWN','D',l_col10_val);

1935: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('M_RATE2','N',l_col7_val);
1936: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('B_RATE1','N',l_col8_val);
1937: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('B_RATE2','N',l_col9_val);
1938:
1939: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('DT_FREE_FUEL_WITHDRAWN','D',l_col10_val);
1940: if l_ret_text = '1'
1941: then
1942: l_warn:=1;
1943: l_val_error_count := l_val_error_count + 1;

Line 1949: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('FREE_FUEL_REINSTATED','T',l_col11_val);

1945: l_val_errors(l_val_error_count).error_assignment_name := l_assignment_name;
1946: l_val_errors(l_val_error_count).error_assignment_number := l_assignment_number;
1947: l_val_errors(l_val_error_count).error_element_name :='Car and Car Fuel 2003-04';
1948: end if;
1949: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('FREE_FUEL_REINSTATED','T',l_col11_val);
1950: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_MILEAGE_PAYMENTS', l_col12_val);
1951: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_MILEAGE_PAYMENTS', l_col13_val);
1952: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_MILEAGE_PAYMENTS', l_col14_val);
1953: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MARORS_COUNT', l_col15_val);

Line 1950: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_MILEAGE_PAYMENTS', l_col12_val);

1946: l_val_errors(l_val_error_count).error_assignment_number := l_assignment_number;
1947: l_val_errors(l_val_error_count).error_element_name :='Car and Car Fuel 2003-04';
1948: end if;
1949: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('FREE_FUEL_REINSTATED','T',l_col11_val);
1950: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_MILEAGE_PAYMENTS', l_col12_val);
1951: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_MILEAGE_PAYMENTS', l_col13_val);
1952: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_MILEAGE_PAYMENTS', l_col14_val);
1953: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MARORS_COUNT', l_col15_val);
1954: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_TAX_DEDUCTED', l_col16_val);

Line 1951: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_MILEAGE_PAYMENTS', l_col13_val);

1947: l_val_errors(l_val_error_count).error_element_name :='Car and Car Fuel 2003-04';
1948: end if;
1949: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('FREE_FUEL_REINSTATED','T',l_col11_val);
1950: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_MILEAGE_PAYMENTS', l_col12_val);
1951: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_MILEAGE_PAYMENTS', l_col13_val);
1952: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_MILEAGE_PAYMENTS', l_col14_val);
1953: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MARORS_COUNT', l_col15_val);
1954: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_TAX_DEDUCTED', l_col16_val);
1955: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_TAX_DEDUCTED', l_col17_val);

Line 1952: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_MILEAGE_PAYMENTS', l_col14_val);

1948: end if;
1949: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('FREE_FUEL_REINSTATED','T',l_col11_val);
1950: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_MILEAGE_PAYMENTS', l_col12_val);
1951: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_MILEAGE_PAYMENTS', l_col13_val);
1952: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_MILEAGE_PAYMENTS', l_col14_val);
1953: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MARORS_COUNT', l_col15_val);
1954: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_TAX_DEDUCTED', l_col16_val);
1955: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_TAX_DEDUCTED', l_col17_val);
1956: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_TAX_DEDUCTED', l_col18_val);

Line 1953: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MARORS_COUNT', l_col15_val);

1949: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('FREE_FUEL_REINSTATED','T',l_col11_val);
1950: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_MILEAGE_PAYMENTS', l_col12_val);
1951: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_MILEAGE_PAYMENTS', l_col13_val);
1952: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_MILEAGE_PAYMENTS', l_col14_val);
1953: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MARORS_COUNT', l_col15_val);
1954: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_TAX_DEDUCTED', l_col16_val);
1955: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_TAX_DEDUCTED', l_col17_val);
1956: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_TAX_DEDUCTED', l_col18_val);
1957: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_PAYMENTS', l_col19_val);

Line 1954: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_TAX_DEDUCTED', l_col16_val);

1950: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_MILEAGE_PAYMENTS', l_col12_val);
1951: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_MILEAGE_PAYMENTS', l_col13_val);
1952: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_MILEAGE_PAYMENTS', l_col14_val);
1953: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MARORS_COUNT', l_col15_val);
1954: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_TAX_DEDUCTED', l_col16_val);
1955: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_TAX_DEDUCTED', l_col17_val);
1956: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_TAX_DEDUCTED', l_col18_val);
1957: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_PAYMENTS', l_col19_val);
1958: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_BUS_MILES', l_col20_val);

Line 1955: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_TAX_DEDUCTED', l_col17_val);

1951: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_MILEAGE_PAYMENTS', l_col13_val);
1952: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_MILEAGE_PAYMENTS', l_col14_val);
1953: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MARORS_COUNT', l_col15_val);
1954: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_TAX_DEDUCTED', l_col16_val);
1955: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_TAX_DEDUCTED', l_col17_val);
1956: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_TAX_DEDUCTED', l_col18_val);
1957: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_PAYMENTS', l_col19_val);
1958: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_BUS_MILES', l_col20_val);
1959: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_BUS_MILE_AMT', l_col21_val);

Line 1956: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_TAX_DEDUCTED', l_col18_val);

1952: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_MILEAGE_PAYMENTS', l_col14_val);
1953: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MARORS_COUNT', l_col15_val);
1954: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_TAX_DEDUCTED', l_col16_val);
1955: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_TAX_DEDUCTED', l_col17_val);
1956: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_TAX_DEDUCTED', l_col18_val);
1957: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_PAYMENTS', l_col19_val);
1958: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_BUS_MILES', l_col20_val);
1959: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_BUS_MILE_AMT', l_col21_val);
1960: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MILEAGE_ALLOWANCE_RELIEF', l_col22_val);

Line 1957: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_PAYMENTS', l_col19_val);

1953: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MARORS_COUNT', l_col15_val);
1954: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_TAX_DEDUCTED', l_col16_val);
1955: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_TAX_DEDUCTED', l_col17_val);
1956: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_TAX_DEDUCTED', l_col18_val);
1957: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_PAYMENTS', l_col19_val);
1958: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_BUS_MILES', l_col20_val);
1959: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_BUS_MILE_AMT', l_col21_val);
1960: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MILEAGE_ALLOWANCE_RELIEF', l_col22_val);
1961: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('INT_MAX_AMT_OUTSTANDING', l_col23_val);

Line 1958: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_BUS_MILES', l_col20_val);

1954: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_TAX_DEDUCTED', l_col16_val);
1955: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_TAX_DEDUCTED', l_col17_val);
1956: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_TAX_DEDUCTED', l_col18_val);
1957: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_PAYMENTS', l_col19_val);
1958: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_BUS_MILES', l_col20_val);
1959: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_BUS_MILE_AMT', l_col21_val);
1960: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MILEAGE_ALLOWANCE_RELIEF', l_col22_val);
1961: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('INT_MAX_AMT_OUTSTANDING', l_col23_val);
1962: else

Line 1959: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_BUS_MILE_AMT', l_col21_val);

1955: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_TAX_DEDUCTED', l_col17_val);
1956: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_TAX_DEDUCTED', l_col18_val);
1957: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_PAYMENTS', l_col19_val);
1958: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_BUS_MILES', l_col20_val);
1959: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_BUS_MILE_AMT', l_col21_val);
1960: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MILEAGE_ALLOWANCE_RELIEF', l_col22_val);
1961: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('INT_MAX_AMT_OUTSTANDING', l_col23_val);
1962: else
1963: /* Code for year 04/05 onwards */

Line 1960: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MILEAGE_ALLOWANCE_RELIEF', l_col22_val);

1956: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_TAX_DEDUCTED', l_col18_val);
1957: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_PAYMENTS', l_col19_val);
1958: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_BUS_MILES', l_col20_val);
1959: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_BUS_MILE_AMT', l_col21_val);
1960: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MILEAGE_ALLOWANCE_RELIEF', l_col22_val);
1961: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('INT_MAX_AMT_OUTSTANDING', l_col23_val);
1962: else
1963: /* Code for year 04/05 onwards */
1964: SELECT action_information1, action_information2, action_information3, action_information4,

Line 1961: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('INT_MAX_AMT_OUTSTANDING', l_col23_val);

1957: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_PAYMENTS', l_col19_val);
1958: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_BUS_MILES', l_col20_val);
1959: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_BUS_MILE_AMT', l_col21_val);
1960: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MILEAGE_ALLOWANCE_RELIEF', l_col22_val);
1961: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('INT_MAX_AMT_OUTSTANDING', l_col23_val);
1962: else
1963: /* Code for year 04/05 onwards */
1964: SELECT action_information1, action_information2, action_information3, action_information4,
1965: action_information5, action_information6, action_information7, action_information8,

Line 1985: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('A_DESC', l_col1_val);

1981: WHERE action_context_id = p_assignment_action_id AND
1982: action_information_category = 'GB P11D ASSIGNMENT RESULTA'
1983: AND action_context_type = 'AAP';
1984:
1985: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('A_DESC', l_col1_val);
1986: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_COST', l_col2_val);
1987: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_AMG', l_col3_val);
1988: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_CE', l_col4_val);
1989: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('B_DESC', l_col5_val);

Line 1986: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_COST', l_col2_val);

1982: action_information_category = 'GB P11D ASSIGNMENT RESULTA'
1983: AND action_context_type = 'AAP';
1984:
1985: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('A_DESC', l_col1_val);
1986: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_COST', l_col2_val);
1987: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_AMG', l_col3_val);
1988: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_CE', l_col4_val);
1989: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('B_DESC', l_col5_val);
1990: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_CE', l_col6_val);

Line 1987: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_AMG', l_col3_val);

1983: AND action_context_type = 'AAP';
1984:
1985: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('A_DESC', l_col1_val);
1986: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_COST', l_col2_val);
1987: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_AMG', l_col3_val);
1988: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_CE', l_col4_val);
1989: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('B_DESC', l_col5_val);
1990: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_CE', l_col6_val);
1991: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_TNP', l_col7_val);

Line 1988: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_CE', l_col4_val);

1984:
1985: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('A_DESC', l_col1_val);
1986: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_COST', l_col2_val);
1987: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_AMG', l_col3_val);
1988: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_CE', l_col4_val);
1989: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('B_DESC', l_col5_val);
1990: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_CE', l_col6_val);
1991: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_TNP', l_col7_val);
1992: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_COST', l_col8_val);

Line 1989: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('B_DESC', l_col5_val);

1985: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('A_DESC', l_col1_val);
1986: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_COST', l_col2_val);
1987: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_AMG', l_col3_val);
1988: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_CE', l_col4_val);
1989: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('B_DESC', l_col5_val);
1990: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_CE', l_col6_val);
1991: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_TNP', l_col7_val);
1992: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_COST', l_col8_val);
1993: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_AMG', l_col9_val);

Line 1990: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_CE', l_col6_val);

1986: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_COST', l_col2_val);
1987: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_AMG', l_col3_val);
1988: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_CE', l_col4_val);
1989: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('B_DESC', l_col5_val);
1990: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_CE', l_col6_val);
1991: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_TNP', l_col7_val);
1992: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_COST', l_col8_val);
1993: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_AMG', l_col9_val);
1994: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_CE', l_col10_val);

Line 1991: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_TNP', l_col7_val);

1987: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_AMG', l_col3_val);
1988: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_CE', l_col4_val);
1989: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('B_DESC', l_col5_val);
1990: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_CE', l_col6_val);
1991: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_TNP', l_col7_val);
1992: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_COST', l_col8_val);
1993: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_AMG', l_col9_val);
1994: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_CE', l_col10_val);
1995: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('D_CE', l_col11_val);

Line 1992: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_COST', l_col8_val);

1988: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_CE', l_col4_val);
1989: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('B_DESC', l_col5_val);
1990: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_CE', l_col6_val);
1991: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_TNP', l_col7_val);
1992: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_COST', l_col8_val);
1993: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_AMG', l_col9_val);
1994: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_CE', l_col10_val);
1995: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('D_CE', l_col11_val);
1996: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('E_CE', l_col12_val);

Line 1993: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_AMG', l_col9_val);

1989: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('B_DESC', l_col5_val);
1990: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_CE', l_col6_val);
1991: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_TNP', l_col7_val);
1992: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_COST', l_col8_val);
1993: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_AMG', l_col9_val);
1994: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_CE', l_col10_val);
1995: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('D_CE', l_col11_val);
1996: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('E_CE', l_col12_val);
1997: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_TCCE', l_col13_val);

Line 1994: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_CE', l_col10_val);

1990: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_CE', l_col6_val);
1991: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_TNP', l_col7_val);
1992: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_COST', l_col8_val);
1993: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_AMG', l_col9_val);
1994: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_CE', l_col10_val);
1995: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('D_CE', l_col11_val);
1996: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('E_CE', l_col12_val);
1997: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_TCCE', l_col13_val);
1998: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_TFCE', l_col14_val);

Line 1995: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('D_CE', l_col11_val);

1991: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_TNP', l_col7_val);
1992: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_COST', l_col8_val);
1993: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_AMG', l_col9_val);
1994: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_CE', l_col10_val);
1995: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('D_CE', l_col11_val);
1996: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('E_CE', l_col12_val);
1997: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_TCCE', l_col13_val);
1998: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_TFCE', l_col14_val);
1999: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('G_CE', l_col15_val);

Line 1996: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('E_CE', l_col12_val);

1992: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_COST', l_col8_val);
1993: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_AMG', l_col9_val);
1994: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_CE', l_col10_val);
1995: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('D_CE', l_col11_val);
1996: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('E_CE', l_col12_val);
1997: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_TCCE', l_col13_val);
1998: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_TFCE', l_col14_val);
1999: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('G_CE', l_col15_val);
2000: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_COST', l_col16_val);

Line 1997: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_TCCE', l_col13_val);

1993: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_AMG', l_col9_val);
1994: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_CE', l_col10_val);
1995: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('D_CE', l_col11_val);
1996: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('E_CE', l_col12_val);
1997: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_TCCE', l_col13_val);
1998: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_TFCE', l_col14_val);
1999: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('G_CE', l_col15_val);
2000: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_COST', l_col16_val);
2001: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_AMG', l_col17_val);

Line 1998: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_TFCE', l_col14_val);

1994: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_CE', l_col10_val);
1995: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('D_CE', l_col11_val);
1996: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('E_CE', l_col12_val);
1997: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_TCCE', l_col13_val);
1998: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_TFCE', l_col14_val);
1999: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('G_CE', l_col15_val);
2000: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_COST', l_col16_val);
2001: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_AMG', l_col17_val);
2002: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_CE', l_col18_val);

Line 1999: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('G_CE', l_col15_val);

1995: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('D_CE', l_col11_val);
1996: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('E_CE', l_col12_val);
1997: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_TCCE', l_col13_val);
1998: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_TFCE', l_col14_val);
1999: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('G_CE', l_col15_val);
2000: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_COST', l_col16_val);
2001: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_AMG', l_col17_val);
2002: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_CE', l_col18_val);
2003: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('J_CE', l_col19_val);

Line 2000: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_COST', l_col16_val);

1996: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('E_CE', l_col12_val);
1997: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_TCCE', l_col13_val);
1998: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_TFCE', l_col14_val);
1999: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('G_CE', l_col15_val);
2000: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_COST', l_col16_val);
2001: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_AMG', l_col17_val);
2002: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_CE', l_col18_val);
2003: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('J_CE', l_col19_val);
2004: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_COST', l_col20_val);

Line 2001: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_AMG', l_col17_val);

1997: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_TCCE', l_col13_val);
1998: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_TFCE', l_col14_val);
1999: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('G_CE', l_col15_val);
2000: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_COST', l_col16_val);
2001: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_AMG', l_col17_val);
2002: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_CE', l_col18_val);
2003: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('J_CE', l_col19_val);
2004: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_COST', l_col20_val);
2005: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_AMG', l_col21_val);

Line 2002: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_CE', l_col18_val);

1998: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_TFCE', l_col14_val);
1999: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('G_CE', l_col15_val);
2000: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_COST', l_col16_val);
2001: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_AMG', l_col17_val);
2002: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_CE', l_col18_val);
2003: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('J_CE', l_col19_val);
2004: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_COST', l_col20_val);
2005: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_AMG', l_col21_val);
2006: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_CE', l_col22_val);

Line 2003: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('J_CE', l_col19_val);

1999: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('G_CE', l_col15_val);
2000: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_COST', l_col16_val);
2001: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_AMG', l_col17_val);
2002: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_CE', l_col18_val);
2003: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('J_CE', l_col19_val);
2004: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_COST', l_col20_val);
2005: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_AMG', l_col21_val);
2006: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_CE', l_col22_val);
2007: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('L_DESC', l_col23_val);

Line 2004: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_COST', l_col20_val);

2000: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_COST', l_col16_val);
2001: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_AMG', l_col17_val);
2002: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_CE', l_col18_val);
2003: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('J_CE', l_col19_val);
2004: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_COST', l_col20_val);
2005: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_AMG', l_col21_val);
2006: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_CE', l_col22_val);
2007: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('L_DESC', l_col23_val);
2008: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_COST', l_col24_val);

Line 2005: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_AMG', l_col21_val);

2001: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_AMG', l_col17_val);
2002: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_CE', l_col18_val);
2003: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('J_CE', l_col19_val);
2004: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_COST', l_col20_val);
2005: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_AMG', l_col21_val);
2006: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_CE', l_col22_val);
2007: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('L_DESC', l_col23_val);
2008: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_COST', l_col24_val);
2009: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_AMG', l_col25_val);

Line 2006: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_CE', l_col22_val);

2002: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_CE', l_col18_val);
2003: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('J_CE', l_col19_val);
2004: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_COST', l_col20_val);
2005: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_AMG', l_col21_val);
2006: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_CE', l_col22_val);
2007: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('L_DESC', l_col23_val);
2008: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_COST', l_col24_val);
2009: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_AMG', l_col25_val);
2010: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_CE', l_col26_val);

Line 2007: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('L_DESC', l_col23_val);

2003: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('J_CE', l_col19_val);
2004: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_COST', l_col20_val);
2005: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_AMG', l_col21_val);
2006: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_CE', l_col22_val);
2007: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('L_DESC', l_col23_val);
2008: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_COST', l_col24_val);
2009: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_AMG', l_col25_val);
2010: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_CE', l_col26_val);
2011: /* l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('M_SHARES', l_col27_val); */

Line 2008: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_COST', l_col24_val);

2004: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_COST', l_col20_val);
2005: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_AMG', l_col21_val);
2006: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_CE', l_col22_val);
2007: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('L_DESC', l_col23_val);
2008: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_COST', l_col24_val);
2009: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_AMG', l_col25_val);
2010: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_CE', l_col26_val);
2011: /* l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('M_SHARES', l_col27_val); */
2012: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('H_CE1', l_col28_val);

Line 2009: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_AMG', l_col25_val);

2005: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_AMG', l_col21_val);
2006: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_CE', l_col22_val);
2007: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('L_DESC', l_col23_val);
2008: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_COST', l_col24_val);
2009: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_AMG', l_col25_val);
2010: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_CE', l_col26_val);
2011: /* l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('M_SHARES', l_col27_val); */
2012: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('H_CE1', l_col28_val);
2013: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('H_COUNT', l_col29_val);

Line 2010: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_CE', l_col26_val);

2006: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_CE', l_col22_val);
2007: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('L_DESC', l_col23_val);
2008: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_COST', l_col24_val);
2009: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_AMG', l_col25_val);
2010: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_CE', l_col26_val);
2011: /* l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('M_SHARES', l_col27_val); */
2012: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('H_CE1', l_col28_val);
2013: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('H_COUNT', l_col29_val);
2014: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_COUNT', l_col30_val);

Line 2011: /* l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('M_SHARES', l_col27_val); */

2007: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('L_DESC', l_col23_val);
2008: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_COST', l_col24_val);
2009: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_AMG', l_col25_val);
2010: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_CE', l_col26_val);
2011: /* l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('M_SHARES', l_col27_val); */
2012: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('H_CE1', l_col28_val);
2013: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('H_COUNT', l_col29_val);
2014: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_COUNT', l_col30_val);
2015:

Line 2012: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('H_CE1', l_col28_val);

2008: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_COST', l_col24_val);
2009: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_AMG', l_col25_val);
2010: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_CE', l_col26_val);
2011: /* l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('M_SHARES', l_col27_val); */
2012: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('H_CE1', l_col28_val);
2013: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('H_COUNT', l_col29_val);
2014: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_COUNT', l_col30_val);
2015:
2016: SELECT action_information1, action_information2, action_information3, action_information4,

Line 2013: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('H_COUNT', l_col29_val);

2009: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_AMG', l_col25_val);
2010: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_CE', l_col26_val);
2011: /* l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('M_SHARES', l_col27_val); */
2012: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('H_CE1', l_col28_val);
2013: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('H_COUNT', l_col29_val);
2014: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_COUNT', l_col30_val);
2015:
2016: SELECT action_information1, action_information2, action_information3, action_information4,
2017: action_information5, action_information6, action_information7, action_information8,

Line 2014: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_COUNT', l_col30_val);

2010: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_CE', l_col26_val);
2011: /* l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('M_SHARES', l_col27_val); */
2012: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('H_CE1', l_col28_val);
2013: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('H_COUNT', l_col29_val);
2014: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_COUNT', l_col30_val);
2015:
2016: SELECT action_information1, action_information2, action_information3, action_information4,
2017: action_information5, action_information6, action_information7, action_information8,
2018: action_information9, action_information10, action_information11, action_information12,

Line 2037: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('M_DESC', l_col1_val);

2033: WHERE action_context_id = p_assignment_action_id AND
2034: action_information_category ='GB P11D ASSIGNMENT RESULTB'
2035: AND action_context_type = 'AAP';
2036:
2037: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('M_DESC', l_col1_val);
2038: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_COST', l_col2_val);
2039: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_AMG', l_col3_val);
2040: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_CE', l_col4_val);
2041: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('MA_DESC', l_col5_val);

Line 2038: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_COST', l_col2_val);

2034: action_information_category ='GB P11D ASSIGNMENT RESULTB'
2035: AND action_context_type = 'AAP';
2036:
2037: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('M_DESC', l_col1_val);
2038: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_COST', l_col2_val);
2039: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_AMG', l_col3_val);
2040: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_CE', l_col4_val);
2041: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('MA_DESC', l_col5_val);
2042: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MA_COST', l_col6_val);

Line 2039: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_AMG', l_col3_val);

2035: AND action_context_type = 'AAP';
2036:
2037: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('M_DESC', l_col1_val);
2038: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_COST', l_col2_val);
2039: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_AMG', l_col3_val);
2040: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_CE', l_col4_val);
2041: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('MA_DESC', l_col5_val);
2042: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MA_COST', l_col6_val);
2043: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MA_AMG', l_col7_val);

Line 2040: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_CE', l_col4_val);

2036:
2037: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('M_DESC', l_col1_val);
2038: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_COST', l_col2_val);
2039: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_AMG', l_col3_val);
2040: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_CE', l_col4_val);
2041: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('MA_DESC', l_col5_val);
2042: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MA_COST', l_col6_val);
2043: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MA_AMG', l_col7_val);
2044: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MA_CE', l_col8_val);

Line 2041: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('MA_DESC', l_col5_val);

2037: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('M_DESC', l_col1_val);
2038: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_COST', l_col2_val);
2039: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_AMG', l_col3_val);
2040: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_CE', l_col4_val);
2041: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('MA_DESC', l_col5_val);
2042: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MA_COST', l_col6_val);
2043: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MA_AMG', l_col7_val);
2044: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MA_CE', l_col8_val);
2045: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_TAXPAID', l_col9_val);

Line 2042: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MA_COST', l_col6_val);

2038: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_COST', l_col2_val);
2039: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_AMG', l_col3_val);
2040: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_CE', l_col4_val);
2041: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('MA_DESC', l_col5_val);
2042: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MA_COST', l_col6_val);
2043: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MA_AMG', l_col7_val);
2044: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MA_CE', l_col8_val);
2045: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_TAXPAID', l_col9_val);
2046: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N1_COST', l_col10_val);

Line 2043: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MA_AMG', l_col7_val);

2039: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_AMG', l_col3_val);
2040: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_CE', l_col4_val);
2041: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('MA_DESC', l_col5_val);
2042: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MA_COST', l_col6_val);
2043: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MA_AMG', l_col7_val);
2044: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MA_CE', l_col8_val);
2045: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_TAXPAID', l_col9_val);
2046: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N1_COST', l_col10_val);
2047: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N1_AMG', l_col11_val);

Line 2044: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MA_CE', l_col8_val);

2040: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_CE', l_col4_val);
2041: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('MA_DESC', l_col5_val);
2042: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MA_COST', l_col6_val);
2043: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MA_AMG', l_col7_val);
2044: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MA_CE', l_col8_val);
2045: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_TAXPAID', l_col9_val);
2046: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N1_COST', l_col10_val);
2047: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N1_AMG', l_col11_val);
2048: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N1_CE', l_col12_val);

Line 2045: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_TAXPAID', l_col9_val);

2041: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('MA_DESC', l_col5_val);
2042: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MA_COST', l_col6_val);
2043: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MA_AMG', l_col7_val);
2044: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MA_CE', l_col8_val);
2045: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_TAXPAID', l_col9_val);
2046: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N1_COST', l_col10_val);
2047: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N1_AMG', l_col11_val);
2048: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N1_CE', l_col12_val);
2049: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N2_COST', l_col13_val);

Line 2046: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N1_COST', l_col10_val);

2042: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MA_COST', l_col6_val);
2043: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MA_AMG', l_col7_val);
2044: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MA_CE', l_col8_val);
2045: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_TAXPAID', l_col9_val);
2046: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N1_COST', l_col10_val);
2047: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N1_AMG', l_col11_val);
2048: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N1_CE', l_col12_val);
2049: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N2_COST', l_col13_val);
2050: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N2_AMG', l_col14_val);

Line 2047: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N1_AMG', l_col11_val);

2043: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MA_AMG', l_col7_val);
2044: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MA_CE', l_col8_val);
2045: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_TAXPAID', l_col9_val);
2046: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N1_COST', l_col10_val);
2047: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N1_AMG', l_col11_val);
2048: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N1_CE', l_col12_val);
2049: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N2_COST', l_col13_val);
2050: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N2_AMG', l_col14_val);
2051: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N2_CE', l_col15_val);

Line 2048: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N1_CE', l_col12_val);

2044: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MA_CE', l_col8_val);
2045: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_TAXPAID', l_col9_val);
2046: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N1_COST', l_col10_val);
2047: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N1_AMG', l_col11_val);
2048: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N1_CE', l_col12_val);
2049: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N2_COST', l_col13_val);
2050: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N2_AMG', l_col14_val);
2051: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N2_CE', l_col15_val);
2052: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('N_TOI', l_col16_val);

Line 2049: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N2_COST', l_col13_val);

2045: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_TAXPAID', l_col9_val);
2046: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N1_COST', l_col10_val);
2047: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N1_AMG', l_col11_val);
2048: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N1_CE', l_col12_val);
2049: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N2_COST', l_col13_val);
2050: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N2_AMG', l_col14_val);
2051: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N2_CE', l_col15_val);
2052: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('N_TOI', l_col16_val);
2053: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N3_COST', l_col17_val);

Line 2050: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N2_AMG', l_col14_val);

2046: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N1_COST', l_col10_val);
2047: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N1_AMG', l_col11_val);
2048: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N1_CE', l_col12_val);
2049: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N2_COST', l_col13_val);
2050: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N2_AMG', l_col14_val);
2051: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N2_CE', l_col15_val);
2052: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('N_TOI', l_col16_val);
2053: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N3_COST', l_col17_val);
2054: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N3_AMG', l_col18_val);

Line 2051: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N2_CE', l_col15_val);

2047: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N1_AMG', l_col11_val);
2048: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N1_CE', l_col12_val);
2049: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N2_COST', l_col13_val);
2050: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N2_AMG', l_col14_val);
2051: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N2_CE', l_col15_val);
2052: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('N_TOI', l_col16_val);
2053: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N3_COST', l_col17_val);
2054: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N3_AMG', l_col18_val);
2055: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N3_CE', l_col19_val);

Line 2052: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('N_TOI', l_col16_val);

2048: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N1_CE', l_col12_val);
2049: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N2_COST', l_col13_val);
2050: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N2_AMG', l_col14_val);
2051: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N2_CE', l_col15_val);
2052: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('N_TOI', l_col16_val);
2053: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N3_COST', l_col17_val);
2054: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N3_AMG', l_col18_val);
2055: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N3_CE', l_col19_val);
2056: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N4_COST', l_col20_val);

Line 2053: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N3_COST', l_col17_val);

2049: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N2_COST', l_col13_val);
2050: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N2_AMG', l_col14_val);
2051: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N2_CE', l_col15_val);
2052: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('N_TOI', l_col16_val);
2053: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N3_COST', l_col17_val);
2054: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N3_AMG', l_col18_val);
2055: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N3_CE', l_col19_val);
2056: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N4_COST', l_col20_val);
2057: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N4_AMG', l_col21_val);

Line 2054: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N3_AMG', l_col18_val);

2050: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N2_AMG', l_col14_val);
2051: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N2_CE', l_col15_val);
2052: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('N_TOI', l_col16_val);
2053: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N3_COST', l_col17_val);
2054: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N3_AMG', l_col18_val);
2055: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N3_CE', l_col19_val);
2056: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N4_COST', l_col20_val);
2057: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N4_AMG', l_col21_val);
2058: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N4_CE', l_col22_val);

Line 2055: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N3_CE', l_col19_val);

2051: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N2_CE', l_col15_val);
2052: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('N_TOI', l_col16_val);
2053: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N3_COST', l_col17_val);
2054: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N3_AMG', l_col18_val);
2055: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N3_CE', l_col19_val);
2056: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N4_COST', l_col20_val);
2057: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N4_AMG', l_col21_val);
2058: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N4_CE', l_col22_val);
2059: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N5_COST', l_col23_val);

Line 2056: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N4_COST', l_col20_val);

2052: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('N_TOI', l_col16_val);
2053: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N3_COST', l_col17_val);
2054: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N3_AMG', l_col18_val);
2055: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N3_CE', l_col19_val);
2056: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N4_COST', l_col20_val);
2057: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N4_AMG', l_col21_val);
2058: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N4_CE', l_col22_val);
2059: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N5_COST', l_col23_val);
2060: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N5_AMG', l_col24_val);

Line 2057: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N4_AMG', l_col21_val);

2053: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N3_COST', l_col17_val);
2054: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N3_AMG', l_col18_val);
2055: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N3_CE', l_col19_val);
2056: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N4_COST', l_col20_val);
2057: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N4_AMG', l_col21_val);
2058: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N4_CE', l_col22_val);
2059: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N5_COST', l_col23_val);
2060: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N5_AMG', l_col24_val);
2061: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N5_CE', l_col25_val);

Line 2058: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N4_CE', l_col22_val);

2054: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N3_AMG', l_col18_val);
2055: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N3_CE', l_col19_val);
2056: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N4_COST', l_col20_val);
2057: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N4_AMG', l_col21_val);
2058: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N4_CE', l_col22_val);
2059: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N5_COST', l_col23_val);
2060: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N5_AMG', l_col24_val);
2061: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N5_CE', l_col25_val);
2062: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('N6_DESC', l_col26_val);

Line 2059: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N5_COST', l_col23_val);

2055: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N3_CE', l_col19_val);
2056: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N4_COST', l_col20_val);
2057: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N4_AMG', l_col21_val);
2058: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N4_CE', l_col22_val);
2059: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N5_COST', l_col23_val);
2060: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N5_AMG', l_col24_val);
2061: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N5_CE', l_col25_val);
2062: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('N6_DESC', l_col26_val);
2063: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N6_COST', l_col27_val);

Line 2060: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N5_AMG', l_col24_val);

2056: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N4_COST', l_col20_val);
2057: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N4_AMG', l_col21_val);
2058: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N4_CE', l_col22_val);
2059: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N5_COST', l_col23_val);
2060: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N5_AMG', l_col24_val);
2061: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N5_CE', l_col25_val);
2062: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('N6_DESC', l_col26_val);
2063: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N6_COST', l_col27_val);
2064: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N6_AMG', l_col28_val);

Line 2061: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N5_CE', l_col25_val);

2057: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N4_AMG', l_col21_val);
2058: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N4_CE', l_col22_val);
2059: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N5_COST', l_col23_val);
2060: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N5_AMG', l_col24_val);
2061: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N5_CE', l_col25_val);
2062: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('N6_DESC', l_col26_val);
2063: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N6_COST', l_col27_val);
2064: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N6_AMG', l_col28_val);
2065: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N6_CE', l_col29_val);

Line 2062: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('N6_DESC', l_col26_val);

2058: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N4_CE', l_col22_val);
2059: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N5_COST', l_col23_val);
2060: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N5_AMG', l_col24_val);
2061: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N5_CE', l_col25_val);
2062: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('N6_DESC', l_col26_val);
2063: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N6_COST', l_col27_val);
2064: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N6_AMG', l_col28_val);
2065: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N6_CE', l_col29_val);
2066: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('G_FCE', l_col30_val);

Line 2063: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N6_COST', l_col27_val);

2059: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N5_COST', l_col23_val);
2060: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N5_AMG', l_col24_val);
2061: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N5_CE', l_col25_val);
2062: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('N6_DESC', l_col26_val);
2063: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N6_COST', l_col27_val);
2064: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N6_AMG', l_col28_val);
2065: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N6_CE', l_col29_val);
2066: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('G_FCE', l_col30_val);
2067:

Line 2064: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N6_AMG', l_col28_val);

2060: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N5_AMG', l_col24_val);
2061: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N5_CE', l_col25_val);
2062: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('N6_DESC', l_col26_val);
2063: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N6_COST', l_col27_val);
2064: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N6_AMG', l_col28_val);
2065: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N6_CE', l_col29_val);
2066: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('G_FCE', l_col30_val);
2067:
2068: --

Line 2065: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N6_CE', l_col29_val);

2061: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N5_CE', l_col25_val);
2062: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('N6_DESC', l_col26_val);
2063: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N6_COST', l_col27_val);
2064: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N6_AMG', l_col28_val);
2065: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N6_CE', l_col29_val);
2066: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('G_FCE', l_col30_val);
2067:
2068: --
2069: SELECT action_information1, action_information2, action_information3, action_information4,

Line 2066: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('G_FCE', l_col30_val);

2062: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('N6_DESC', l_col26_val);
2063: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N6_COST', l_col27_val);
2064: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N6_AMG', l_col28_val);
2065: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N6_CE', l_col29_val);
2066: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('G_FCE', l_col30_val);
2067:
2068: --
2069: SELECT action_information1, action_information2, action_information3, action_information4,
2070: action_information5, action_information6, action_information7, action_information8,

Line 2086: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_BUS_MILES', l_col1_val);

2082: WHERE action_context_id = p_assignment_action_id AND
2083: action_information_category ='GB P11D ASSIGNMENT RESULTC'
2084: AND action_context_type = 'AAP';
2085:
2086: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_BUS_MILES', l_col1_val);
2087: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_BUS_MILES', l_col2_val);
2088: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_BUS_MILES', l_col3_val);
2089: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('C_RATE1','N',l_col4_val);
2090: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('C_RATE2','N',l_col5_val);

Line 2087: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_BUS_MILES', l_col2_val);

2083: action_information_category ='GB P11D ASSIGNMENT RESULTC'
2084: AND action_context_type = 'AAP';
2085:
2086: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_BUS_MILES', l_col1_val);
2087: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_BUS_MILES', l_col2_val);
2088: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_BUS_MILES', l_col3_val);
2089: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('C_RATE1','N',l_col4_val);
2090: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('C_RATE2','N',l_col5_val);
2091: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('M_RATE1','N',l_col6_val);

Line 2088: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_BUS_MILES', l_col3_val);

2084: AND action_context_type = 'AAP';
2085:
2086: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_BUS_MILES', l_col1_val);
2087: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_BUS_MILES', l_col2_val);
2088: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_BUS_MILES', l_col3_val);
2089: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('C_RATE1','N',l_col4_val);
2090: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('C_RATE2','N',l_col5_val);
2091: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('M_RATE1','N',l_col6_val);
2092: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('M_RATE2','N',l_col7_val);

Line 2089: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('C_RATE1','N',l_col4_val);

2085:
2086: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_BUS_MILES', l_col1_val);
2087: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_BUS_MILES', l_col2_val);
2088: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_BUS_MILES', l_col3_val);
2089: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('C_RATE1','N',l_col4_val);
2090: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('C_RATE2','N',l_col5_val);
2091: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('M_RATE1','N',l_col6_val);
2092: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('M_RATE2','N',l_col7_val);
2093: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('B_RATE1','N',l_col8_val);

Line 2090: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('C_RATE2','N',l_col5_val);

2086: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_BUS_MILES', l_col1_val);
2087: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_BUS_MILES', l_col2_val);
2088: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_BUS_MILES', l_col3_val);
2089: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('C_RATE1','N',l_col4_val);
2090: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('C_RATE2','N',l_col5_val);
2091: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('M_RATE1','N',l_col6_val);
2092: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('M_RATE2','N',l_col7_val);
2093: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('B_RATE1','N',l_col8_val);
2094: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('B_RATE2','N',l_col9_val);

Line 2091: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('M_RATE1','N',l_col6_val);

2087: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_BUS_MILES', l_col2_val);
2088: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_BUS_MILES', l_col3_val);
2089: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('C_RATE1','N',l_col4_val);
2090: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('C_RATE2','N',l_col5_val);
2091: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('M_RATE1','N',l_col6_val);
2092: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('M_RATE2','N',l_col7_val);
2093: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('B_RATE1','N',l_col8_val);
2094: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('B_RATE2','N',l_col9_val);
2095: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_MILEAGE_PAYMENTS', l_col12_val);

Line 2092: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('M_RATE2','N',l_col7_val);

2088: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_BUS_MILES', l_col3_val);
2089: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('C_RATE1','N',l_col4_val);
2090: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('C_RATE2','N',l_col5_val);
2091: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('M_RATE1','N',l_col6_val);
2092: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('M_RATE2','N',l_col7_val);
2093: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('B_RATE1','N',l_col8_val);
2094: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('B_RATE2','N',l_col9_val);
2095: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_MILEAGE_PAYMENTS', l_col12_val);
2096: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_MILEAGE_PAYMENTS', l_col13_val);

Line 2093: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('B_RATE1','N',l_col8_val);

2089: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('C_RATE1','N',l_col4_val);
2090: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('C_RATE2','N',l_col5_val);
2091: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('M_RATE1','N',l_col6_val);
2092: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('M_RATE2','N',l_col7_val);
2093: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('B_RATE1','N',l_col8_val);
2094: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('B_RATE2','N',l_col9_val);
2095: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_MILEAGE_PAYMENTS', l_col12_val);
2096: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_MILEAGE_PAYMENTS', l_col13_val);
2097: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_MILEAGE_PAYMENTS', l_col14_val);

Line 2094: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('B_RATE2','N',l_col9_val);

2090: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('C_RATE2','N',l_col5_val);
2091: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('M_RATE1','N',l_col6_val);
2092: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('M_RATE2','N',l_col7_val);
2093: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('B_RATE1','N',l_col8_val);
2094: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('B_RATE2','N',l_col9_val);
2095: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_MILEAGE_PAYMENTS', l_col12_val);
2096: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_MILEAGE_PAYMENTS', l_col13_val);
2097: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_MILEAGE_PAYMENTS', l_col14_val);
2098: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MARORS_COUNT', l_col15_val);

Line 2095: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_MILEAGE_PAYMENTS', l_col12_val);

2091: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('M_RATE1','N',l_col6_val);
2092: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('M_RATE2','N',l_col7_val);
2093: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('B_RATE1','N',l_col8_val);
2094: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('B_RATE2','N',l_col9_val);
2095: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_MILEAGE_PAYMENTS', l_col12_val);
2096: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_MILEAGE_PAYMENTS', l_col13_val);
2097: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_MILEAGE_PAYMENTS', l_col14_val);
2098: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MARORS_COUNT', l_col15_val);
2099: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_TAX_DEDUCTED', l_col16_val);

Line 2096: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_MILEAGE_PAYMENTS', l_col13_val);

2092: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('M_RATE2','N',l_col7_val);
2093: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('B_RATE1','N',l_col8_val);
2094: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('B_RATE2','N',l_col9_val);
2095: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_MILEAGE_PAYMENTS', l_col12_val);
2096: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_MILEAGE_PAYMENTS', l_col13_val);
2097: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_MILEAGE_PAYMENTS', l_col14_val);
2098: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MARORS_COUNT', l_col15_val);
2099: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_TAX_DEDUCTED', l_col16_val);
2100: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_TAX_DEDUCTED', l_col17_val);

Line 2097: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_MILEAGE_PAYMENTS', l_col14_val);

2093: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('B_RATE1','N',l_col8_val);
2094: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('B_RATE2','N',l_col9_val);
2095: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_MILEAGE_PAYMENTS', l_col12_val);
2096: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_MILEAGE_PAYMENTS', l_col13_val);
2097: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_MILEAGE_PAYMENTS', l_col14_val);
2098: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MARORS_COUNT', l_col15_val);
2099: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_TAX_DEDUCTED', l_col16_val);
2100: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_TAX_DEDUCTED', l_col17_val);
2101: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_TAX_DEDUCTED', l_col18_val);

Line 2098: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MARORS_COUNT', l_col15_val);

2094: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('B_RATE2','N',l_col9_val);
2095: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_MILEAGE_PAYMENTS', l_col12_val);
2096: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_MILEAGE_PAYMENTS', l_col13_val);
2097: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_MILEAGE_PAYMENTS', l_col14_val);
2098: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MARORS_COUNT', l_col15_val);
2099: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_TAX_DEDUCTED', l_col16_val);
2100: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_TAX_DEDUCTED', l_col17_val);
2101: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_TAX_DEDUCTED', l_col18_val);
2102: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_PAYMENTS', l_col19_val);

Line 2099: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_TAX_DEDUCTED', l_col16_val);

2095: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_MILEAGE_PAYMENTS', l_col12_val);
2096: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_MILEAGE_PAYMENTS', l_col13_val);
2097: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_MILEAGE_PAYMENTS', l_col14_val);
2098: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MARORS_COUNT', l_col15_val);
2099: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_TAX_DEDUCTED', l_col16_val);
2100: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_TAX_DEDUCTED', l_col17_val);
2101: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_TAX_DEDUCTED', l_col18_val);
2102: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_PAYMENTS', l_col19_val);
2103: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_BUS_MILES', l_col20_val);

Line 2100: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_TAX_DEDUCTED', l_col17_val);

2096: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_MILEAGE_PAYMENTS', l_col13_val);
2097: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_MILEAGE_PAYMENTS', l_col14_val);
2098: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MARORS_COUNT', l_col15_val);
2099: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_TAX_DEDUCTED', l_col16_val);
2100: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_TAX_DEDUCTED', l_col17_val);
2101: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_TAX_DEDUCTED', l_col18_val);
2102: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_PAYMENTS', l_col19_val);
2103: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_BUS_MILES', l_col20_val);
2104: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_BUS_MILE_AMT', l_col21_val);

Line 2101: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_TAX_DEDUCTED', l_col18_val);

2097: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_MILEAGE_PAYMENTS', l_col14_val);
2098: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MARORS_COUNT', l_col15_val);
2099: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_TAX_DEDUCTED', l_col16_val);
2100: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_TAX_DEDUCTED', l_col17_val);
2101: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_TAX_DEDUCTED', l_col18_val);
2102: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_PAYMENTS', l_col19_val);
2103: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_BUS_MILES', l_col20_val);
2104: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_BUS_MILE_AMT', l_col21_val);
2105: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MILEAGE_ALLOWANCE_RELIEF', l_col22_val);

Line 2102: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_PAYMENTS', l_col19_val);

2098: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MARORS_COUNT', l_col15_val);
2099: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_TAX_DEDUCTED', l_col16_val);
2100: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_TAX_DEDUCTED', l_col17_val);
2101: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_TAX_DEDUCTED', l_col18_val);
2102: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_PAYMENTS', l_col19_val);
2103: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_BUS_MILES', l_col20_val);
2104: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_BUS_MILE_AMT', l_col21_val);
2105: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MILEAGE_ALLOWANCE_RELIEF', l_col22_val);
2106: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('INT_MAX_AMT_OUTSTANDING', l_col23_val);

Line 2103: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_BUS_MILES', l_col20_val);

2099: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_TAX_DEDUCTED', l_col16_val);
2100: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_TAX_DEDUCTED', l_col17_val);
2101: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_TAX_DEDUCTED', l_col18_val);
2102: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_PAYMENTS', l_col19_val);
2103: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_BUS_MILES', l_col20_val);
2104: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_BUS_MILE_AMT', l_col21_val);
2105: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MILEAGE_ALLOWANCE_RELIEF', l_col22_val);
2106: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('INT_MAX_AMT_OUTSTANDING', l_col23_val);
2107: end if;

Line 2104: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_BUS_MILE_AMT', l_col21_val);

2100: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_TAX_DEDUCTED', l_col17_val);
2101: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_TAX_DEDUCTED', l_col18_val);
2102: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_PAYMENTS', l_col19_val);
2103: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_BUS_MILES', l_col20_val);
2104: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_BUS_MILE_AMT', l_col21_val);
2105: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MILEAGE_ALLOWANCE_RELIEF', l_col22_val);
2106: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('INT_MAX_AMT_OUTSTANDING', l_col23_val);
2107: end if;
2108:

Line 2105: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MILEAGE_ALLOWANCE_RELIEF', l_col22_val);

2101: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_TAX_DEDUCTED', l_col18_val);
2102: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_PAYMENTS', l_col19_val);
2103: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_BUS_MILES', l_col20_val);
2104: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_BUS_MILE_AMT', l_col21_val);
2105: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MILEAGE_ALLOWANCE_RELIEF', l_col22_val);
2106: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('INT_MAX_AMT_OUTSTANDING', l_col23_val);
2107: end if;
2108:
2109: END;

Line 2106: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('INT_MAX_AMT_OUTSTANDING', l_col23_val);

2102: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_PAYMENTS', l_col19_val);
2103: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_BUS_MILES', l_col20_val);
2104: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_BUS_MILE_AMT', l_col21_val);
2105: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MILEAGE_ALLOWANCE_RELIEF', l_col22_val);
2106: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('INT_MAX_AMT_OUTSTANDING', l_col23_val);
2107: end if;
2108:
2109: END;
2110: