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

Line 1306: , p_ColumnName IN pay_user_columns.user_column_name%TYPE

1302: END ArrearExcess;
1303:
1304: FUNCTION GetTableValue
1305: ( p_TableName IN pay_user_tables.user_table_name%TYPE
1306: , p_ColumnName IN pay_user_columns.user_column_name%TYPE
1307: , p_RowValue IN NUMBER
1308: , p_EffectiveDate IN DATE
1309: ) RETURN VARCHAR2
1310: AS

Line 1317: , pay_user_columns puc

1313:
1314: SELECT pucif.value
1315: INTO l_TableValue
1316: FROM pay_user_column_instances_f pucif
1317: , pay_user_columns puc
1318: , pay_user_rows_f pur
1319: , pay_user_tables put
1320: WHERE upper(put.user_table_name) = upper(p_TableName)
1321: AND put.legislation_code = 'ZA'