APPS.PAY_GB_PAYROLL_ACTIONS_PKG dependencies on PAY_USER_ROWS

Line 896: FROM pay_user_rows pur,

892: p_seq_no in out nocopy number) is
893: --
894: CURSOR c_find_row_values IS
895: SELECT puci.value intval
896: FROM pay_user_rows pur,
897: pay_user_columns puc,
898: pay_user_tables put,
899: pay_user_column_instances puci
900: WHERE put.user_table_name = g_user_table_name

Line 1919: FROM pay_user_rows pur,

1915: --
1916: CURSOR c_selected_balances IS
1917: SELECT pur.row_low_range_or_name row_name,
1918: puci.value user_desc
1919: FROM pay_user_rows pur,
1920: pay_user_columns puc,
1921: pay_user_tables put,
1922: pay_user_column_instances puci
1923: WHERE put.user_table_name = g_user_table_name

Line 2353: FROM pay_user_rows pur,

2349: --
2350: CURSOR c_selected_balances IS
2351: SELECT pur.row_low_range_or_name row_name,
2352: puci.value user_desc
2353: FROM pay_user_rows pur,
2354: pay_user_columns puc,
2355: pay_user_tables put,
2356: pay_user_column_instances puci
2357: WHERE put.user_table_name = g_user_table_name

Line 3087: select pay_user_rows_s.nextval into l_user_row_id

3083: open c_find_table_id;
3084: fetch c_find_table_id into l_user_table_id;
3085: close c_find_table_id;
3086:
3087: select pay_user_rows_s.nextval into l_user_row_id
3088: from dual;
3089:
3090: if p_business_group_id is null
3091: then

Line 3110: insert into PAY_USER_ROWS_F

3106: then
3107: -- message('SOE Balances has not been updated');
3108: null;
3109: else
3110: insert into PAY_USER_ROWS_F
3111: (USER_ROW_ID,
3112: EFFECTIVE_START_DATE,
3113: EFFECTIVE_END_DATE,
3114: BUSINESS_GROUP_ID,

Line 3150: from pay_user_rows_f pur,

3146: and put.legislation_code = 'GB';
3147:
3148: cursor c_check_row_exists(l_user_table_id number) is
3149: select 1
3150: from pay_user_rows_f pur,
3151: pay_balance_dimensions pbd
3152: where pur.row_low_range_or_name =
3153: p_balance_name ||
3154: replace(pbd.database_item_suffix,pbd.database_item_suffix,