APPS.PY_ZA_TX_UTL_01032002 dependencies on PAY_USER_COLUMNS

Line 1849: , p_ColumnName IN pay_user_columns.user_column_name%TYPE

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
1853: AS

Line 1857: l_ColumnID pay_user_columns.user_column_id%TYPE;

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
1861: hr_utility.set_location('py_za_tx_utl_01032002.GetTableValue',1);

Line 1875: from pay_user_columns puc

1871: -- Get the user_column_id
1872: --
1873: select puc.user_column_id
1874: INTO l_ColumnID
1875: from pay_user_columns puc
1876: where puc.user_table_id = l_UserTableID
1877: AND puc.legislation_code = 'ZA'
1878: and puc.business_group_id is null
1879: AND upper(puc.user_column_name) = upper(p_ColumnName);