APPS.PY_ZA_TX_UTL_01032004 dependencies on PAY_USER_TABLES

Line 2362: ( p_TableName IN pay_user_tables.user_table_name%TYPE

2358: -------------------------------------------------------------------------------
2359: -- GetTableValue --
2360: -------------------------------------------------------------------------------
2361: FUNCTION GetTableValue
2362: ( p_TableName IN pay_user_tables.user_table_name%TYPE
2363: , p_ColumnName IN pay_user_columns.user_column_name%TYPE
2364: , p_RowValue IN NUMBER
2365: , p_EffectiveDate IN DATE
2366: ) RETURN VARCHAR2

Line 2370: l_UserTableID pay_user_tables.user_table_id%TYPE;

2366: ) RETURN VARCHAR2
2367: AS
2368: -- Variables
2369: --
2370: l_UserTableID pay_user_tables.user_table_id%TYPE;
2371: l_ColumnID pay_user_columns.user_column_id%TYPE;
2372: l_RowID pay_user_rows_f.user_row_id%TYPE;
2373: l_TableValue pay_user_column_instances_f.value%TYPE;
2374: BEGIN

Line 2380: from pay_user_tables put

2376: -- Get the user_table_id
2377: --
2378: select put.user_table_id
2379: INTO l_UserTableID
2380: from pay_user_tables put
2381: where upper(put.user_table_name) = upper(p_TableName)
2382: AND put.legislation_code = 'ZA';
2383:
2384: hr_utility.set_location('py_za_tx_utl_01032004.GetTableValue',2);

Line 2400: from pay_user_tables put

2396: -- Get the user_row_id
2397: --
2398: select pur.user_row_id
2399: INTO l_RowID
2400: from pay_user_tables put
2401: , pay_user_rows_f pur
2402: where put.user_table_id = l_UserTableID
2403: and pur.user_table_id = put.user_table_id
2404: AND pur.row_high_range IS NOT NULL