[Home] [Help]
875: p_seq_no in out nocopy number) is
876: --
877: CURSOR c_find_row_values IS
878: SELECT puci.value intval
879: FROM pay_user_rows pur,
880: pay_user_columns puc,
881: pay_user_tables put,
882: pay_user_column_instances puci
883: WHERE put.user_table_name = g_user_table_name
1890: --
1891: CURSOR c_selected_balances IS
1892: SELECT pur.row_low_range_or_name row_name,
1893: puci.value user_desc
1894: FROM pay_user_rows pur,
1895: pay_user_columns puc,
1896: pay_user_tables put,
1897: pay_user_column_instances puci
1898: WHERE put.user_table_name = g_user_table_name
2682: open c_find_table_id;
2683: fetch c_find_table_id into l_user_table_id;
2684: close c_find_table_id;
2685:
2686: select pay_user_rows_s.nextval into l_user_row_id
2687: from dual;
2688:
2689: if p_business_group_id is null
2690: then
2705: then
2706: -- message('SOE Balances has not been updated');
2707: null;
2708: else
2709: insert into PAY_USER_ROWS_F
2710: (USER_ROW_ID,
2711: EFFECTIVE_START_DATE,
2712: EFFECTIVE_END_DATE,
2713: BUSINESS_GROUP_ID,
2745: and put.legislation_code = 'GB';
2746:
2747: cursor c_check_row_exists(l_user_table_id number) is
2748: select 1
2749: from pay_user_rows_f pur,
2750: pay_balance_dimensions pbd
2751: where pur.row_low_range_or_name =
2752: p_balance_name ||
2753: replace(pbd.database_item_suffix,pbd.database_item_suffix,