DBA Data[Home] [Help]

APPS.PY_ZA_TX_UTL_01082000 dependencies on PAY_USER_TABLES

Line 2028: ( p_TableName IN pay_user_tables.user_table_name%TYPE

2024: RAISE py_za_tx_01082000.xpt_E;
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

Line 2042: , pay_user_tables put

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