APPS.PY_ZA_TX_UTL_01032012 dependencies on PAY_USER_COLUMNS

Line 2628: , p_ColumnName IN pay_user_columns.user_column_name%TYPE

2624: -- GetTableValue --
2625: -------------------------------------------------------------------------------
2626: FUNCTION GetTableValue
2627: ( p_TableName IN pay_user_tables.user_table_name%TYPE
2628: , p_ColumnName IN pay_user_columns.user_column_name%TYPE
2629: , p_RowValue IN NUMBER
2630: , p_EffectiveDate IN DATE
2631: ) RETURN VARCHAR2
2632: AS

Line 2636: l_ColumnID pay_user_columns.user_column_id%TYPE;

2632: AS
2633: -- Variables
2634: --
2635: l_UserTableID pay_user_tables.user_table_id%TYPE;
2636: l_ColumnID pay_user_columns.user_column_id%TYPE;
2637: l_RowID pay_user_rows_f.user_row_id%TYPE;
2638: l_TableValue pay_user_column_instances_f.value%TYPE;
2639: BEGIN
2640: hr_utility.set_location('py_za_tx_utl_01032012.GetTableValue',1);

Line 2654: from pay_user_columns puc

2650: -- Get the user_column_id
2651: --
2652: select puc.user_column_id
2653: INTO l_ColumnID
2654: from pay_user_columns puc
2655: where puc.user_table_id = l_UserTableID
2656: AND puc.legislation_code = 'ZA'
2657: and puc.business_group_id is null
2658: AND upper(puc.user_column_name) = upper(p_ColumnName);