DBA Data[Home] [Help]

APPS.PER_FI_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 75: FROM pay_user_columns

71: -- Get the Column ID for the Table FI_REGIONAL_MEMBERSHIP
72: --
73: SELECT user_column_id
74: INTO l_user_column_id
75: FROM pay_user_columns
76: WHERE user_column_name='REGIONAL MEMBERSHIP'
77: AND legislation_code='FI';
78:
79: FOR tc_rec IN c_update_territory(p_business_group_id,l_user_table_id)