DBA Data[Home] [Help]

APPS.PY_ZA_TX dependencies on PAY_USER_TABLES

Line 14: l_user_table_id pay_user_tables.user_table_id%TYPE;

10:
11: AS
12:
13: l_effective_date DATE;
14: l_user_table_id pay_user_tables.user_table_id%TYPE;
15: l_fixed_column_id pay_user_columns.user_column_id%TYPE;
16: l_limit_column_id pay_user_columns.user_column_id%TYPE;
17: l_percentage_column_id pay_user_columns.user_column_id%TYPE;
18: l_bracket_row pay_user_rows_f.user_row_id%TYPE;

Line 40: from pay_user_tables

36:
37: /* Selects to get the relevant id's */
38: select user_table_id
39: into l_user_table_id
40: from pay_user_tables
41: where user_table_name = 'ZA_TAX_TABLE';
42:
43: select user_column_id
44: into l_fixed_column_id