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_UTL_01082000 dependencies on PAY_USER_COLUMNS

Line 2029: , p_ColumnName IN pay_user_columns.user_column_name%TYPE

2025: END ArrearExcess;
2026:
2027: FUNCTION GetTableValue
2028: ( p_TableName IN pay_user_tables.user_table_name%TYPE
2029: , p_ColumnName IN pay_user_columns.user_column_name%TYPE
2030: , p_RowValue IN NUMBER
2031: , p_EffectiveDate IN DATE
2032: ) RETURN VARCHAR2
2033: AS

Line 2040: , pay_user_columns puc

2036:
2037: SELECT pucif.value
2038: INTO l_TableValue
2039: FROM pay_user_column_instances_f pucif
2040: , pay_user_columns puc
2041: , pay_user_rows_f pur
2042: , pay_user_tables put
2043: WHERE upper(put.user_table_name) = upper(p_TableName)
2044: AND put.legislation_code = 'ZA'