eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PY_ZA_TX_01011001 dependencies on PAY_USER_COLUMN_INSTANCES_F

Line 1479: l_fixed pay_user_column_instances_f.value%TYPE;

1475: l_fixed_column_id pay_user_columns.user_column_id%TYPE;
1476: l_limit_column_id pay_user_columns.user_column_id%TYPE;
1477: l_percentage_column_id pay_user_columns.user_column_id%TYPE;
1478: l_bracket_row pay_user_rows_f.user_row_id%TYPE;
1479: l_fixed pay_user_column_instances_f.value%TYPE;
1480: l_limit pay_user_column_instances_f.value%TYPE;
1481: l_percentage pay_user_column_instances_f.value%TYPE;
1482: l_effective_date pay_payroll_actions.effective_date%TYPE;
1483: tax_liability NUMBER(15,2);

Line 1480: l_limit pay_user_column_instances_f.value%TYPE;

1476: l_limit_column_id pay_user_columns.user_column_id%TYPE;
1477: l_percentage_column_id pay_user_columns.user_column_id%TYPE;
1478: l_bracket_row pay_user_rows_f.user_row_id%TYPE;
1479: l_fixed pay_user_column_instances_f.value%TYPE;
1480: l_limit pay_user_column_instances_f.value%TYPE;
1481: l_percentage pay_user_column_instances_f.value%TYPE;
1482: l_effective_date pay_payroll_actions.effective_date%TYPE;
1483: tax_liability NUMBER(15,2);
1484: l_TxbAmt NUMBER(15,2);

Line 1481: l_percentage pay_user_column_instances_f.value%TYPE;

1477: l_percentage_column_id pay_user_columns.user_column_id%TYPE;
1478: l_bracket_row pay_user_rows_f.user_row_id%TYPE;
1479: l_fixed pay_user_column_instances_f.value%TYPE;
1480: l_limit pay_user_column_instances_f.value%TYPE;
1481: l_percentage pay_user_column_instances_f.value%TYPE;
1482: l_effective_date pay_payroll_actions.effective_date%TYPE;
1483: tax_liability NUMBER(15,2);
1484: l_TxbAmt NUMBER(15,2);
1485:

Line 1543: from pay_user_column_instances_f pucif

1539:
1540: /* Selects to get the actual values */
1541: select pucif.value
1542: into l_fixed
1543: from pay_user_column_instances_f pucif
1544: where pucif.user_row_id = l_bracket_row
1545: and (l_effective_date >= pucif.effective_start_date
1546: and l_effective_date <= pucif.effective_end_date)
1547: and pucif.user_column_id = l_fixed_column_id;

Line 1551: from pay_user_column_instances_f pucif

1547: and pucif.user_column_id = l_fixed_column_id;
1548:
1549: select pucif.value
1550: into l_limit
1551: from pay_user_column_instances_f pucif
1552: where pucif.user_row_id = l_bracket_row
1553: and (l_effective_date >= pucif.effective_start_date
1554: and l_effective_date <= pucif.effective_end_date)
1555: and pucif.user_column_id = l_limit_column_id;

Line 1559: from pay_user_column_instances_f pucif

1555: and pucif.user_column_id = l_limit_column_id;
1556:
1557: select pucif.value
1558: into l_percentage
1559: from pay_user_column_instances_f pucif
1560: where pucif.user_row_id = l_bracket_row
1561: and (l_effective_date >= pucif.effective_start_date
1562: and l_effective_date <= pucif.effective_end_date)
1563: and pucif.user_column_id = l_percentage_column_id;