DBA Data[Home] [Help]

APPS.PER_ZA_WSP_LOOKUP dependencies on PAY_USER_TABLES

Line 1873: from PAY_USER_TABLES PUT

1869: And org_unit_tl.ORGANIZATION_ID = org_unit.ORGANIZATION_ID
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'

Line 1889: From PAY_USER_TABLES PUT

1885: l_user_table_id number;
1886: Begin
1887: Select PUT.USER_TABLE_ID
1888: into l_user_table_id
1889: From PAY_USER_TABLES PUT
1890: Where PUT.USER_TABLE_NAME = 'ZA_WSP_SKILLS_PRIORITIES'
1891: And PUT.legislation_code = 'ZA';
1892:
1893: for legal_entity_rec in cur_leg_entity