DBA Data[Home] [Help]

APPS.PSB_HR_POPULATE_DATA_PVT dependencies on PER_SHARED_TYPES

Line 1645: FROM per_shared_types

1641: /*For Bug No : 1527423 Start*/
1642: --SELECT shared_type_name
1643: SELECT system_type_cd
1644: /*For Bug No : 1527423 End*/
1645: FROM per_shared_types
1646: WHERE lookup_type = 'POSITION_AVAILABILITY_STATUS'
1647: AND shared_type_id = p_availability_status_id;
1648:
1649: Cursor C_data_extract is

Line 2203: from per_shared_types

2199: /*For Bug No : 1527423 Start*/
2200: --select shared_type_name
2201: select system_type_cd
2202: /*For Bug No : 1527423 End*/
2203: from per_shared_types
2204: where lookup_type = 'POSITION_AVAILABILITY_STATUS'
2205: and shared_type_id = p_availability_status_id;
2206:
2207: Cursor C_data_extract is

Line 2874: FROM per_shared_types

2870: /*For Bug No : 1527423 Start*/
2871: --SELECT shared_type_name
2872: SELECT system_type_cd
2873: /*For Bug No : 1527423 End*/
2874: FROM per_shared_types
2875: WHERE lookup_type = 'POSITION_AVAILABILITY_STATUS'
2876: AND shared_type_id = p_availability_status_id;
2877:
2878: Cursor C_data_extract is

Line 3495: from per_shared_types

3491: /*For Bug No : 1527423 Start*/
3492: --select shared_type_name
3493: select system_type_cd
3494: /*For Bug No : 1527423 End*/
3495: from per_shared_types
3496: where lookup_type = 'POSITION_AVAILABILITY_STATUS'
3497: and shared_type_id = p_availability_status_id;
3498:
3499: Cursor C_data_extract is