APPS.PY_ZA_TX dependencies on PAY_USER_COLUMN_INSTANCES_F

Line 19: l_fixed pay_user_column_instances_f.value%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;
22: tax_liability NUMBER;
23: l_id NUMBER;

Line 20: l_limit pay_user_column_instances_f.value%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;
22: tax_liability NUMBER;
23: l_id NUMBER;
24:

Line 21: l_percentage pay_user_column_instances_f.value%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;
22: tax_liability NUMBER;
23: l_id NUMBER;
24:
25:

Line 73: from pay_user_column_instances_f pucif

69:
70: /* Selects to get the actual values */
71: select pucif.value
72: into l_fixed
73: from pay_user_column_instances_f pucif
74: where pucif.user_row_id = l_bracket_row
75: and (l_effective_date >= pucif.effective_start_date
76: and l_effective_date <= pucif.effective_end_date)
77: and pucif.user_column_id = l_fixed_column_id;

Line 81: from pay_user_column_instances_f pucif

77: and pucif.user_column_id = l_fixed_column_id;
78:
79: select pucif.value
80: into l_limit
81: from pay_user_column_instances_f pucif
82: where pucif.user_row_id = l_bracket_row
83: and (l_effective_date >= pucif.effective_start_date
84: and l_effective_date <= pucif.effective_end_date)
85: and pucif.user_column_id = l_limit_column_id;

Line 89: from pay_user_column_instances_f pucif

85: and pucif.user_column_id = l_limit_column_id;
86:
87: select pucif.value
88: into l_percentage
89: from pay_user_column_instances_f pucif
90: where pucif.user_row_id = l_bracket_row
91: and (l_effective_date >= pucif.effective_start_date
92: and l_effective_date <= pucif.effective_end_date)
93: and pucif.user_column_id = l_percentage_column_id;