APPS.PER_ZA_WSP_LOOKUP dependencies on PAY_USER_COLUMNS

Line 1848: Description : It create user columns in PAY_USER_COLUMNS each for

1844: end copy_plan_2_trining;
1845:
1846: /****************************************************************************
1847: Name : wsp_populate_udt
1848: Description : It create user columns in PAY_USER_COLUMNS each for
1849: South Africa specific Legal Entity.
1850:
1851: *****************************************************************************/
1852: Procedure wsp_populate_udt is

Line 1874: , PAY_USER_COLUMNS PUC

1870: And org_unit_tl.LANGUAGE = userenv('LANG')
1871: And not exists
1872: ( Select 1
1873: from PAY_USER_TABLES PUT
1874: , PAY_USER_COLUMNS PUC
1875: , PAY_USER_COLUMNS_TL PUC_TL
1876: Where PUT.USER_TABLE_NAME = 'ZA_WSP_SKILLS_PRIORITIES'
1877: And PUT.legislation_code = 'ZA'
1878: And PUT.USER_TABLE_ID = PUC.USER_TABLE_ID

Line 1875: , PAY_USER_COLUMNS_TL PUC_TL

1871: And not exists
1872: ( Select 1
1873: from PAY_USER_TABLES PUT
1874: , PAY_USER_COLUMNS PUC
1875: , PAY_USER_COLUMNS_TL PUC_TL
1876: Where PUT.USER_TABLE_NAME = 'ZA_WSP_SKILLS_PRIORITIES'
1877: And PUT.legislation_code = 'ZA'
1878: And PUT.USER_TABLE_ID = PUC.USER_TABLE_ID
1879: And PUC_TL.USER_COLUMN_ID = PUC.USER_COLUMN_ID

Line 1896: pay_user_columns_pkg.insert_row (

1892:
1893: for legal_entity_rec in cur_leg_entity
1894: loop
1895:
1896: pay_user_columns_pkg.insert_row (
1897: p_rowid => l_row_id,
1898: p_user_column_id => l_usr_col_id,
1899: p_user_table_id => l_user_table_id,
1900: p_business_group_id => legal_entity_rec.business_group_id,