DBA Data[Home] [Help]

APPS.PAY_SE_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 66: FROM pay_user_tables

62: -- Get the Table ID for the Table PER DIEM OVERSEAS NORMAL AMOUNT
63: --
64: SELECT user_table_id
65: INTO l_user_table_id
66: FROM pay_user_tables
67: WHERE user_table_name='PER DIEM OVERSEAS NORMAL AMOUNT'
68: AND legislation_code='SE';
69:
70: -- Get the Column ID for the Table PER DIEM OVERSEAS NORMAL AMOUNT