APPS.PY_ZA_TX_UTL_01032013 dependencies on PAY_USER_COLUMNS

Line 2680: , p_ColumnName IN pay_user_columns.user_column_name%TYPE

2676: -- GetTableValue --
2677: -------------------------------------------------------------------------------
2678: FUNCTION GetTableValue
2679: ( p_TableName IN pay_user_tables.user_table_name%TYPE
2680: , p_ColumnName IN pay_user_columns.user_column_name%TYPE
2681: , p_RowValue IN NUMBER
2682: , p_EffectiveDate IN DATE
2683: ) RETURN VARCHAR2
2684: AS

Line 2688: l_ColumnID pay_user_columns.user_column_id%TYPE;

2684: AS
2685: -- Variables
2686: --
2687: l_UserTableID pay_user_tables.user_table_id%TYPE;
2688: l_ColumnID pay_user_columns.user_column_id%TYPE;
2689: l_RowID pay_user_rows_f.user_row_id%TYPE;
2690: l_TableValue pay_user_column_instances_f.value%TYPE;
2691: BEGIN
2692: hr_utility.set_location('py_za_tx_utl_01032013.GetTableValue',1);

Line 2706: from pay_user_columns puc

2702: -- Get the user_column_id
2703: --
2704: select puc.user_column_id
2705: INTO l_ColumnID
2706: from pay_user_columns puc
2707: where puc.user_table_id = l_UserTableID
2708: AND puc.legislation_code = 'ZA'
2709: and puc.business_group_id is null
2710: AND upper(puc.user_column_name) = upper(p_ColumnName);