DBA Data[Home] [Help]

APPS.PER_FI_POPULATE_COUNTRIES dependencies on PAY_USER_TABLES

Line 47: l_user_table_id PAY_USER_TABLES.USER_TABLE_ID%type;

43: -- Local variables declared.
44: --
45: l_region_code FND_TERRITORIES_TL.TERRITORY_CODE%type;
46: l_region_name FND_TERRITORIES_TL.TERRITORY_SHORT_NAME%type;
47: l_user_table_id PAY_USER_TABLES.USER_TABLE_ID%type;
48: l_user_column_id PAY_USER_COLUMNS.USER_COLUMN_ID%type;
49: l_row_id NUMBER;
50: l_row_id1 VARCHAR2(4000);
51: l_user_row_id NUMBER;

Line 67: FROM pay_user_tables

63: -- Get the Table ID for the Table FI_REGIONAL_MEMBERSHIP
64: --
65: SELECT user_table_id
66: INTO l_user_table_id
67: FROM pay_user_tables
68: WHERE user_table_name='FI_REGIONAL_MEMBERSHIP'
69: AND legislation_code='FI';
70:
71: -- Get the Column ID for the Table FI_REGIONAL_MEMBERSHIP