APPS.PY_ZA_TX dependencies on PAY_USER_COLUMNS

Line 15: l_fixed_column_id pay_user_columns.user_column_id%TYPE;

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;
19: l_fixed pay_user_column_instances_f.value%TYPE;

Line 16: l_limit_column_id pay_user_columns.user_column_id%TYPE;

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;
19: l_fixed pay_user_column_instances_f.value%TYPE;
20: l_limit pay_user_column_instances_f.value%TYPE;

Line 17: l_percentage_column_id pay_user_columns.user_column_id%TYPE;

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;
19: l_fixed pay_user_column_instances_f.value%TYPE;
20: l_limit pay_user_column_instances_f.value%TYPE;
21: l_percentage pay_user_column_instances_f.value%TYPE;

Line 45: from pay_user_columns

41: where user_table_name = 'ZA_TAX_TABLE';
42:
43: select user_column_id
44: into l_fixed_column_id
45: from pay_user_columns
46: where user_table_id = l_user_table_id
47: and user_column_name = 'Fixed';
48:
49: select user_column_id

Line 51: from pay_user_columns

47: and user_column_name = 'Fixed';
48:
49: select user_column_id
50: into l_limit_column_id
51: from pay_user_columns
52: where user_table_id = l_user_table_id
53: and user_column_name = 'Limit';
54:
55: select user_column_id

Line 57: from pay_user_columns

53: and user_column_name = 'Limit';
54:
55: select user_column_id
56: into l_percentage_column_id
57: from pay_user_columns
58: where user_table_id = l_user_table_id
59: and user_column_name = 'Percentage';
60:
61: select purf.user_row_id