APPS.PY_ZA_TX_UTL_01032005 dependencies on PAY_USER_TABLES

Line 1902: ( p_TableName IN pay_user_tables.user_table_name%TYPE

1898: -------------------------------------------------------------------------------
1899: -- GetTableValue --
1900: -------------------------------------------------------------------------------
1901: FUNCTION GetTableValue
1902: ( p_TableName IN pay_user_tables.user_table_name%TYPE
1903: , p_ColumnName IN pay_user_columns.user_column_name%TYPE
1904: , p_RowValue IN NUMBER
1905: , p_EffectiveDate IN DATE
1906: ) RETURN VARCHAR2

Line 1910: l_UserTableID pay_user_tables.user_table_id%TYPE;

1906: ) RETURN VARCHAR2
1907: AS
1908: -- Variables
1909: --
1910: l_UserTableID pay_user_tables.user_table_id%TYPE;
1911: l_ColumnID pay_user_columns.user_column_id%TYPE;
1912: l_RowID pay_user_rows_f.user_row_id%TYPE;
1913: l_TableValue pay_user_column_instances_f.value%TYPE;
1914: BEGIN

Line 1920: from pay_user_tables put

1916: -- Get the user_table_id
1917: --
1918: select put.user_table_id
1919: INTO l_UserTableID
1920: from pay_user_tables put
1921: where upper(put.user_table_name) = upper(p_TableName)
1922: AND put.legislation_code = 'ZA';
1923:
1924: hr_utility.set_location('py_za_tx_utl_01032005.GetTableValue',2);

Line 1940: from pay_user_tables put

1936: -- Get the user_row_id
1937: --
1938: select pur.user_row_id
1939: INTO l_RowID
1940: from pay_user_tables put
1941: , pay_user_rows_f pur
1942: where put.user_table_id = l_UserTableID
1943: and pur.user_table_id = put.user_table_id
1944: AND pur.row_high_range IS NOT NULL