DBA Data[Home] [Help]

APPS.PY_ZA_TX_UTL_01032000 dependencies on PAY_USER_TABLES

Line 1305: ( p_TableName IN pay_user_tables.user_table_name%TYPE

1301: RAISE py_za_tx_01032000.xpt_E;
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

Line 1319: , pay_user_tables put

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'
1322: AND puc.user_table_id = put.user_table_id
1323: AND puc.legislation_code = 'ZA'