APPS.PAY_SE_POPULATE_COUNTRIES dependencies on PAY_USER_COLUMNS

Line 48: l_user_column_id PAY_USER_COLUMNS.USER_COLUMN_ID%type;

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;
52: l_user_column_instance_id NUMBER;

Line 74: FROM pay_user_columns

70: -- Get the Column ID for the Table PER DIEM OVERSEAS NORMAL AMOUNT
71: --
72: SELECT user_column_id
73: INTO l_user_column_id
74: FROM pay_user_columns
75: WHERE user_column_name='NORMAL_AMOUNT'
76: AND legislation_code='SE';
77:
78: FOR tc_rec IN c_update_territory(p_business_group_id,l_user_table_id)