APPS.PY_ZA_TX_UTL_01032002 dependencies on PAY_USER_TABLES

Line 1848: ( p_TableName IN pay_user_tables.user_table_name%TYPE

1844: -------------------------------------------------------------------------------
1845: -- GetTableValue --
1846: -------------------------------------------------------------------------------
1847: FUNCTION GetTableValue
1848: ( p_TableName IN pay_user_tables.user_table_name%TYPE
1849: , p_ColumnName IN pay_user_columns.user_column_name%TYPE
1850: , p_RowValue IN NUMBER
1851: , p_EffectiveDate IN DATE
1852: ) RETURN VARCHAR2

Line 1856: l_UserTableID pay_user_tables.user_table_id%TYPE;

1852: ) RETURN VARCHAR2
1853: AS
1854: -- Variables
1855: --
1856: l_UserTableID pay_user_tables.user_table_id%TYPE;
1857: l_ColumnID pay_user_columns.user_column_id%TYPE;
1858: l_RowID pay_user_rows_f.user_row_id%TYPE;
1859: l_TableValue pay_user_column_instances_f.value%TYPE;
1860: BEGIN

Line 1866: from pay_user_tables put

1862: -- Get the user_table_id
1863: --
1864: select put.user_table_id
1865: INTO l_UserTableID
1866: from pay_user_tables put
1867: where upper(put.user_table_name) = upper(p_TableName)
1868: AND put.legislation_code = 'ZA';
1869:
1870: hr_utility.set_location('py_za_tx_utl_01032002.GetTableValue',2);

Line 1886: from pay_user_tables put

1882: -- Get the user_row_id
1883: --
1884: select pur.user_row_id
1885: INTO l_RowID
1886: from pay_user_tables put
1887: , pay_user_rows_f pur
1888: where put.user_table_id = l_UserTableID
1889: and pur.user_table_id = put.user_table_id
1890: AND pur.row_high_range IS NOT NULL