APPS.PY_ZA_TX_UTL_01032011 dependencies on PAY_USER_TABLES

Line 2582: ( p_TableName IN pay_user_tables.user_table_name%TYPE

2578: -------------------------------------------------------------------------------
2579: -- GetTableValue --
2580: -------------------------------------------------------------------------------
2581: FUNCTION GetTableValue
2582: ( p_TableName IN pay_user_tables.user_table_name%TYPE
2583: , p_ColumnName IN pay_user_columns.user_column_name%TYPE
2584: , p_RowValue IN NUMBER
2585: , p_EffectiveDate IN DATE
2586: ) RETURN VARCHAR2

Line 2590: l_UserTableID pay_user_tables.user_table_id%TYPE;

2586: ) RETURN VARCHAR2
2587: AS
2588: -- Variables
2589: --
2590: l_UserTableID pay_user_tables.user_table_id%TYPE;
2591: l_ColumnID pay_user_columns.user_column_id%TYPE;
2592: l_RowID pay_user_rows_f.user_row_id%TYPE;
2593: l_TableValue pay_user_column_instances_f.value%TYPE;
2594: BEGIN

Line 2600: from pay_user_tables put

2596: -- Get the user_table_id
2597: --
2598: select put.user_table_id
2599: INTO l_UserTableID
2600: from pay_user_tables put
2601: where upper(put.user_table_name) = upper(p_TableName)
2602: AND put.legislation_code = 'ZA';
2603:
2604: hr_utility.set_location('py_za_tx_utl_01032011.GetTableValue',2);

Line 2620: from pay_user_tables put

2616: -- Get the user_row_id
2617: --
2618: select pur.user_row_id
2619: INTO l_RowID
2620: from pay_user_tables put
2621: , pay_user_rows_f pur
2622: where put.user_table_id = l_UserTableID
2623: and pur.user_table_id = put.user_table_id
2624: AND pur.row_high_range IS NOT NULL