APPS.PY_ZA_TX_UTL_01032009 dependencies on PAY_USER_COLUMNS

Line 2568: , p_ColumnName IN pay_user_columns.user_column_name%TYPE

2564: -- GetTableValue --
2565: -------------------------------------------------------------------------------
2566: FUNCTION GetTableValue
2567: ( p_TableName IN pay_user_tables.user_table_name%TYPE
2568: , p_ColumnName IN pay_user_columns.user_column_name%TYPE
2569: , p_RowValue IN NUMBER
2570: , p_EffectiveDate IN DATE
2571: ) RETURN VARCHAR2
2572: AS

Line 2576: l_ColumnID pay_user_columns.user_column_id%TYPE;

2572: AS
2573: -- Variables
2574: --
2575: l_UserTableID pay_user_tables.user_table_id%TYPE;
2576: l_ColumnID pay_user_columns.user_column_id%TYPE;
2577: l_RowID pay_user_rows_f.user_row_id%TYPE;
2578: l_TableValue pay_user_column_instances_f.value%TYPE;
2579: BEGIN
2580: hr_utility.set_location('py_za_tx_utl_01032009.GetTableValue',1);

Line 2594: from pay_user_columns puc

2590: -- Get the user_column_id
2591: --
2592: select puc.user_column_id
2593: INTO l_ColumnID
2594: from pay_user_columns puc
2595: where puc.user_table_id = l_UserTableID
2596: AND puc.legislation_code = 'ZA'
2597: and puc.business_group_id is null
2598: AND upper(puc.user_column_name) = upper(p_ColumnName);